Consider the Schedule given below: | T_1 | T_2 | T_3 | |---|---|---| | | | R(D) | | | R(A) | | | R(C) | | | | | W(A) | | | | R(B) | | | | R(C) | | | | | R(E) | | R(A) | | | | | R(D) | | | W(A) | | | | | | W(B) | | R(E) | | | Which of the following statements is/are correct about the given Schedule?

(A) A precedence graph of the schedule is acyclic

(D) The given schedule is view serializable and conflict serializable

(B) The given schedule is not view serializable

(C) The given schedule is view serializable but not conflict serializable

Database Management Systems · End Term · 22 Dec 2024 · September 2024 term · Set QDF1

Question 11: Consider the Schedule given below: | T_1 | T_2 | T_3 | |…

Question 11

+3 marksOne or more correct options

Consider the Schedule given below:

$T_1$	$T_2$	$T_3$
		R(D)
	R(A)
R(C)
	W(A)
	R(B)
	R(C)
		R(E)
R(A)
	R(D)
W(A)
		W(B)
R(E)

Which of the following statements is/are correct about the given Schedule?

Select all that apply.

A
A precedence graph of the schedule is acyclic
B
The given schedule is not view serializable
C
The given schedule is view serializable but not conflict serializable
D
The given schedule is view serializable and conflict serializable

Show answer

Correct answers

A
A precedence graph of the schedule is acyclic
D
The given schedule is view serializable and conflict serializable

See the whole paper Take it as a mock test

Question 11 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 22 Dec 2024, in the September 2024 term (IIT M FOUNDATION DIPLOMA AN EXAM QDF3 22 Dec 2024). It carries 3 marks.

This question was also asked in

DBMS End Term — 3 Sept 2023, Set QPD1-S2 · question 5

Question 11: Consider the Schedule given below: | T_1 | T_2 | T_3 | |…

Question 11

This question was also asked in

More questions from this paper