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.

---

Definitions:

Preparation

The process of making ready or being made ready for use or consideration, often involving planning or research.

Employee Resistance

Opposition or pushback from employees against changes in the workplace, often due to concerns over the unknown or loss of status.

Regulatory Compliance

The state of being in accordance with established laws, regulations, standards, and specifications relevant to an organization's operations.

Explicit and Implicit Coercion

Directly or indirectly forcing someone to act in a certain way by using threats or manipulation rather than open persuasion.