January 26th, 2011

Section 15 – Anatomy of a SQL Statement

Oracle Quiz, by admin.

1. The order of operator precedence is

/ + – *
* – + /
* / + – (*)
None of the above

2. If you want to see all columns of data in a table, you use what symbol?

&
%
$
* –

3. SELECT * FROM departments; is a:

Keyword
Statement (*)
Declaration
Strategy

4. The SQL SELECT statement is capable of:

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

5. 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. (*)

6. What is a NULL value?

A perfect zero
A known value less than zero
A blank space
An unknown value(*)

Back Top

Responses to “Section 15 – Anatomy of a SQL Statement”

  1. Pingback:snk.to/DOgj

Leave a Reply