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:

Break-even Point

The point at which cost or expenses and revenue are equal, resulting in neither profit nor loss.

Variable Costs

Expenses that change in proportion to the activity of a business, such as costs for raw materials.

Fixed Costs

Expenditures that do not change over a short period of time, regardless of the level of production or activity.

Break-even Point

The financial point at which total costs and total sales are equal, resulting in no net loss or gain for the business.