uiz Space

January 2026 term · Database Management Systems · BSCS2001

Database Management Systems Quiz 1: 15 March 2026 (January 2026 term)

The IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 15 Mar 2026, in the January 2026 term: 16 questions for 51 marks in 120 minutes. Every question is below with its answer. Take it as a timed mock test to be marked, or read it through first.

Questions
16
Marks
51
Duration
120 min
MCQ
9
MSQ
3
Written
4
Take as mock testPractise with answers

Updated

Official paper: Database Management Systems 15 Mar 26 · No negative marking.

Question 1

+1 markOne correct option

Which of the following creates the schema of a database?

  1. A

    Data Definition Language

  2. B

    Data Manipulation Language

  3. C

    Data Control Language

  4. D

    All of these

Show answer

Correct answer

  • A

    Data Definition Language

Question 1 on its own page

Question 2

+4 marksOne or more correct options
Figure from the original question paper

Select all that apply.

  1. A

    CREATE TABLE Course ( id VARCHAR(5) PRIMARY KEY, name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor(id) )

  2. B

    CREATE TABLE Course ( id VARCHAR(5) PRIMARY KEY, name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor.id )

  3. C

    CREATE TABLE Course ( id VARCHAR(5), name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor, )

  4. D

    CREATE TABLE Course ( id VARCHAR(5), name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) PRIMARY KEY (id), FOREIGN KEY (instructor_id) REFERENCES Instructor(id) )

Show answer

Correct answers

  • A

    CREATE TABLE Course ( id VARCHAR(5) PRIMARY KEY, name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) REFERENCES Instructor(id) )

  • D

    CREATE TABLE Course ( id VARCHAR(5), name VARCHAR(255), term VARCHAR(7), pre_requisite VARCHAR(5), co_requisite VARCHAR(5), instructor_id VARCHAR(5) PRIMARY KEY (id), FOREIGN KEY (instructor_id) REFERENCES Instructor(id) )

Question 2 on its own page

Question 3

+4 marksOne or more correct options

Choose the correct option(s) from the following.

Choose the correct option(s) from the following.

Select all that apply.

  1. A
    Figure from the original question paper
  2. B
    Figure from the original question paper
  3. C
    Figure from the original question paper
  4. D

    —

Show answer

Correct answers

  • A
    Figure from the original question paper
  • B
    Figure from the original question paper
  • C
    Figure from the original question paper
Question 3 on its own page

Question 4

+4 marksOne correct option
Figure from the original question paper
  1. A
    Figure from the original question paper
  2. B
    Figure from the original question paper
  3. C
    Figure from the original question paper
  4. D
    Figure from the original question paper
Show answer

Correct answer

  • B
    Figure from the original question paper
Question 4 on its own page

Question 5

+4 marksOne correct option
Figure from the original question paper
  1. A
    Figure from the original question paper
  2. B
    Figure from the original question paper
  3. C
    Figure from the original question paper
  4. D
    Figure from the original question paper
Show answer

Correct answer

  • C
    Figure from the original question paper
Question 5 on its own page

Question 6

+4 marksOne correct option
Figure from the original question paper
  1. A

    WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id GROUP BY s.student_id, s.student_name ) SELECT * FROM AvgMarks WHERE avg_marks > 60

  2. B

    CREATE VIEW AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id WHERE m.marks > 60 GROUP BY s.student_id ) SELECT * FROM AvgMarks

  3. C

    WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id ) SELECT * FROM AvgMarks WHERE avg_marks > 60

  4. D

    SELECT student_id, student_name, AVG(marks) FROM Student NATURAL JOIN Marks WHERE AVG(marks) > 60

Show answer

Correct answer

  • A

    WITH AvgMarks AS ( SELECT s.student_id, s.student_name, AVG(m.marks) AS avg_marks FROM Student s JOIN Marks m ON s.student_id = m.student_id GROUP BY s.student_id, s.student_name ) SELECT * FROM AvgMarks WHERE avg_marks > 60

Question 6 on its own page

Question 7

+4 marksOne correct option
Figure from the original question paper
  1. A

    a-8, b-8, c-8, d-5, e-6

  2. B

    a-8, b-7, c-7, d-4, e-7

  3. C

    a-8, b-8, c-7, d-5, e-8

  4. D

    a-8, b-7, c-6, d-4, e-6

Show answer

Correct answer

  • D

    a-8, b-7, c-6, d-4, e-6

Question 7 on its own page

Question 8

+3 marksWritten answer
Figure from the original question paper
Show answer

A written answer, not marked automatically.

Question 8 on its own page

Question 9

+3 marksOne correct option
Figure from the original question paper
  1. A

    The table is empty.

  2. B

    Only movies 201 (Baahubali), 203 (RRR), 204 (Roja), and 207 (Bombay) remain.

  3. C

    Only movies 202 (PK) and 206 (3 Idiots) remain.

  4. D

    The delete fails due to foreign key constraint violation.

Show answer

Correct answer

  • B

    Only movies 201 (Baahubali), 203 (RRR), 204 (Roja), and 207 (Bombay) remain.

Question 9 on its own page

Question 10

+3 marksOne correct option
Figure from the original question paper
  1. A
    Figure from the original question paper
  2. B
    Figure from the original question paper
  3. C
    Figure from the original question paper
  4. D
    Figure from the original question paper
Show answer

Correct answer

  • C
    Figure from the original question paper
Question 10 on its own page

Question 11

+2 marksOne correct option
Figure from the original question paper
  1. A
    Figure from the original question paper
  2. B
    Figure from the original question paper
  3. C
    Figure from the original question paper
  4. D
    Figure from the original question paper
Show answer

Correct answer

  • A
    Figure from the original question paper
Question 11 on its own page

Question 12

+4 marksWritten answer
Figure from the original question paper
Show answer

A written answer, not marked automatically.

Question 12 on its own page

Question 13

+2 marksOne or more correct options

Which of the following options are not true with respect to weak entity set?

Select all that apply.

  1. A

    Weak Entity cannot exist independently and it has its own primary key.

  2. B

    It must have total participation in the identifying relationship.

  3. C

    Discriminator and Identifying relationship need not exist.

  4. D

    Discriminator is represented by underlining with a dashed line.

Show answer

Correct answers

  • A

    Weak Entity cannot exist independently and it has its own primary key.

  • C

    Discriminator and Identifying relationship need not exist.

Question 13 on its own page

Question 14

+4 marksWritten answer
Figure from the original question paper
Figure from the original question paper
Show answer

A written answer, not marked automatically.

Question 14 on its own page

Question 15

+4 marksOne correct option
Figure from the original question paper
Figure from the original question paper
  1. A

    Ram

  2. B

    Frank

  3. C

    Suresh

  4. D

    Thomas

Show answer

Correct answer

  • B

    Frank

Question 15 on its own page

Question 16

+1 markWritten answer
Figure from the original question paper
Show answer

A written answer, not marked automatically.

Question 16 on its own page