PrepAway - Latest Free Exam Questions & Answers

Which two statements about the C/AL LOCKTABLE command are true?

Which two statements about the C/AL LOCKTABLE command are true? (Each correct
answer presents a complete solution. Choose two.)

PrepAway - Latest Free Exam Questions & Answers

A.
All records in the table read by SQL Server are locked to ensure database integrity.

B.
The command is valid for all subsequent instances of record variables based on the table
within the transaction.

C.
Only records in the table within the filter are locked by SQL Server to ensure database
integrity.

D.
The command locks the table in SQL Server to ensure database integrity.

Explanation:
Ref: http://msdn.microsoft.com/en-us/library/dd301298.aspx


Leave a Reply