Explanation:Bulk update (BU) locks are used when bulk copying data into a table and either the TABLOCK hint is specified 7. Which of the following locking hint is similar to NOLOCK ?
A. PAGLOCK
B. READCOMMITTED
C. READUNCOMMITTED
D. SERIALIZABLE
Answer:A
Explanation:Bulk update (BU) locks are used when bulk copying data into a table and either the TABLOCK hint is specified 7. Which of the following locking hint is similar to NOLOCK ?
A. PAGLOCK B. READCOMMITTED C. READUNCOMMITTED D. SERIALIZABLE
Explanation:Do not issue shared locks and do not honor exclusive locks. 8. Which of the following mode indicates the intention of the transaction to read all of the resources lower in the hierarchy ?