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

DBMS · Recovery, logs & backup

15 questions · 35 marks · 5 papers

Answer key

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

Recovery, logs & backup

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. AT0 and T1 can be ignored.
2. BT0,T1, T2 and T3 can be ignored.
3. CT4 need to be undone.
4. DT0 and T3 need to be redone.
Q2NAT2 Marks·Write the number
Asked 5 times Key ↓
Your answer:

End Term · 13 Apr 2025 (FN)End Term

Q3MCQ2 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q4MCQ2 Marks·Choose one option
Asked 5 times Key ↓
1. A4
2. B5
3. C6
4. D7
Q5NAT3 Marks·Write the number
Asked 4 times Key ↓
Your answer:

End Term · 13 Apr 2025 (AN)End Term

Q6MCQ2 Marks·Choose one option
Asked 5 times Key ↓
1. A4
2. B5
3. C6
4. D3
Q7NAT3 Marks·Write the number
Asked 4 times Key ↓
Your answer:

End Term · 22 Dec 2024 (FN)End Term

Q8MCQ2 Marks·Choose one option
Asked 5 times Key ↓
1. A5
2. B4
3. C3
4. D6
Q9MCQ3 Marks·Choose one option
Asked 4 times Key ↓
1. AA = 1000, B = 750, C = 1700, D = 710
2. BA = 1000, B = 750, C = 1700, D = 690
3. CA = 1000, B = 350, C = 1700, D = 710
4. DA = 1000, B = 350, C = 1700, D = 690
Q10MCQ1 Mark·Choose one option
Key ↓
Consider the following statements: 1. Hot backup refers to keeping a database up and running while the backup is being performed concurrently. 2. Cold backup is mainly used for Transaction Log Backup. 3. Transactional Logging is used in circumstances where a possibly inconsistent backup is taken. Choose the correct option.
1. AStatements 1 and 2 are correct
2. BStatements 1 and 3 are correct
3. CAll the statements are correct
4. DOnly Statement 1 is correct
Q11MSQ3 Marks·Choose all correct options
Asked 3 times Key ↓
1. AT2 can be ignored and T3 needs to be redone.
2. BT4 needs to be undone and T5 needs to be redone.
3. CT1 needs to be redone and T4 can be undone.
4. DT3 needs to be undone and T4 needs to be redone.

End Term · 22 Dec 2024 (AN)End Term

Q12MCQ3 Marks·Choose one option
Asked 4 times Key ↓
1. A
2. B
3. C
4. D
Q13MCQ2 Marks·Choose one option
Asked 5 times Key ↓
1. A5
2. B4
3. C3
4. D2
Q14MCQ1 Mark·Choose one option
Key ↓
Consider the following statements: 1. Any transactions committed before the last checkpoint should be ignored. 2. Any transaction that was running at the time of failure needs to be redone. 3. It scans backwards from the end of the log to find the most recent < checkpointL > record. Choose the correct option.
1. AStatements 1 and 2 are correct
2. BStatements 1 and 3 are correct
3. CAll the statements are correct
4. DOnly Statement 1 is correct
Q15MSQ3 Marks·Choose all correct options
Asked 3 times Key ↓
Consider a state of transactions as shown in Figure 3. Which of the following statement(s) is/are correct according to the given figure?
1. AT1 can be ignored and T3 needs to be redone.
2. BT4 and T5 need to be undone.
3. CT1 needs to be redone and T4 can be undone.
4. DT2 needs to be undone and T4 needs to be redone.

Official Key

Master Answer Key & Explanations

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

Reveal Key

Q1A, C

Q24

Q3C

Q4C

Q5500

Q6D

Q72200

Q8C

Q9A

Q10B

Q11A, C

Q12A

Q13D

Q14B

Q15B, C

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.