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

DBMS · End Term · 22 Dec 2024 (Afternoon)

20 questions · 50 marks · 90 min

Answer key Take as mock

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

End Term · 22 Dec 2024 (Afternoon)

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.

Q1MCQ3 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
Q2MCQ3 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.
Q3MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A5
2. B4
3. C6
4. D3
Q4MCQ3 Marks·Choose one option
Asked 4 times Key ↓
1. A
2. B
3. C
4. D
Q5MCQ3 Marks·Choose one option
Asked 4 times Key ↓
1. AThe decomposition of R into R1 and R2 is dependency preserving.
2. BThe decomposition of R into R1 and R2 is lossless.
3. CThe schema R1 is in 3NF.
4. DThe schema R2 is in 2NF.
Q6MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. Ateam
2. Brating
3. Cage
4. Dtype
Q7MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q8MCQ2 Marks·Choose one option
Asked 2 times Key ↓
Consider seek time of your hard disk read head is 2ms, rotational speed is 30,000 RPM. The disk has 400 sectors/track and sector size is 128 bytes. What will be the transfer rate (KB/ms)?
1. A75 KB/ms
2. B25 KB/ms
3. C50 KB/ms
4. D100 KB/ms
Q9MCQ2 Marks·Choose one option
Asked 3 times Key ↓
Consider a non-empty B+-tree of order 16. What are the maximum and minimum number of keys that can be placed in the root node?
1. Amax. number of keys = 15, min. number of keys = 8.
2. Bmax. number of keys = 15, min. number of keys = 1.
3. Cmax. number of keys = 16, min. number of keys = 1.
4. Dmax. number of keys = 16, min. number of keys = 8.
Q10MCQ2 Marks·Choose one option
Asked 2 times Key ↓
Consider a multilevel index with five levels as L1, L2, L3, L4 and L5. Let L1 be the innermost and L5 be the outermost levels. Let the index blocking factor or the maximum number of entries held by a block be 25. If the number of blocks in level L1 is 12,50,000, then how many blocks are required at L2, L3, L4 and L5?
1. ANumber of blocks at L2 is 50000, Number of blocks at L3 is 2000, Number of blocks at L4 is 80, Number of blocks at L5 is 4
2. BNumber of blocks at L2 is 125000, Number of blocks at L3 is 2000, Number of blocks at L4 is 80, Number of blocks at L5 is 1
3. CNumber of blocks at L2 is 50000, Number of blocks at L3 is 2000, Number of blocks at L4 is 80, Number of blocks at L5 is 1
4. DNumber of blocks at L2 is 125000, Number of blocks at L3 is 2500, Number of blocks at L4 is 80, Number of blocks at L5 is 4
Q11MCQ2 Marks·Choose one option
Asked 5 times Key ↓
1. A5
2. B4
3. C3
4. D2
Q12MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. AID and name of students who have not taken any course from Biology department
2. BID and name of students who have taken courses from Biology department
3. CID and name of students who have taken all the courses from Biology department
4. DID and name of students who have not taken courses from other than Biology department
Q13MCQ1 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
Q14MSQ3 Marks·Choose all correct options
Key ↓
Consider the ER Diagram as shown below: Identify the correct relational schema for the relationship set Bank, Account and Manages Note: The primary key is underlined.
1. A
2. B
3. C
4. D
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.
Q16MSQ3 Marks·Choose all correct options
Asked 3 times Key ↓
1. A
2. B
3. C
4. D
Q17MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q18MSQ3 Marks·Choose all correct options
Asked 4 times Key ↓
1. A
2. B
3. C
4. D
Q19MSQ2 Marks·Choose all correct options
Asked 5 times Key ↓
Which of the following functional dependencies hold in the Students table?
1. A
2. B
3. C
4. D
Q20NAT3 Marks·Write the number
Asked 4 times Key ↓
Consider a Block nested loop join for the two relations, instructor and department. Assuming the worst-case memory availability and instructor as the outer relation, the provided details are as follows: What is the number of blocks in the inner relations?
Your answer:

Official Key

Master Answer Key & Explanations

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

Reveal Key

Q1D

Q2C

Q3A

Q4A

Q5B

Q6B

Q7A

Q8B

Q9B

Q10A

Q11D

Q12A

Q13B

Q14A

Q15B, C

Q16A, C

Q17A, B

Q18C, D

Q19A, B

Q2059

Questions and answer keys are reproduced from the official IIT Madras BS papers. BTechi is not affiliated with IIT Madras.