Quiz Space

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

DBMS End Term 10 May 2026 — Question 7

Question 7

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

    Q1 is correct but Q2 is wrong

  2. B

    Q2 is correct but Q1 is wrong

  3. C

    Both Q1 and Q2 are wrong

  4. D

    Both Q1 and Q2 are correct

Show answer

Correct answer

  • D

    Both Q1 and Q2 are correct

See the whole paperTake it as a mock test

Question 7 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. 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: