Which of the Following Is a Disadvantage of Using an Index

question 39

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.