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

DBMS · End Term · 22 Dec 2024 (Forenoon)

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 (Forenoon)

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.

Q1MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. Ateam
2. Brating
3. Cage
4. Dtype
Q2MCQ2 Marks·Choose one option
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q3MCQ2 Marks·Choose one option
Asked 2 times Key ↓
Consider seek time of your hard disk read head is 2ms, rotational speed is 60,000 RPM. The disk has 300 sectors/track and sector size is 256 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
Q4MCQ2 Marks·Choose one option
Asked 3 times Key ↓
Consider a non-empty B+-tree of order 13. What are the maximum and minimum number of keys that can be placed in the root node?
1. Amax. number of keys = 13, min. number of keys = 6.
2. Bmax. number of keys = 12, min. number of keys = 1.
3. Cmax. number of keys = 14, min. number of keys = 1.
4. Dmax. number of keys = 14, min. number of keys = 7.
Q5MCQ2 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 50. If the number of blocks in level L1 is 62,50,000, then how many blocks are required at L2, L3, L4 and L5?
1. ANumber of blocks at L2 is 125000, Number of blocks at L3 is 2500, Number of blocks at L4 is 50, Number of blocks at L5 is 1
2. BNumber of blocks at L2 is 125000, Number of blocks at L3 is 2000, Number of blocks at L4 is 50, Number of blocks at L5 is 1
3. CNumber of blocks at L2 is 120000, Number of blocks at L3 is 2400, Number of blocks at L4 is 40, Number of blocks at L5 is 1
4. DNumber of blocks at L2 is 120000, Number of blocks at L3 is 3000, Number of blocks at L4 is 60, Number of blocks at L5 is 1
Q6MCQ2 Marks·Choose one option
Asked 5 times Key ↓
1. A5
2. B4
3. C3
4. D6
Q7MCQ3 Marks·Choose one option
Asked 2 times Key ↓
1. A5
2. B4
3. C6
4. D3
Q8MCQ3 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
Q9MCQ1 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
Q10MSQ3 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.
Q11MSQ3 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
Q12MSQ3 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.
Q13MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q14MSQ3 Marks·Choose all correct options
Asked 2 times Key ↓
1. A
2. B
3. C
4. D
Q15MSQ3 Marks·Choose all correct options
Asked 4 times Key ↓
1. A
2. B
3. C
4. D
Q16MSQ3 Marks·Choose all correct options
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.
Q17MSQ3 Marks·Choose all correct options
Asked 5 times Key ↓
1. AA bank offers more than one loan
2. BAn account is managed by more than one bank
3. CEvery loan must be availed by at least one customer
4. DEvery customer must be holding at least one account
Q18MSQ2 Marks·Choose all correct options
Asked 3 times Key ↓
1. A
2. B
3. C
4. D
Q19MSQ2 Marks·Choose all correct options
Asked 5 times Key ↓
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: • Total number of block transfers: 25000 • Total number of seeks required: 500 • Number of block in the outer relation: 250 What is the number of blocks in the inner relation?
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

Q2A

Q3A

Q4B

Q5A

Q6C

Q7A

Q8A

Q9B

Q10A, C

Q11A, D

Q12A, C

Q13C, D

Q14A, B

Q15B, C

Q16A, C, D

Q17A, D

Q18B, D

Q19A, C, D

Q20100

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