To Create an Index Named RepBal with the Keys RepNum

question 36

Multiple Choice

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order, which command should you use?

• A) CREATE INDEX RepBal ON Customer (RepNum, Balance) ;
• B) CREATE INDEX RepBal Customer (RepNum DESC) ;
• C) CREATE INDEX ON Customer (RepNum, Balance ASC) ;
• D) CREATE INDEX RepBal ON Customer (RepNum, Balance DESC) ;

---

Definitions:

Multi-Directional Nature

The concept that development or change can occur in many different directions and is not linear.

Evolutionary Theory

A scientific theory that explains the diversity of life on Earth through the process of natural selection, where organisms adapt to their environment over generations.

Socioeconomic Status

An individual or group's economic and social position in relation to others, based on income, education, and occupation.

Shared Beliefs

Common or mutual ideas, values, or convictions held by a group, contributing to its cultural or social identity.