Examveda

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

A. True

B. False

Answer: Option A

Solution (By Examveda Team)

Option A: True - Indexes in a database do consume extra storage space because they are separate data structures that store indexed column values for quick retrieval. Additionally, whenever data in the indexed columns change, the index needs to be updated, which adds overhead maintenance time.

Conclusion:
The statement "Each index consumes extra storage space and also requires overhead maintenance time whenever indexed data change value" is Option A: True. Therefore, the correct answer is True.

This Question Belongs to Database >> Introduction To SQL

Join The Discussion

Related Questions on Introduction to SQL

The SQL WHERE clause:

A. limits the column data that are returned.

B. limits the row data are returned.

C. Both A and B are correct.

D. Neither A nor B are correct.