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

Verified
Correct Answer:
Verified
Q4: To create the primary key clause for
Q5: A(n)_ is an action that occurs automatically
Q6: The statement,_,removes the table Smaller from a
Q7: In Access,a key symbol appears in the
Q7: When you create an index whose key
Q8: A(n)_ is a computer that is connected
Q10: Essentially,setting the value in a given field
Q11: Within relational model systems on both mainframes
Q12: To create the primary key clause for
Q14: The following command will enable Jones to