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) ;
Correct Answer:

Verified
Correct Answer:
Verified
Q11: Under which conditions should you create an
Q12: What are the advantages of having views
Q14: To use a stored procedure in MySQL,a
Q25: In SQL,you use the CHECK clause to
Q25: What is the difference between entity integrity
Q30: The _ statement will take away user
Q33: A trigger is stored and compiled on
Q43: A stored procedure is placed on a
Q44: An individual can use a view to
Q46: Information about tables in the database is