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) ;

Question

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) ;

Quizplus · Accepted Answer

The correct command to create an index named RepBal with the keys RepNum and Balance and with the balances listed in descending order is option D - CREATE INDEX RepBal ON Customer (RepNum, Balance DESC). This command creates an index named RepBal on the table Customer with two keys RepNum and Balance. The DESC stands for descending order which means that the balances will be listed in descending order, as required.

To Create an Index Named RepBal with the Keys RepNum