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.

Join The Discussion