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:

Implicit Costs

The opportunity costs associated with a company's own resources, not directly paid for with cash but are the result of using assets instead of investing them elsewhere.

Economic Profit

The difference between total revenue and the total costs, including both explicit and implicit costs, unlike accounting profit which only considers explicit costs.

Explicit Costs

Direct financial payments made to acquire resources or services for business operations.

Total Economic Costs

The sum of explicit and implicit costs representing the total resources expended in the production of goods or services.