31. The SQL keyword BETWEEN is used:

A. for ranges.
B. to limit the columns displayed.
C. as a wildcard.
D. None of the above is correct.


Correct Answer:  A. for ranges.

32. A subquery in an SQL SELECT statement:

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.


Correct Answer:  C. has a distinct form that cannot be duplicated by a join.

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

A. Oracle
B. SQL
C. Microsoft Access
D. DBase


Correct Answer:  B. SQL

34. SQL is:

A. a programming language.
B. an operating system.
C. a data sublanguage.
D. a DBMS.


Correct Answer:  C. a data sublanguage.

Comments

No comments yet. Why don’t you start the discussion?

    Leave a Reply

    Your email address will not be published. Required fields are marked *

    10 − seven =