Which of the Following Is a Disadvantage of Using an Index

Multiple Choice

Which of the following is a disadvantage of using an index?

A) You can only add an index when the table is created.
B) You can't use indexes with foreign keys.
C) Record retrieval is less efficient.
D) The index must be updated whenever the data in the database changes.