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
Q2: The _ command will create an application
Q3: The command DELETE INDEX CustList; would remove
Q4: Access 2010 supports data macros.
Q6: Legal-values integrity is the property that states
Q6: Once you add an index to a
Q7: The SELECT command that creates the view,which
Q8: To change the field names in a
Q8: To create a view in Access,you simply
Q18: Views cannot be used to examine table
Q34: To create the primary key clause for
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents