Vidyalelo
Database · Q46

Introduction to SQL

Programming · Database · question 46

Q46

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

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
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.