What Is the Purpose of an Index

question 38

Multiple Choice

What is the purpose of an index?

• A)to show which database objects depend on each other
• B)to identify primary, secondary, and alternate keys
• C)to improve database performance when queries request a sort order for records
• D)to store unique data for each record in the table

---

Definitions:

High IQ

A measurement indicating that an individual possesses cognitive abilities significantly above the average for their age group.

Longevity

The length or duration of a person's life or existence, often referring to individuals who live to a significantly old age.

Personality Types

A classification of different patterns of behavior, thought, and emotion that are characteristic of an individual's personal and social interactions.

Job Performance

An evaluation of how effectively an employee performs their work tasks, often considered in terms of productivity, efficiency, and quality.