Microsoft
MB-500 · Question #162
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 index VehicleIdIdx. The 'index VehicleIdIdx' statement will cause an Order By Asc of the fields contained in the index. In this case, that means an Order By Asc of the VehicleID field.
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 vehicle index VehicleId;
- Bselect vehicle index VehicleIdIdx;
- Cselect VehicleId from vehicle order by VehicleIdIdx asc;
- Dselect vehicle order by VehicleId desc;
How the community answered
(35 responses)- A3% (1)
- B91% (32)
- D6% (2)
Explanation
The 'index VehicleIdIdx' statement will cause an Order By Asc of the fields contained in the index. In this case, that means an Order By Asc of the VehicleID field.
Topics
#X++ SQL#table buffer#index select#embedded SQL
Community Discussion
No community discussion yet for this question.