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:
Statement (*)


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

Solution for Test: Quiz: Introduction to The Oracle Academy
Solution for Test: Quiz: Data vs Information