MB6-704 · Question #31
You are developing queries to fetch data from the CustTable table. CustTable contains a field named City. There is a non-unique cluster index named city Idx in the City field. You need to fetch data…
Sign in or unlock MB6-704 to reveal the answer and full explanation for question #31. The question stem and answer options stay visible for context.
Question
You are developing queries to fetch data from the CustTable table. CustTable contains a field named City. There is a non-unique cluster index named city Idx in the City field. You need to fetch data from CustTable in ascending order based on City. What are three possible SQL statements that achieve this goal? Each correct answer presents a complete solution.
Options
- ASelect CustTable order by city ASC;
- BSelect CustTable index city;
- CSelect CustTable index cityIdx;
- DSelect city Iron CustTable;
- ESelect CustTable order by city;
Unlock MB6-704 to see the answer
You've previewed enough free MB6-704 questions. Unlock MB6-704 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.