Introduction to SQL – True or False

6. The rows of the result relation produced by a SELECT statement can be sorted, but only by one column.

A. True
B. False

Correct Answer:  B. False
Advertisement

7. There is an equivalent join expression that can be substituted for all subquery expressions.

A. True
B. False

Correct Answer:  B. False
Advertisement

8. A dynamic view is one whose contents materialize when referenced.

A. True
B. False

Correct Answer:  A. True
Advertisement

9. SQL is a programming language.

A. True
B. False

Correct Answer:  B. False
Advertisement

10. SELECT DISTINCT is used if a user wishes to see duplicate columns in a query.

A. True
B. False

Correct Answer:  B. False
Advertisement

Leave A Comment?