1
You visited us
1
times! Enjoying our articles?
Unlock Full Access!
Byju's Answer
Consider the ...
Question
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 _______
Open in App
Solution
23
Total 4! =24 view equal serial schedule for S and only 1 for conflict equal.
Total 24-1 =23 which are view equal but not conflict
Suggest Corrections
2
Similar questions
Q.
Consider the following schedule:
S
:
W
1
(
A
)
W
2
(
B
)
W
3
(
B
)
W
4
(
B
)
The number of schedule which are view equal to S is _________
Q.
Consider the following schedule:
S
:
r
1
(
x
)
,
r
2
(
x
)
,
ω
2
(
x
)
,
ω
3
(
x
)
,
r
1
(
z
)
,
ω
1
(
x
)
Which of the following is true about the above 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 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 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
View More
Join BYJU'S Learning Program
Grade/Exam
1st Grade
2nd Grade
3rd Grade
4th Grade
5th Grade
6th grade
7th grade
8th Grade
9th Grade
10th Grade
11th Grade
12th Grade
Submit
Related Videos
Heredity
Watch in App
Join BYJU'S Learning Program
Grade/Exam
1st Grade
2nd Grade
3rd Grade
4th Grade
5th Grade
6th grade
7th grade
8th Grade
9th Grade
10th Grade
11th Grade
12th Grade
Submit
Solve
Textbooks
Question Papers
Install app