We are committed on providing you with the latest and most accurate MB6-704 exam preparation products. If you want to pass Microsoft MB6-704 exam successfully, do not miss to read latest lead2pass Microsoft MB6-704 brain dumps on Lead2pass.
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 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.
A. Select CustTable order by city ASC;
B. Select CustTable index city;