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.


  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.


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

  6. A.

     Oracle

    B.

     SQL

    C.

     Microsoft Access

    D.

     DBase


  7. SQL is:

  8. A.

     a programming language.

    B.

     an operating system.

    C.

     a data sublanguage.

    D.

     a DBMS.


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

  10. A.

     True

    B.

     False


  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


  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


  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


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

  18. A.

     True

    B.

     False


  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