Quiz Space

Database Management Systems · End Term · 31 Aug 2025 · May 2025 term

DBMS End Term 31 Aug 2025 — Question 19

Question 19

+3 marksNumerical answer
Show answer

Correct answer: 6

See the whole paperTake it as a mock test

Question 19 of 20 in the IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 31 Aug 2025, in the May 2025 term (IIT M DIPLOMA FN EXAM QDD1 31 Aug 2025). It carries 3 marks.

More questions from this paper

  1. Q1Consider the following relational schema: mentor(<u>mentorID</u>, mentorName, department)\ mentee(<u>menteeID</u>, ment…
  2. Q2Consider a non-empty B+-tree of order 17. What are the maximum and minimum number of keys that can be placed in the roo…
  3. Q3Given the following schema: students(studentID, firstName, lastName, admissionDate, deptID)\ departments(deptID, deptNa…
  4. Q4Figure question
  5. Q5Consider the table Bands given below: | ID | Name | Genre | YearEstablished | |---|---|---|---| | 001 | Pink Floyd | Pr…
  6. Q6Figure question
  7. Q7Consider the following log records of transactions where an immediate database modification scheme is used. | 1 | \lang…
  8. Q8Figure question
  9. Q9Figure question
  10. Q10Figure question
  11. Q11Figure question
  12. Q12Consider the table Student as shown in figure 2. | roll_no | sname | department | |---|---|---| | 1 | Stevie | Mechanic…
  13. Q13Consider a block nested-loop join for the two relation students and takes: | Relation | students | takes | |---|---|---…
  14. Q14Consider the instance of a relation R given in Table 1.\ Which among the following functional dependencies set can be i…
  15. Q15Consider the following tables: | PlayerID | PlayerName | |---|---| | 1 | Messi | | 2 | Muller | | 3 | Ronaldo | | 4 | M…
  16. Q16Figure question
  17. Q17Figure question
  18. Q18Consider a magnetic disk with 16 platters, 2 surfaces per platter, 1024 tracks per surface, 2048 sectors per track and …
  19. Q20Figure question