Quiz Space

Database Management Systems · End Term · 10 May 2026 · January 2026 term · Set 2

DBMS End Term 10 May 2026 — Question 3

Question 3

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

    {A → D, C → D, AB → C, D → A}

  2. B

    {C → D, AD → B, AB → D, D → C}

  3. C

    {A → B, C → D, AB → C, D → B}

  4. D

    {C → D, AB → D, B → A, A → D }

Show answer

Correct answer

  • D

    {C → D, AB → D, B → A, A → D }

See the whole paperTake it as a mock test

Question 3 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 10 May 2026, in the January 2026 term (Database Management Systems 06 May 26). It carries 2 marks.

More questions from this paper

  1. Q1Consider a B+ tree index to be built on the attribute EmployeeID of a table Employees, with the following properties: •…
  2. Q2Figure question
  3. Q4Figure question
  4. Q5Identify the hash function, that generates unique hash values for the following search key values: 11, 19, 25, 32, 7.
  5. Q6Figure question
  6. Q7Figure question
  7. Q8The query returns:
  8. Q9Schedule S is as given:
  9. Q10Figure question
  10. Q11Consider a relation schema S(A,B,C,D,E,G) and the set of functional dependencies, F = {A → BC, B → D, D → E, E → B, C →…
  11. Q12Which of the following sequences will result in the given tree?
  12. Q13Choose the correct statement(s).
  13. Q14Consider the E-R Diagram as shown below:
  14. Q15Consider the following log records of transactions where an immediate database modification scheme is used.
  15. Q16Consider you have a file in your hard disk of size 1200 KB. Seek time of your hard disk read head is 4 ms and rotationa…
  16. Q17Figure question
  17. Q18Figure question
  18. Q19Find the total number of super keys of S.
  19. Q20Consider a block nested-loop join for the two relations employees and works: