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

CSE :: Database System 2 - CS

  1. The SQL keyword BETWEEN is used:

  2. A.

     for ranges.

    B.

     to limit the columns displayed.

    C.

     as a wildcard.

    D.

     None of the above is correct.

    View Answer

    Workspace

    Discuss Discuss in Forum


  3. A subquery in an SQL SELECT statement:

  4. A.

     can only be used with two tables.

    B.

     can always be duplicated by a join.

    C.

     has a distinct form that cannot be duplicated by a join.

    D.

     cannot have its results sorted using ORDER BY.

    View Answer

    Workspace

    Discuss Discuss in Forum


  5. ________ was adopted as a national standard by ANSI in 1992.

  6. A.

     Oracle

    B.

     SQL

    C.

     Microsoft Access

    D.

     DBase

    View Answer

    Workspace

    Discuss Discuss in Forum


  7. SQL is:

  8. A.

     a programming language.

    B.

     an operating system.

    C.

     a data sublanguage.

    D.

     a DBMS.

    View Answer

    Workspace

    Discuss Discuss in Forum


  9. The condition in a WHERE clause can refer to only one value.

  10. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  11. The ADD command is used to enter one row of data or to add multiple rows as a result of a query.

  12. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  13. SQL provides the AS keyword, which can be used to assign meaningful column names to the results of queries using the SQL built-in functions.

  14. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  15. The SELECT command, with its various clauses, allows users to query the data contained in the tables and ask many different questions or ad hoc queries.

  16. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  17. A SELECT statement within another SELECT statement and enclosed in square brackets ([...]) is called a subquery.

  18. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum


  19. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

  20. A.

     True

    B.

     False

    View Answer

    Workspace

    Discuss Discuss in Forum