Question
a.
2-phase Locking Protocols suffer from deadlocks
b.
Time-Stamp Protocols suffer from more aborts
c.
Time-Stamp Protocols suffer from cascading roll back where as 2-Phase locking Protocol do not
d.
None of these
Posted under UGC NET computer science question paper DBMS
Engage with the Community - Add Your Comment
Confused About the Answer? Ask for Details Here.
Know the Explanation? Add it Here.
Q. Which of the following statements is wrong?
Similar Questions
Discover Related MCQs
Q. A recursive foreign key is a:
View solution
Q. A sub class having more than one super class is called:
View solution
Q. A relation R={A,B,C,D,E,F} is given with following set of functional dependencies:
F={A→B,AD→C,B→F,A→E}.
Which of the following is Candidate Key?
View solution
Q. Which statement is false regarding data independence?
View solution
Q. In DBMS, deferred update means:
View solution
Q. Which statement is false regarding data independence ?
View solution
Q. Two phase protocol in a database management system is:
View solution
Q. A relation R = {A, B, C, D, E, F} is given with following set of functional dependencies:
F = {A→B, AD→C, B→F, A→E}
Which of the following is candidate key ?
View solution
Q. Immediate updates as a recovery protocol is preferable, when:
View solution
Q. Which of the following statement is wrong ?
View solution
Q. A subclass having more than one super class is called .................
View solution
Q. A schema describes:
View solution
Q. One approach to standardizing storing of data:
View solution
Q. In a relational schema, each tuple is divided in fields called:
View solution
Q. An embedded pointer provides:
View solution
Q. A locked file can be:
View solution
Q. An Entity - relationship diagram is a tool to represent:
View solution
Q. Multi-valued dependency among attribute is checked at which level ?
View solution
Q. A WINDOW into a portion of a data base is:
View solution
Q. The E-R model is expressed in terms of:
(i) Entities
(ii) The relationship among entities
(iii) The attributes of the entities
View solution
Suggested Topics
Are you eager to expand your knowledge beyond DBMS? We've curated a selection of related categories that you might find intriguing.
Click on the categories below to discover a wealth of MCQs and enrich your understanding of Computer Science. Happy exploring!