PrepAway - Latest Free Exam Questions & Answers

Which two statements are true based on the query?

You have the following C/AL code segment:
ItemLedgerEntry.SETCURRENTKEY(“Item No.”);
ItemLedgerEntry.FINDSET;
You have the following query, based on the C/AL code segment:
SELECT * FROM “CRONUS International Ltd_$Item Ledger Entry” ORDER BY “Item No_”,
“Posting Date”, “Entry No_”

Which two statements are true based on the query? (Each correct answer presents a
complete solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
If the second key in the table is “Item No.”, then it must be disabled. The key “Item No.”,
“Posting Date” will be used instead.

B.
The key “Item No.”, “Posting Date” is the first key in the list that starts with the field “Item
No.” in the Item Ledger Entry table.

C.
The SQLIndex value of the key “Item No.”, “Posting Date” has been entered with the
value “Item No.”.

D.
The SQLIndex value of the key “Item No.” has been entered with the value “Item No.”,
“Posting Date”.

Explanation:
Ref: http://msdn.microsoft.com/en-us/library/hh168524(v=nav.70).aspx


Leave a Reply