Quiz Space

Database Management Systems · Quiz 2 · 23 Nov 2025 · September 2025 term

DBMS Quiz 2 23 Nov 2025 — Question 6

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

See the whole paperTake it as a mock test

Question 6 of 14 in the IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 23 Nov 2025, in the September 2025 term (IIT M DIPLOMA AN EXAM QDD2 23 Nov 2025 NEW). It carries 4 marks.

More questions from this paper

  1. Q1Which of the following is the correct way to connect the Postgresql database using Python?
  2. Q2Figure question
  3. Q3Consider the following table: | PlayerID | PlayerName | Team | Runs | |---|---|---|---| | 001 | Virat | India | 100 | |…
  4. Q4Figure question
  5. Q5Let R(A,B,C,D,E) be a relational schema with the following functional dependencies:\ \mathcal{F} = {A \rightarrow BC, B…
  6. Q7Figure question
  7. Q8Figure question
  8. Q9Consider the table R shown in the Table 2 | X | Y | Z | |---|---|---| | a | b | d | | a | c | ..A.. | | a | c | d | | a…
  9. Q10Figure question
  10. Q11Figure question
  11. Q12Figure question
  12. Q13The university database maintains information about students, the courses they take, and the departments offering those…
  13. Q14The university database maintains information about students, the courses they take, and the departments offering those…