Home / Faculty / Advance Database Management System (ADBMS) / Question

Q. In two-phase locking protocol.

(A) All unlocking operations precede the first lock operation.
(B) All locking operations precede the first unlock operation.
(C) Locking and unlocking takes place simultaneously.
(D) None of the above.

Correct Answer - Option(B)

About Author:
R
Renu Phogat     View Profile
Hi, I am using MCQ Buddy. I love to share content on this website.

Discusssion

Login to discuss.

Related Posts

Q. What is the expansion of BCNF?

Q. An attribute of one table matching the primary key of another table, is called as

Q. Which of the following is not the state that the transaction undergoes?

Q. How many inference rules are there for functional dependencies?

Q. Who developed the BCNF?

Q. Given the functional dependencies X →W; X→Y; Y→Z and Z→PQ Which of the following doesn’t hold well?

Q. Transaction timestamp is

Q. Assume transaction A holds a shared lock R. If transaction B also requests for a sharedlock on R.

Q. A functional dependency of the form X→Y is trivial if

Q. If a relation scheme is in BCNF, then it is also in

View All Posts

More Faculties

Create Faculty
Cost Accounting
Current Affairs Nov 2022
Software Quality Management (SQM)
Basics of Database Management System
Communication Skills in English
Computer Graphics
Economics of Development
Business Communications
Pharmacology and Toxicology
Western Philosophy

View all faculties