To Create an Index for the Customer Table Named RepBal

question 12

Multiple Choice

To create an index for the Customer table 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:

Deposits

Funds placed into an account at a financial institution for safekeeping or to earn interest.

Compounded Monthly

An interest calculation method where interest is added to the principal balance on a monthly basis, resulting in interest being earned on top of interest.

Monthly Payments

payments made once a month toward a loan or other financial obligation.

Loan

A sum of money that is borrowed and expected to be paid back with interest.