True/False
Indicate whether the
statement is true or false.
|
|
|
1.
|
SQL incorporates both DDL and DML.
|
|
|
2.
|
The number of columns and the data types of the
columns being selected must be identical in all the SELECT statements used in a set operation
query.
|
|
|
3.
|
SQL statements are not
case-sensitive.
|
|
|
4.
|
A null is the same as a zero or a
space
|
|
|
5.
|
Character strings and dates in the WHERE clause
must be enclosed by single quotation marks ('').
|
|
|
6.
|
Values that are specified with the BETWEEN
condition are inclusive
|
|
|
7.
|
The default sort order is
descending:
|
|
|
8.
|
Because the database stores dates as numbers,
you can perform calculations using arithmetic operators such as addition and
subtraction.
|
|
|
9.
|
Use the ON clause to specify a join condition.
This lets you specify join conditions separate from any search or filter conditions in the WHERE
clause.
|
|
|
10.
|
You use the WHERE clause to restrict
groups.
|
|
|
11.
|
Two methods used to implement conditional
processing (IF-THEN-ELSE logic) in a SQL statement are the CASE expression and the DECODE
function
|
|
|
12.
|
If any column value in an arithmetic expression
is null, the result is null.
|
Multiple Choice
Identify the
choice that best completes the statement or answers the question.
|
|
|
13.
|
Data definition commands are
sometimes called:
a. | DDL. | c. | SQL. | b. | DML. | d. | None of the above |
|
|
|
14.
|
Query and update commands are
sometimes called:
a. | DDL. | c. | SQL. | b. | DML. | d. | None of the
above. |
|
|
|
15.
|
With a SELECT statement, you can use the
following capabilities, except :
a. | Projection | c. | Joining | b. | Selection | d. | Searching |
|
|
|
16.
|
Which of the following is not a Rule of
Precedence:
a. | Multiplication and division occur before addition
and subtraction.
| c. | Parentheses are used to override
the default precedence or to clarify the statement.
| b. | Operators of the same priority are evaluated from left to
right. | d. | You must separate the operators with
spaces
|
|
|
|
17.
|
The concatenation operator
is.
|
|
|
18.
|
You use SQL statements
to:
a. | Retrieve, modify, add, and remove data from the
database
| c. | Create script files to store SQL
statements for repeated use in the future
| b. | Format, perform calculations on, store, and print query results in the form of
reports
| d. | All of the
above |
|
|
|
19.
|
The DESCRIBE
command
a. | Is not an SQL statement
| c. | Shows the format of the table | b. | Can be abbreviated
| d. | All of the
above
|
|
|
|
20.
|
The WHERE clause is used to
select:
a. | Tables
| c. |
Rows
| b. | Columns
| d. | None of the
Above
|
|
|
|
21.
|
The % symbol in the LIKE
condition
a. | Represents 1 character in the
string
| c. | Is invalid, you must use the
*
| b. | Represents 0,1 or more characters in the
string | d. | None of the Above
|
|
|
|
22.
|
The order of precedence in
compound conditions is
a. | OR,
AND,NOT
| c. | NOT, OR,
AND
| b. | AND, OR, NOT
| d. | NOT, AND, OR
|
|
|
|
23.
|
Substitution variables are represented by
the following
|