uiz Space

September 2025 term · Database Management Systems · BSCS2001

Database Management Systems Quiz 1: 26 October 2025, Set 1 (September 2025 term)

The IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 26 Oct 2025, in the September 2025 term, set 1: 16 questions for 52 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
52
Duration
120 min
MCQ
9
MSQ
4
Written
3
Take as mock testPractise with answers

Updated

Official paper: IIT M IMPROVEMENT AN EXAM QIM4 26 Oct · No negative marking.

Question 1

+1 markOne correct option

THIS IS QUESTION PAPER FOR THE SUBJECT "DIPLOMA LEVEL : DATABASE MANAGEMENT SYSTEMS (COMPUTER BASED EXAM)" ARE YOU SURE YOU HAVE TO WRITE EXAM FOR THIS SUBJECT? CROSS CHECK YOUR HALL TICKET TO CONFIRM THE SUBJECTS TO BE WRITTEN. (IF IT IS NOT THE CORRECT SUBJECT, PLS CHECK THE SECTION AT THE TOP FOR THE SUBJECTS REGISTERED BY YOU)

  1. A

    YES

  2. B

    NO

Show answer

Correct answer

  • A

    YES

Question 1 on its own page

Question 2

+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

  • D
    Figure from the original question paper
Question 2 on its own page

Question 3

+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

  • D
    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

  • A
    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

    4 rows and 6 columns

  2. B

    3 rows and 7 columns

  3. C

    4 rows and 5 columns

  4. D

    3 rows and 6 columns

Show answer

Correct answer

  • D

    3 rows and 6 columns

Question 5 on its own page

Question 6

+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 6 on its own page

Question 7

+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

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

Question 8

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

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
    Figure from the original question paper
Show answer

Correct answers

  • A
    Figure from the original question paper
  • C
    Figure from the original question paper
  • D
    Figure from the original question paper
Question 8 on its own page

Question 9

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

Select all that apply.

  1. A

    There might exist an item that has not been produced by any company

  2. B

    There might exist a customer who has not ordered any item

  3. C

    An item can be ordered by multiple customers

  4. D

    An item cannot be produced by more than one company

Show answer

Correct answers

  • C

    An item can be ordered by multiple customers

  • D

    An item cannot be produced by more than one company

Question 9 on its own page

Question 10

+2 marksOne or more correct options

Identify the correct statement(s):

Select all that apply.

  1. A

    Logical level of schema is analogous to type information of a variable in aprogram

  2. B

    In physical level of schema,application programs hide details of data types

  3. C

    The ability to modify the physical schema without changing the logical schemais called Logical Data Independence

  4. D

    Relational Algebra falls under the Pure class of languages used for provingproperties about computational power and for optimization

Show answer

Correct answers

  • A

    Logical level of schema is analogous to type information of a variable in aprogram

  • D

    Relational Algebra falls under the Pure class of languages used for provingproperties about computational power and for optimization

Question 10 on its own pageAlso asked in Quiz 1 26 Oct 2025

Question 11

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

A written answer, not marked automatically.

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

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

    50

  2. B

    10

  3. C

    60

  4. D

    59

Show answer

Correct answer

  • A

    50

Question 13 on its own page

Question 14

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

Select all that apply.

  1. A

    a → b → c

  2. B

    b → a → c

  3. C

    b → c → a

  4. D

    c → b → a

Show answer

Correct answers

  • C

    b → c → a

  • D

    c → b → a

Question 14 on its own page

Question 15

+4 marksOne correct option
Figure from the original question paper

Which of the following SQL queries is/are used to create table Teams?

  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 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