SQL QUIZ
1 .
The SQL keyword BETWEEN is used:

Correct Answer : Option (B)

for ranges.
  Show Answer
2 .
A subquery in an SQL SELECT statement:

Correct Answer : Option (C)

has a distinct form that cannot be duplicated by a join.
  Show Answer
3 .
The SQL -92 wildcards are ____ and ____ .

Correct Answer : Option (B)

percent sign (%); underscore (_)
  Show Answer
4 .
The Microsoft Access wildcards are ____ and ____ .

Correct Answer : Option (D)

question mark (?); asterisk (*)
  Show Answer
5 .
To define what columns should be displayed in an SQL SELECT statement:

Correct Answer : Option (A)

use FROM to name the source table(s) and list the columns to be shown after SELECT.
  Show Answer
6 .
________ was adopted as a national standard by ANSI in 1992.

Correct Answer : Option (B)

SQL
  Show Answer
7 .
The benefits of a standard relational language include which of the following?

Correct Answer : Option (A)

Reduced training costs
  Show Answer
8 .
Find the SQL statement below that is equal to the following: SELECT NAME FROM CUSTOMER WHERE STATE = 'VA';

Correct Answer : Option (C)

SELECT NAME FROM CUSTOMER WHERE STATE IN ('VA');
  Show Answer
9 .
DBMS provides insulation between program and data. This is referred to as _______

Correct Answer : Option (A)

program-data independence
  Show Answer
10 .
Which of the following is NOT a typical DBMS functionality?

Correct Answer : Option (B)

Manage the user interface of database application
  Show Answer