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:

Carbon Monoxide

A colorless, odorless toxic flammable gas formed by incomplete combustion of carbon.

Nicotine

A stimulant and addictive substance found in tobacco plants, commonly used in cigarettes and vaping products.

Tar

A dark, thick, and sticky liquid or semi-solid material derived from the distillation of organic matter, used in road construction and as a waterproofing agent.

Atomic Bombs

A weapon of mass destruction that derives its destructive force from nuclear reactions, either fission or a combination of fission and fusion.