Question

It is usually a bad idea to create indexes on every attribute because Marks: 2 MSQ a) Every index requires additional CPU time and disk I/O overhead during inserts and dele- tions b) Indexes on non-primary keys might have to be changed on updates, although an index on the primary key might not c) If there are n attributes, then 2^n indexes would be needed which is exponential d) Each extra index requires additional storage space

Answer 1

Answers are a) ,c) and d).

Answer 2

The answers are Options a), b) and d).

It is usually a bad idea to create indexes on every attribute because

*Every index requires additional CPU time and disk I/O overhead during inserts and deletions.

*Indexes on non-primary keys might have to be changed on updates, although an index on the primary key might not.

*Each extra index requires additional storage space.