adplus-dvertising
frame-decoration

Question

Which of the following statement is wrong ?

a.

2-phase locking protocol suffers from deadlocks

b.

Time-Stamp protocol suffers from more abort

c.

Time stamp protocol suffers from cascading rollbacks where as 2-phase locking protocol do not

d.

None of these

Answer: (c).Time stamp protocol suffers from cascading rollbacks 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 statement is wrong ?

Similar Questions

Discover Related MCQs

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

Q. Specialization is a ............... process.

Q. The completeness constraint has rules:

Q. The entity type on which the ................. type depends is called the identifying owner.

Q. Match the following:

(i) 5 NF              (a) Transitive dependencies eliminated
(ii) 2 NF             (b) Multivalued attribute removed
(iii) 3 NF            (c) Contains no partial functional dependencies
(iv) 4 NF            (d) Contains no join dependency

Q. The normalization of 1NF relations to 2NF involves:

Q. Tuple in relational algebra refers to:

Q. A relation R on a set X is said to be a partial ordering if R is

Q. An attribute or set of attributes within one relation that matches the candidate key of some(possibly the same) relation:

Q. With QBE, inserting records from one or more source tables into a single target table can be achieved by:

Q. SQL command to delete a column from an existing table: