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 C. select vehicle order by VehicleIdIdx asc. We must specify the table buffer named vehicle as in: select vehicle. For this question these are the correct answers: ( 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…

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 order by VehicleIdIdx desc;
Bselect vehicle index VehicleId;
Cselect vehicle order by VehicleIdIdx asc;
Dselect vehicle index VehicleIdIdx;

How the community answered

(44 responses)

A
14% (6)
B
5% (2)
C
73% (32)
D
9% (4)

Explanation

We must specify the table buffer named vehicle as in: select vehicle. For this question these are the correct answers: (* 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. * select vehicle order by vehicleIdIdx asc; We order on the index field VehicleIdIdx. (select vehicle order by VehicleId;) For this question these are the incorrect answers: * select vehicle index VehicleId; Must specify the index, not VehicleId. ( select vehicle order by VehicleId;) * select vehicle order by VehicleId desc; * select vehicle order by VehicleIdIdx desc; * select vehicle index VehicleId; VehicleId is not an index. * select VehicleId from vehicle order by VehicleId asc; We must specify the table buffer named vehicle (not select VehicleId). * select VehicleId from vehicle order by VehicleIdIdx asc; We must specify the table buffer named vehicle (not select VehicleId). Note: You use the order by keyword in select statements to order the data that is returned. Use the index hint keyword to specify the index that should be used in the query, and to sort the selected records in the manner that is defined by the index. Indexes optimize the selection of records. To select records in a specific order, combine the index hint keyword with an order by expression. If you want the output to be sorted in reverse order, use the reverse keyword. https://docs.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/dev-ref/xpp-data-query

Topics

#X++ SQL#select statement#index ordering#table buffer

Community Discussion

No community discussion yet for this question.

Full MB-500 Practice