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

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

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

14. SQL is a data sublanguage.

A. True
B. False

Correct Answer:  A. True

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

Leave A Comment?

thirteen − 10 =