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

DBMS · Quiz 1 · 26 Oct 2025 (Afternoon)

14 questions · 50 marks · 60 min

Answer key Take as mock

Indian Institute of Technology Madras

BS Degree Programme · Examination & Study Paper

Database Management Systems

Quiz 1 · 26 Oct 2025 (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.

Q1MCQ4 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q2MCQ4 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q3MCQ4 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q4MCQ4 Marks·Choose one option
Key ↓
1. A4 rows and 6 columns
2. B3 rows and 7 columns
3. C4 rows and 5 columns
4. D3 rows and 6 columns
Q5MCQ3 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q6MCQ3 Marks·Choose one option
Key ↓
1. A
2. B
3. C
4. D
Q7MSQ4 Marks·Choose all correct options
Key ↓
1. A
2. B
3. C
4. D
Q8MSQ3 Marks·Choose all correct options
Asked 5 times Key ↓
1. AThere might exist an item that has not been produced by any company
2. BThere might exist a customer who has not ordered any item
3. CAn item can be ordered by multiple customers
4. DAn item cannot be produced by more than one company
Q9MSQ2 Marks·Choose all correct options
Key ↓
Identify the correct statement(s):
1. ALogical level of schema is analogous to type information of a variable in a program
2. BIn physical level of schema,application programs hide details of data types
3. CThe ability to modify the physical schema without changing the logical schema is called Logical Data Independence
4. DRelational Algebra falls under the Pure class of languages used for proving properties about computational power and for optimization
Q10NAT4 Marks·Write the number
Key ↓
Your answer:
Q11NAT4 Marks·Write the number
Key ↓
Your answer:
Read the passage below, then answer Q12–Q14
Q12MCQ3 Marks·Choose one option
Key ↓
1. A50
2. B10
3. C60
4. D59
Q13MSQ4 Marks·Choose all correct options
Key ↓
1. Aa → b → c
2. Bb → a → c
3. Cb → c → a
4. Dc → b → a
Q14MSQ4 Marks·Choose all correct options
Key ↓
Which of the following SQL queries is/are used to create table Teams?
1. A
2. B
3. C
4. D

Official Key

Master Answer Key & Explanations

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

Reveal Key

Q1D

Q2D

Q3A

Q4D

Q5C

Q6A

Q7A, C, D

Q8C, D

Q9A, D

Q104

Q112

Q12A

Q13C, D

Q14B

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