Quiz Space

Database Management Systems End Term: 31 August 2025 (May 2025 term)

Question 1

+2 marksOne correct option

Consider the following relational schema:

mentor(mentorID, mentorName, department)
mentee(menteeID, menteeName, advisorID, rating)

advisorID is a foreign key referring to mentorID of the mentor relation. Assume that each mentor advises at least one mentee. Every mentee is required to give a rating to their mentor for feedback purposes. What does the following query return?

sql
SELECT mentorName
FROM mentor MR
WHERE NOT EXISTS (SELECT menteeID
FROM mentee ME
WHERE ME.advisorID = MR.mentorID
AND ME.rating <>'BAD');
  1. A

    Names of all the mentors with ‘GOOD’ rating from at least one of their mentees.

  2. B

    Names of all the mentors with ’GOOD’ rating from all their mentees.

  3. C

    Names of all the mentors with ‘BAD’ rating from at most one of their mentees.

  4. D

    Names of all the mentors with ’BAD’ rating from all their mentees.

Question 2

+2 marksOne correct option

Consider a non-empty B+-tree of order 17. What are the maximum and minimum number of keys that can be placed in the root node?

  1. A

    max. number of keys = 16, min. number of keys = 1.

  2. B

    max. number of keys = 17, min. number of keys = 1.

  3. C

    max. number of keys = 16, min. number of keys = 8.

  4. D

    max. number of keys = 17, min. number of keys = 8.

Question 3

+3 marksOne correct option

Given the following schema:

students(studentID, firstName, lastName, admissionDate, deptID)
departments(deptID, deptName, profID, buildingID)

You want to display the first names and admission dates of all first admissions in their respective departments in the building having ID=1001. Which of the following queries will display the correct result?

  1. A
  2. B
  3. C
  4. D

17 more questions in this paper

Sign in with Google — it is free — to see every question with its answer and explanation, practise it in learning mode, or take it as a timed mock test.

More on the DBMS End Term 31 Aug 2025 paper

The IIT Madras BS Database Management Systems (DBMS) End Term paper sat on 31 Aug 2025, in the May 2025 term: 20 questions for 50 marks in 180 minutes. The first 3 questions are below. Sign in with Google — it is free — to see the whole paper with its answers and explanations, in learning mode or as a timed mock test.

FeatureDBMS End Term 31 Aug 2025 at a glance
TermMay 2025 term
SubjectDatabase Management Systems
Course codeBSCS2001
Questions20
Marks50
Duration180 min
MCQ5
MSQ9
Numerical6
Official paperIIT M DIPLOMA FN EXAM QDD1 31 Aug 2025
Negative markingNo negative marking.
Updated

Same End Term, other subjects

More DBMS