Introduction to SQL – True or False

11. Indexes can usually be created for both primary and secondary keys.

A. True
B. False

Correct Answer:  A. True
Advertisement

12. Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value.

A. True
B. False

Correct Answer:  A. True
Advertisement

13. The HAVING clause acts like a WHERE clause, but it identifies groups that meet a criterion, rather than rows.

A. True
B. False

Correct Answer:  A. True
Advertisement

14. SQL is a data sublanguage.

A. True
B. False

Correct Answer:  A. True
Advertisement

15. The qualifier DISTINCT must be used in an SQL statement when we want to eliminate duplicate rows.

A. True
B. False

Correct Answer:  A. True
Advertisement

Leave A Comment?