BTechibtechi.in
Loading Loading
Free IIT Madras BS notes, PYQs and mock tests at btechi.in

DBMS · Transactions & serializability

11 questions · 33 marks · 5 papers

Answer key

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

Transactions & serializability

Official Paper

Examination Instructions & Guidelines

Solve on notebook/paper first before checking solutions.
MCQ: Exactly 1 option is correct. Negative marking applies.
MSQ: One or more options correct. Select all to score.
NAT: Numerical response. No negative marking.
Scientific calculator allowed for all calculations.
Official answer key is sealed at the end of this sheet.

End Term · 31 Aug 2025 (FN)End Term

Q1MSQ3 Marks·Choose all correct options
Asked 3 times Key ↓
1. ASchedule S can not be two-phase lockable.
2. BSchedule S can be two-phase lockable.
3. CSchedule S can be strict two-phase lockable.
4. DSchedule S is conflict serializable.
Q2NAT3 Marks·Write the number
Key ↓
Your answer:
Q3NAT3 Marks·Write the number
Asked 3 times Key ↓
Your answer:

End Term · 13 Apr 2025 (FN)End Term

Q4MSQ3 Marks·Choose all correct options
Asked 3 times Key ↓
1. ASchedule S is conflict serializable.
2. BSchedule S can be two-phase lockable.
3. CTwo phase lockable schedule are always serializable schedule.
4. DSchedule S is not View Serializable
Q5NAT3 Marks·Write the number
Asked 3 times Key ↓
Your answer:

End Term · 13 Apr 2025 (AN)End Term

Q6MCQ3 Marks·Choose one option
Asked 3 times Key ↓
Consider the following schedule S. S:W1(A), W3(A), W3(C), R2(A), W2(A), W1(B), W3(B) Consider the following statements. Statement 1: The given schedule S is Conflict serializable. Statement 2: All Conflict serializable schedules are 2-P lockable. Statement 3: The given schedule is 2-P lockable. Which of the following options is correct?
1. AStatement 1 is true and statement 3 is false
2. BStatement 2 is true and statement 3 is false
3. CStatements 1 and 2 are true
4. DAll these statements are true.
Q7NAT3 Marks·Write the number
Asked 3 times Key ↓
Your answer:

End Term · 22 Dec 2024 (FN)End Term

Q8MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. AA precedence graph of the schedule is acyclic
2. BThe given schedule is not view serializable
3. CThe given schedule is view serializable but not conflict serializable
4. DThe given schedule is view serializable and conflict serializable
Q9MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. AS1 and S2 are conflict equivalent.
2. BS1 and S2 are not conflict equivalent.
3. CS1 and S2 are view equivalent.
4. DS1 and S2 are not view equivalent.

End Term · 22 Dec 2024 (AN)End Term

Q10MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. AA precedence graph of the schedule is cyclic
2. BThe given schedule is not view serializable
3. CThe given schedule is view serializable but not conflict serializable
4. DThe given schedule is view serializable and conflict serializable
Q11MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. AStatements 1 and 4 are correct.
2. BStatements 1 and 3 are correct.
3. CStatements 2 and 3 are correct.
4. DStatements 2 and 4 are correct.

Official Key

Master Answer Key & Explanations

Official answer keys from IIT Madras BS past papers. Click any question to review.

Reveal Key

Q1A, C

Q26

Q38

Q4A, B, C

Q55

Q6A

Q74

Q8A, D

Q9A, C

Q10D

Q11C

Questions and answer keys are reproduced from the official IIT Madras BS papers. Topics and repeated question types are BTechi’s own grouping. BTechi is not affiliated with IIT Madras.