Microsoft
MB6-704 · Question #31
MB6-704 Question #31: Real Exam Question with Answer & Explanation
The correct answer is A. Select CustTable order by city ASC; D. Select city Iron CustTable; E. Select CustTable order by city;. An option on the order by or group by clause. The sorting is ascending. (Sort is ascending by de- DE: Default order is ascending so the ASC keyword can be omitted.
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;
Explanation
An option on the order by or group by clause. The sorting is ascending. (Sort is ascending by de- DE: Default order is ascending so the ASC keyword can be omitted.
Community Discussion
No community discussion yet for this question.