adplus-dvertising
frame-decoration

Question

Which of the following statements is wrong?

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

Answer: (c).Time-Stamp Protocols suffer from cascading roll back where as 2-Phase locking Protocol do not

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:

Q. A sub class having more than one super class is called:

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?

Q. Which statement is false regarding data independence?

Q. In DBMS, deferred update means:

Q. Which statement is false regarding data independence ?

Q. Two phase protocol in a database management system is:

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 ?

Q. Immediate updates as a recovery protocol is preferable, when:

Q. Which of the following statement is wrong ?

Q. A subclass having more than one super class is called .................

Q. A schema describes:

Q. One approach to standardizing storing of data:

Q. In a relational schema, each tuple is divided in fields called:

Q. An embedded pointer provides:

Q. A locked file can be:

Q. An Entity - relationship diagram is a tool to represent:

Q. Multi-valued dependency among attribute is checked at which level ?

Q. A WINDOW into a portion of a data base is:

Q. The E-R model is expressed in terms of:

(i) Entities
(ii) The relationship among entities
(iii) The attributes of the entities