CameraIcon

SearchIcon

MyQuestionIcon

1

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

Business Studies

Planning Process

Consider a no...

Question

Consider a non-serial schedule S has 4 transactions and the execution of operation is given below:
$S : R_{1} (A), R_{4} (B), W_{3} (A), W_{2} (B), W_{4} (C), c o m m i t_{4}, W_{3} (C), W_{1} (A), c o m m i t 1, R_{2} (D), W_{3} (D),$

Rollback3;
The above given Schedule is

Open in App

Solution

As there is no dirty read operation for transaction T3 and the rollback of T3 requires only rollback of T3 and not any other transactions. Hence the schedule is said to be cascadeless schedule.

Suggest Corrections

thumbs-up

0

Similar questions

Q. Consider the following non serial schedule

S : R_{1} (A), R_{3} (B), W_{1} (A), W_{2} (A), W_{2} (B), W_{3} (B)

Which of the following protocol allows this schedule?

Q. Suppose a database schedule S which involves transactions T1, T2, ........, Tn. Consider the precedence graph of S with vertices representing the transactions and edges representing the conflicts. If S is serializable, which one of the following orderings of the vertices of the precedence graph is guaranteed to yield a serial schedule?

Q. Consider the following non serial schedule

S : W_{4} (E), R_{1} (C), R_{3} (A), R_{1} (E), W_{2} (A), R_{4} (A), W_{3} (A), R_{3} (B), W_{4} (A), W_{2} (D), W_{1} (A), R_{4} (C), W_{1} (B), R_{4} (D)

Which of the following is true statement?

Q. A schedule is having two transactions

T_{1 a n d T_{2}}

executing concurrently and the schedules are given below. Which of these schedules results in "write-read conflict" with the actions of transaction

T_{1} a n d T_{2}

on object x and y.

Q. Consider the following schedule S with data item x:

S : ω_{1} (x), r_{2} (x), ω_{3} (x), r_{4} (x), ω_{5} (x), r_{6} (x) ω_{7} (x), r_{9} (x), ω_{9} (x)

The number of serial schedules which are view equal schedule (S) but not conflict equal to schedule (S) are _______

View More

Join BYJU'S Learning Program

similar_icon

Related Videos

lock

Planning Process

BUSINESS STUDIES

Watch in App

explore_more_icon

Explore more

Planning Process

Standard XII Business Studies

Join BYJU'S Learning Program

CrossIcon