What is TRUE about Pre-claiming lock protocol?

12. What is TRUE about Pre-claiming lock protocol?

  1. In pre-claiming lock protocols, all items on which locks are needed are analyzed by evaluating the transaction.
  2. It requests the DBMS for a lock on all the data items before initiating the transaction.
  3. This protocol allows the transaction to begin if all the locks have been granted.
  4. All of the above

Answer: D) All of the above

Explanation:

In case of Pre-claiming lock protocol -

  1. In pre-claiming lock protocols, all items on which locks are needed are analyzed by evaluating the transaction.
  2. It requests the DBMS for a lock on all the data items before initiating the transaction.
  3. This protocol allows the transaction to begin if all the locks have been granted.

Comments and Discussions!





Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.