Microsoft
MB-500 · Question #162
MB-500 Question #162: Real Exam Question with Answer & Explanation
Sign in or unlock MB-500 to reveal the answer and full explanation for question #162. The question stem and answer options stay visible for context.
Question
You are a Dynamics 365 Finance developer. You have a table named FMVehicle that contains a field named VehicleId. The table has an index named VehicleIdIdx on the VehicleId field. You declare a table buffer named vehicle to refer to the table. You need to select all records from the FMVehicle table in ascending order based on VehicleId field in the vehicle variable. Which embedded-SQL statement should you use?
Options
- Aselect vehicle index VehicleId;
- Bselect vehicle index VehicleIdIdx;
- Cselect VehicleId from vehicle order by VehicleIdIdx asc;
- Dselect vehicle order by VehicleId desc;
Unlock MB-500 to see the answer
You've previewed enough free MB-500 questions. Unlock MB-500 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.