Explanation: Lock is limited to the attributes of the relation. 10. Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
A. Record controller
B. Exclusive lock
C. Authorization rule
D. Two phase lock
Answer:A
Explanation: Lock is limited to the attributes of the relation. 10. Which of the following is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released?
A. Record controller B. Exclusive lock C. Authorization rule D. Two phase lock
Explanation: Two-phase lock is a procedure for acquiring the necessary locks for a transaction where all necessary locks are acquired before any are released. Sanfoundry Global Education & Learning Series – Database Management System.