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:

Excise Tax

A tax levied on specific goods, services, or transactions, often based on quantity purchased rather than value, such as taxes on cigarettes, alcohol, and fuel.

Excise Tax

A tax imposed on specific goods or services at purchase such as gasoline, tobacco, and alcohol.

Highly Inelastic

Describes a situation where the demand or supply for a good or service is hardly affected when the price changes.

Highly Elastic

Describes a situation where the demand or supply of a product changes significantly in response to changes in price.