To Create an Index Named RepBal with the Keys RepNum

question 9

Multiple Choice

To create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order,the command is ____.​

• 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:

Total Cost

The complete cost of production that includes both fixed and variable costs.

Fixed Cost

Expenses that do not change in the short term, irrespective of the level of production or sales volume.

Average Total Cost

The total cost of production divided by the number of units produced, calculating the per-unit cost to produce goods or services.

Variable Cost

Costs that change in proportion to the good or service that a business produces, such as raw materials and labor.