Microsoft
MB-500 · Question #168
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 A. select VehicleId from vehicle order by VehicleIdIdx asc. Produces all records in ascending order (though only the VecicleID field will be displayed). Not B, Not D: select vehicle index is not the correct SQL syntax. Not C: must sort ascending, not descending
Develop business logic
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 VehicleId from vehicle order by VehicleIdIdx asc;
- Bselect vehicle index VehicleId;
- Cselect vehicle order by VehicleIdIdx desc;
- Dselect vehicle index VehicleIdIdx;
How the community answered
(44 responses)- A89% (39)
- B2% (1)
- C7% (3)
- D2% (1)
Explanation
Produces all records in ascending order (though only the VecicleID field will be displayed). Not B, Not D: select vehicle index is not the correct SQL syntax. Not C: must sort ascending, not descending
Topics
#X++ SQL#select statement#order by#table buffer
Community Discussion
No community discussion yet for this question.