CameraIcon

SearchIcon

MyQuestionIcon

1

You visited us 1 times! Enjoying our articles? Unlock Full Access!

Conflict Serializability

Pick up the c...

Question

Pick up the correct statements of the following:
P. All conflict serializable schedules are also view serializable schedules.
Q. R1(x), W2(y) are conflict operations
R. Shared and Exclusive locks are released only after commit in strict two phase locking protocol

Open in App

Solution

Operations on same data by different transactions will conflict.
Shared can be released before commit in strict 2PL

Suggest Corrections

thumbs-up

1

Similar questions

Q. Pick up the correct statements of the following:
P. Weak entity is always having total participation.
Q. Shared and Exclusive locks are released only after commit in rigorous two phase locking protocol.
R. ALL and ANY conditions will return TRUE if inner query return an empty set.

Q. Which of the following concurrency control protocols ensure both conflict serializability and freedom from deadlock?

I. 2-phase locking II. Time-stamp ordering

Q. Consider the following schedules involving three transaction.

S_{1} : W_{2} (x), W_{1} (x), R_{3} (x), W_{2} (y), R_{3} (y), R_{3} (z), R_{2} (x), R_{1} (y)

S_{2} : R_{3} (z), W_{2} (x), W_{2} (y), R_{1} (x), R_{3} (x), R_{2} (z), R_{3} (y), W_{1} (x)

Which of the above schedules are conflict serializable?

Q. Consider the following statements:
Statement I: A 2PL guaranteed schedule is surely be conflict serializable schedule.
Statements II: Wound wait and wait die algorithms are deadlock prevention algorithms and can cause more transaction aborts.
The number of the above statements is/are correct

Q. Consider the following four schedules due to three transactions (indicated by the subscript) using read and write on a data ite x, denoted by r(x) and

ω

(x) respectively. Which of them is/are conflict serializable.

View More

Join BYJU'S Learning Program

similar_icon

Related Videos

lock

Conflict Serializability

OTHER

Watch in App

explore_more_icon

Explore more

Conflict Serializability

Join BYJU'S Learning Program

CrossIcon