Microsoft
MB7-702 · Question #40
Which two statements about the C/AL LOCKTABLE command are true? (Each correct answer presents a complete solution. Choose two.)
The correct answer is B. The command is valid for all subsequent instances of record variables based on the table within the C. Only records in the table within the filter are locked by SQL Server to ensure database integrity. See the full explanation below for the reasoning.
Question
Which two statements about the C/AL LOCKTABLE command are true? (Each correct answer presents a complete solution. Choose two.)
Options
- AAll records in the table read by SQL Server are locked to ensure database integrity.
- BThe command is valid for all subsequent instances of record variables based on the table within the
- COnly records in the table within the filter are locked by SQL Server to ensure database integrity.
- DThe command locks the table in SQL Server to ensure database integrity.
How the community answered
(34 responses)- A12% (4)
- B82% (28)
- D6% (2)
Community Discussion
No community discussion yet for this question.