Microsoft
MB-500 · Question #232
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…
The correct answer is B. select vehicle order by VehicleId. You've hit your limit · resets 4am (America/New_York)
Develop and test code
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 order by VehicleIdIdx desc;
- Bselect vehicle order by VehicleId;
- Cselect vehicle order by vehicleIdIdx asc;
- Dselect vehicleId from vehicle order by vehicleId asc;
How the community answered
(19 responses)- A5% (1)
- B89% (17)
- C5% (1)
Explanation
You've hit your limit · resets 4am (America/New_York)
Topics
#X++ SQL#embedded SQL#order by clause#table buffer
Community Discussion
No community discussion yet for this question.