Database - Introduction to SQL

Exercise :: Introduction to SQL - True or False

11. 

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

A. True
B. False

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

12. 

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

A. True
B. False

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

13. 

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

A. True
B. False

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

14. 

SQL is a data sublanguage.

A. True
B. False

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

15. 

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

A. True
B. False

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.