uiz Space

September 2025 term · Database Management Systems · BSCS2001

Database Management Systems Quiz 2: 23 November 2025 (September 2025 term)

The IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 23 Nov 2025, in the September 2025 term: 14 questions for 50 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
14
Marks
50
Duration
120 min
MSQ
12
Numerical
2
Take as mock testPractise with answers

Updated

Official paper: IIT M DIPLOMA AN EXAM QDD2 23 Nov 2025 NEW · No negative marking.

Question 1

+3 marksOne or more correct options

Which of the following is the correct way to connect the Postgresql database using Python?

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • B
Question 1 on its own page

Question 2

+4 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • C
  • D
Question 2 on its own page

Question 3

+3 marksOne or more correct options

Consider the following table:

PlayerIDPlayerNameTeamRuns
001ViratIndia100
002RohitIndia100
003SmithAustralia70
004JasonEngland60
005RohitBangladesh65
006AsifPakistan50
007SmithNewzealand70

Table 1: Players

Which of the following functional dependencies hold in the Players table?

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • B
  • D
Question 3 on its own page

Question 4

+2 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • B
Question 4 on its own page

Question 5

+4 marksOne or more correct options

Let R(A,B,C,D,E) be a relational schema with the following functional dependencies:
F={A→BC,B→D,CD→E,E→A}\mathcal{F} = \{A \rightarrow BC, B \rightarrow D, CD \rightarrow E, E \rightarrow A\}

Consider the decomposition of R into:
R1(A,B,C)(A, B, C), R2(B,D)(B, D), R3(C,D,E)(C, D, E)

Which of the following statements is/are correct?

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • C
  • D
Question 5 on its own page

Question 6

+4 marksOne or more correct options

Select all that apply.

  1. A

    D1 is a lossless decomposition and all dependencies are preserved.

  2. B

    D1 is a lossy decomposition and all dependencies are preserved.

  3. C

    D2 is a lossy decomposition and dependencies are not preserved

  4. D

    Both D1 and D2 are lossy decompositions.

Show answer

Correct answers

  • A

    D1 is a lossless decomposition and all dependencies are preserved.

  • C

    D2 is a lossy decomposition and dependencies are not preserved

Question 6 on its own page

Question 7

+4 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • C
  • D
Question 7 on its own page

Question 8

+4 marksOne or more correct options

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • C
  • D
Question 8 on its own page

Question 9

+4 marksOne or more correct options

Consider the table R shown in the Table 2

XYZ
abd
ac..A..
acd
abe
xy..B..
xyz

Table 2: R

If X ↠\twoheadrightarrow Y and X ↠\twoheadrightarrow Z holds true on the given relation R, then choose the correct values for A and B.

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • D
Question 9 on its own page

Question 10

+4 marksOne or more correct options

Select all that apply.

  1. A

    The FDs X and Y are equivalent.

  2. B

    Y covers X

  3. C

    X covers Y

  4. D

    X is canonical cover of Y

Show answer

Correct answer

  • B

    Y covers X

Question 10 on its own page

Question 11

+3 marksNumerical answer
Show answer

Correct answer: 3

Question 11 on its own page

Question 12

+4 marksNumerical answer
Show answer

Correct answer: 35

Question 12 on its own page

Question 13

+3 marksOne or more correct options

The university database maintains information about students, the courses they take, and the departments offering those courses. The relation is designed as follows:

Enrollment(Student_ID,Student_Name,Course_ID,Course_Name,Dept_Name,Dept_Head)(Student\_ID, Student\_Name, Course\_ID, Course\_Name, Dept\_Name, Dept\_Head)

The functional dependencies applicable to Enrollment are:

F={Student_ID→Student_Name,Course_ID→Course_Name,Course_ID→Dept_Name,Dept_Name→Dept_Head}\begin{aligned} &\mathcal{F} = \{Student\_ID \rightarrow Student\_Name, \\ &Course\_ID \rightarrow Course\_Name, \\ &Course\_ID \rightarrow Dept\_Name, \\ &Dept\_Name \rightarrow Dept\_Head\} \end{aligned}

Based on the above data, answer the given subquestions.

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answers

  • A
  • B
  • C
Question 13 on its own page

Question 14

+4 marksOne or more correct options

The university database maintains information about students, the courses they take, and the departments offering those courses. The relation is designed as follows:

Enrollment(Student_ID,Student_Name,Course_ID,Course_Name,Dept_Name,Dept_Head)(Student\_ID, Student\_Name, Course\_ID, Course\_Name, Dept\_Name, Dept\_Head)

The functional dependencies applicable to Enrollment are:

F={Student_ID→Student_Name,Course_ID→Course_Name,Course_ID→Dept_Name,Dept_Name→Dept_Head}\begin{aligned} &\mathcal{F} = \{Student\_ID \rightarrow Student\_Name, \\ &Course\_ID \rightarrow Course\_Name, \\ &Course\_ID \rightarrow Dept\_Name, \\ &Dept\_Name \rightarrow Dept\_Head\} \end{aligned}

Based on the above data, answer the given subquestions.

Select all that apply.

  1. A
  2. B
  3. C
  4. D
Show answer

Correct answer

  • D
Question 14 on its own page