Quiz Space

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

DBMS End Term 10 May 2026 — Question 17

Question 17

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

A written answer, not marked automatically.

See the whole paperTake it as a mock test

Question 17 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 3 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. Q3Figure question
  4. Q4Figure question
  5. Q5Identify the hash function, that generates unique hash values for the following search key values: 11, 19, 25, 32, 7.
  6. Q6Figure question
  7. Q7Figure question
  8. Q8The query returns:
  9. Q9Schedule S is as given:
  10. Q10Figure question
  11. 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 →…
  12. Q12Which of the following sequences will result in the given tree?
  13. Q13Choose the correct statement(s).
  14. Q14Consider the E-R Diagram as shown below:
  15. Q15Consider the following log records of transactions where an immediate database modification scheme is used.
  16. 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…
  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: