Quiz: Anatomy of a SQL Statement

1. The SQL SELECT statement is capable of:

Selection and protection
Selection and projection (*)
Projection and updating
None of the above

2. If you want to see just a subset of the columns in a table, you use what symbol?
&
%
*
None of the above, instead of using a symbol you name the columns you want to see the data for. (*)

3. The order of operator precedence is
/ + – *
* – + /
* / + – (*)
None of the above

4. If you want to see all columns of data in a table, you use what symbol?
&
%
$
* (*)

5. SELECT * FROM departments; is a:
Keyword
Statement (*)
Declaration
Strategy

6. What is a NULL value?
A perfect zero
A known value less than zero
A blank space
An unknown value (*)