Data Base Management System | Week 7

Course Name: Data Base Management System

Course Link: Click Here

These are Data Base Management System Week 7 Assignment Answers


Q1. Consider the following schedule 8 of transactions T1 and T2.
The read operation on data item A is denoted by read(A) and the write operation on data item A is denoted by write (A).

image 10

Which of the following is TRUE about the schedule S?
a) S is serializable both as T1, T2 and T2, T1.
b) S is not serializable neither as T1, T2 nor T2, T1.
c) S is serializable only as T1, T2.
d) S is serializable only as T2, T1.

Answer: a) S is serializable both as T1, T2 and T2, T1.


These are Data Base Management System Week 7 Assignment Answers


Q2. Consider the following schedule S involving six transactions T1, T2, T3, T4, T5 and T6 :

image 11

R(X) denotes read operation on data item X by transaction Ti.
W(X) denotes write operation on data item X by transaction Ti.
Choose the correct option for the above transaction schedule.

a) The schedule is only view serializable schedule.
b) The schedule is only conflict serializable schedule.
c) The schedule is both view and conflict serializable schedule.
d) The schedule is neither conflict serializable nor view serializable schedule.

Answer: c) The schedule is both view and conflict serializable schedule.


These are Data Base Management System Week 7 Assignment Answers


Q3. Consider the following schedule S involving four transactions T1, T2, T3 and T4.

image 12

R(X) denotes read operation on data item X by transaction Ti.
W(X) denotes write operation on data item X by transaction Ti.
Identify the possible number of conflict serializable schedules of the above schedule S.

a) 1
b) 2
c) 3
d) 4

Answer: a) 1


These are Data Base Management System Week 7 Assignment Answers


Q4. Consider the following schedule S.

image 13

R(Y) denotes read operation on data item Y by Transaction Ti.
W(Y) denotes write operation on data item Y by Transaction T₁.
Identify the possible number of view serializable schedule of the above schedule S.

a) 1
b) 2
c) 3
d) 4

Answer: d) 4


These are Data Base Management System Week 7 Assignment Answers


Q5. Suppose in a database, there are four transactions T₁, T2, T3 and T₁. Transaction T₁ is waiting for transactions T₂ and T4, transaction T₂ is waiting for transaction T3 and T₁, and transaction T3 is waiting for transactions T4 to release a data item. Identify the correct wait-for graph for the above scenario.

image 14

Answer: b


Q6. Consider two transactions given below where lock-X(A) denotes T; has obtained an Exclusive-mode lock on item A and lock-S(A) denotes Ti has obtained a Shared-mode lock on item A.

image 15

Which of the following statement is (are) true?
a) Both T₁ and T₂ follow the rigorous two-phase locking protocol.
b) Both T₁ and T2 do not follow the rigorous two-phase locking protocol.
c) Only T₁ follows the rigorous two-phase locking protocol.
d) Only T₂ follows the rigorous two-phase locking protocol.

Answer: c) Only T₁ follows the rigorous two-phase locking protocol.


These are Data Base Management System Week 7 Assignment Answers


Q7. Suppose in a database, there are three transactions T₁, T2 and T3 with timestamp 12, 14 and 16 respectively. T₁ is holding a data item which T2 and T3 are requesting to acquire. Which of the following statement(s) is (are) correct in respect of Wound-Wait Deadlock Prevention scheme?
a) Transaction T₂ will wait for T₁ to release the data item.
b) Transaction T3 will wait for T₁ to release the data item.
c) Transaction T₂ will be aborted.
d) Transaction T3 will be aborted.

Answer: b, c


These are Data Base Management System Week 7 Assignment Answers


Q8. Consider the following schedule S.

image 16

R(Y) denotes read operation on data item Y by Transaction Ti.
W(Y) denotes write operation on data item Y by Transaction Ti.
Identify the correct statement(s) based on the above schedule S.

a) If T1 fails (aborted), only T2 must be rolled back.
b) If T1 fails (aborted), only T3 must be rolled back.
c) If T1 fails (aborted), both T2 and T3 must be rolled back.
d) If T1 fails (aborted), neither T2 nor T3 must be rolled back.

Answer: d) If T1 fails (aborted), neither T2 nor T3 must be rolled back.


These are Data Base Management System Week 7 Assignment Answers


Q9. Consider the following schedule S.

image 17

R(X) denotes read operation on data item X by Transaction Ti.
W(X) denotes write operation on data item X by Transaction T₁.
Choose the correct options for the above schedule.

a) The schedule is only recoverable schedule.
b) The schedule is only cascadeless schedule.
c) The schedule is recoverable schedule and cascadeless schedule both.
d) The schedule is neither recoverable nor cascadeless schedule.

Answer: a) The schedule is only recoverable schedule.


These are Data Base Management System Week 7 Assignment Answers


Q10. Identify the correct option(s) which is (are) used in Transaction Control Language (TCL).
a) Alter
b) Insert
c) Update
d) Savepoint

Answer: d) Savepoint


These are Data Base Management System Week 7 Assignment Answers



These are Data Base Management System Week 7 Assignment Answers

More Solutions of Data Base Management System: Click Here

More NPTEL Solutions: https://progiez.com/nptel/


These are Data Base Management System Week 7 Assignment Answers

This content is uploaded for study, general information, and reference purpose only.