Microsoft
MB7-702 · Question #2
MB7-702 Question #2: Real Exam Question with Answer & Explanation
The correct answer is A. If the second key in the table is "Item No.", then it must be disabled. D. The SQLIndex value of the key "Item No." has been entered with the value "Item No.", "Posting Date".. See the full explanation below for the reasoning.
Question
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.)
Options
- AIf the second key in the table is "Item No.", then it must be disabled.
- BThe key "Item No.", "Posting Date" is the first key in the list that starts with the field "Item No." in the
- CThe SQLIndex value of the key "Item No.", "Posting Date" has been entered with the value "Item No.".
- DThe SQLIndex value of the key "Item No." has been entered with the value "Item No.", "Posting Date".
Community Discussion
No community discussion yet for this question.