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

Verified
Correct Answer:
Verified
Q31: To create a view in Access, you
Q32: Discuss validation rules and validation text.
Q33: The command DEL INDEX CustList; would remove
Q34: One disadvantage of using views is that
Q35: Explain what is meant by a null
Q37: Describe a client/server system and how it
Q38: What database rule states that no field
Q39: Which of the following is a disadvantage
Q40: What SQL feature can you use if
Q41: Which command will create an application program's