marți, 24 noiembrie 2009

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



http://www.materie.ro/materie/quiz-anatomy-of-a-sql-statement-66

Niciun comentariu:

Trimiteţi un comentariu