Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
1.
|
Which
of the following will actually describe the layout of a table to the DBMS? a. | SELECT
TABLE | c. | CREATE
TABLE | b. | DROP TABLE | d. | DELETE FROM TABLE | | | | |
|
|
|
2.
|
The
basic form of an SQL retrieval command is a. | SELECT-WHERE-FROM | c. | SELECT-WHERE | b. | CREATE-SELECT-FROM | d. | SELECT-FROM-WHERE | | | | |
|
|
|
3.
|
Which
of the following symbols are used to list all of the fields in a SELECT query?
|
|
|
4.
|
The
comparison operator used to check inequality is
|
|
|
5.
|
What
type of condition is formed by connecting two or more simple conditions? a. | compound | c. | conditional | b. | complex | d. | conducive | | | | |
|
|
|
6.
|
Which
operator should be used to connect a compound condition when both simple conditions need to be true
in order for the compound condition to be true?
|
|
|
7.
|
Which
operator should be used to connect a compound condition when only one of the simple conditions needs
to be true in order for the compound condition to be true?
|
|
|
8.
|
Using
which operator negates the evaluated condition?
|
|
|
9.
|
Which
operator is used to return all values that contain a certain collection of
characters?
|
|
|
10.
|
Which
operator could be used in place of a number of comparisons with the OR operator?
|
|
|
11.
|
In
order to sort the results of a query, which clause should be used? a. | SORT
BY | c. | ORDER
BY | b. | SELECT
BY | d. | GROUP
BY | | | | |
|
|
|
12.
|
In
order to sort in a high-to-low order, follow the sort key with the word a. | ASC. | c. | DESCENDING. | b. | DESC. | d. | DESCRIPTIVE. | | | | |
|
|
|
13.
|
SQL
has built-in functions which are also called a. | accumulative. | c. | affluent. | b. | assimilated. | d. | aggregate. | | | | |
|
|
|
14.
|
Which
function will give you a total number of rows returned by the query? |