Home / CSE / Database System 2 - CS :: Introduction to SQL

CSE :: Database System 2 - CS

  1. Which of the following do you need to consider when you make a table in SQL?

  2. A.

     Data types

    B.

     Primary keys

    C.

     Default values

    D.

     All of the above

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. SQL query and modification commands make up a(n) ________ .

  4. A.

     DDL

    B.

     DML

    C.

     HTML

    D.

     XML

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. When three or more AND and OR conditions are combined, it is easier to use the SQL keyword(s):

  6. A.

     LIKE only.

    B.

     IN only.

    C.

     NOT IN only.

    D.

     Both IN and NOT IN.

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. The Microsoft Access wildcards are ____ and ____ .

  8. A.

     asterisk (*); percent sign (%)

    B.

     percent sign (%); underscore (_)

    C.

     underscore(_); question mark (?)

    D.

     question mark (?); asterisk (*)

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

  10. A.

     SELECT NAME IN CUSTOMER WHERE STATE IN ('VA');

    B.

     SELECT NAME IN CUSTOMER WHERE STATE = 'VA';

    C.

     SELECT NAME IN CUSTOMER WHERE STATE = 'V';

    D.

     SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. Which one of the following sorts rows in SQL?

  12. A.

     SORT BY

    B.

     ALIGN BY

    C.

     ORDER BY

    D.

     GROUP BY

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. To sort the results of a query use:

  14. A.

     SORT BY.

    B.

     GROUP BY.

    C.

     ORDER BY.

    D.

     None of the above is correct.

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. To define what columns should be displayed in an SQL SELECT statement:

  16. A.

     use FROM to name the source table(s) and list the columns to be shown after SELECT.

    B.

     use USING to name the source table(s) and list the columns to be shown after SELECT.

    C.

     use SELECT to name the source table(s) and list the columns to be shown after USING.

    D.

     use USING to name the source table(s) and list the columns to be shown after WHERE.

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. SQL can be used to:

  18. A.

     create database structures only.

    B.

     query database data only.

    C.

     modify database data only.

    D.

     All of the above can be done by SQL.

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. The SQL statement that queries or reads data from a table is ________ .

  20. A.

     SELECT

    B.

     READ

    C.

     QUERY

    D.

     None of the above is correct

    View Answer

    Workspace

    Discuss Discuss in Forum