Quiz Space

Database Management Systems Quiz 1: 13 July 2025 (May 2025 term)

Question 1

+4 marksOne correct option

Consider the following table Sales:

EmpIDRegionAmount
101East5000
102East3000
103West7000
104East2000
105West4000
106North3500

Table : Sales

SQL Query:

sql
SELECT Region, SUM(Amount) AS TotalSales
FROM Sales
WHERE Amount > 3000
GROUP BY Region
HAVING SUM(Amount) > 6000;

What will be the output of the query?

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

Question 2

+4 marksOne correct option

Consider the following SQL statements executed in sequence on a table students:

sql
CREATE TABLE students (
    roll_no INT PRIMARY KEY,
    name VARCHAR(50),
    marks INT
);


INSERT INTO students VALUES (1, 'Amit', 80);
INSERT INTO students VALUES (2, 'Neha', 90);
INSERT INTO students VALUES (3, 'Ravi', 70);


UPDATE students
SET marks = marks + 10
WHERE marks < 85;


DELETE FROM students
WHERE name = 'Neha';


INSERT INTO students (roll_no, name, marks)
VALUES (4, 'Neha', 95);

What will be the content of the students table after execution?

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

Question 3

+4 marksOne correct option

Consider the following relations:
auto_part(pid, pname, color)
auto_suppliers(sid, sname, location)
catalog(pid, sid, price)

TRC

  1. {x∣∃s∈auto_suppliers ∃c∈catalog ∃p∈auto_part(s.location=‘Mumbai’∧c.price=5000∧x.sid=c.sid∧x.pname=p.pname∧s.sid=c.sid∧p.pid=c.pid)}\{x \mid \exists s \in auto\_suppliers\ \exists c \in catalog\ \exists p \in auto\_part(s.location = \textit{‘Mumbai’} \land c.price = 5000 \land x.sid = c.sid \land x.pname = p.pname \land s.sid = c.sid \land p.pid = c.pid)\}
  2. {x∣∃p∈auto_parts ∃c∈catalog(p.pname=‘Suspension’∧c.price=5000∧x.pid=p.pid∧p.pid=c.pid)}\{x \mid \exists p \in auto\_parts\ \exists c \in catalog(p.pname = \textit{‘Suspension’} \land c.price = 5000 \land x.pid = p.pid \land p.pid = c.pid)\}
  3. {x∣∃p∈auto_parts ∃c∈catalog ∃s∈auto_suppliers(p.pname=‘Suspension’∧c.price=5000∧x.pid=p.pid∧x.sname=s.sname∧p.pid=c.pid∧s.sid=c.sid)}\{x \mid \exists p \in auto\_parts\ \exists c \in catalog\ \exists s \in auto\_suppliers(p.pname = \textit{‘Suspension’} \land c.price = 5000 \land x.pid = p.pid \land x.sname = s.sname \land p.pid = c.pid \land s.sid = c.sid)\}
  4. {x∣∃s∈auto_suppliers ∃c∈catalog(s.location=‘Mumbai’∧c.price=5000∧x.sid=c.sid∧s.sid=c.sid)}\{x \mid \exists s \in auto\_suppliers\ \exists c \in catalog(s.location = \textit{‘Mumbai’} \land c.price = 5000 \land x.sid = c.sid \land s.sid = c.sid)\}

DRC

a. {<m>∣∃m,n,o(<m,n,o>∈auto_parts∧n=‘Suspension’)∧∃a,b,c(<a,b,c>∈catalog∧c=5000∧m=a)}\{< m > \mid \exists m, n, o(< m, n, o > \in auto\_parts \land n = \textit{‘Suspension’}) \land \exists a, b, c(< a, b, c > \in catalog \land c = 5000 \land m = a)\}
b. {<p>∣∃p,q,r(<p,q,r>∈auto_suppliers∧r=‘Mumbai’)∧∃a,b,c(<a,b,c>∈catalog∧c=5000∧p=b)}\{< p > \mid \exists p, q, r(< p, q, r > \in auto\_suppliers \land r = \textit{‘Mumbai’}) \land \exists a, b, c(< a, b, c > \in catalog \land c = 5000 \land p = b)\}
c. {<p>∣∃p,q,r(<p,q,r>∈auto_suppliers∧r=‘Mumbai’)∧∃a,b,c(<a,b,c>∈catalog∧c=5000)}\{< p > \mid \exists p, q, r(< p, q, r > \in auto\_suppliers \land r = \textit{‘Mumbai’}) \land \exists a, b, c(< a, b, c > \in catalog \land c = 5000)\}
d. {<m>∣(<m,n,o>∈auto_parts∧n=‘Suspension’)∧(<a,b,c>∈catalog∧c=5000∧m=a)}\{< m > \mid (< m, n, o > \in auto\_parts \land n = \textit{‘Suspension’}) \land (< a, b, c > \in catalog \land c = 5000 \land m = a)\}
e. {<p,n>∣∃m,n,o(<m,n,o>∈auto_parts)∧∃p,q,r(<p,q,r>∈auto_suppliers∧r=‘Mumbai’)∧∃a,b,c(<a,b,c>∈catalog∧c=5000∧m=a∧p=b)}\{< p, n > \mid \exists m, n, o(< m, n, o > \in auto\_parts) \land \exists p, q, r(< p, q, r > \in auto\_suppliers \land r = \textit{‘Mumbai’}) \land \exists a, b, c(< a, b, c > \in catalog \land c = 5000 \land m = a \land p = b)\}
f. {<m,q>∣∃m,n,o(<m,n,o>∈auto_parts∧n=‘Suspension’)∧∃p,q,r(<p,q,r>∈auto_suppliers)∧∃a,b,c(<a,b,c>∈catalog∧c=5000∧m=a∧p=b)}\{< m, q > \mid \exists m, n, o(< m, n, o > \in auto\_parts \land n = \textit{‘Suspension’}) \land \exists p, q, r(< p, q, r > \in auto\_suppliers) \land \exists a, b, c(< a, b, c > \in catalog \land c = 5000 \land m = a \land p = b)\}
g. {<p,n>∣∃m,n,o(<m,n,o>∈auto_parts)∧∃p,q,r(<p,q,r>∈auto_suppliers∧r=‘Mumbai’)∧∃a,b,c(<a,b,c>∈catalog∧c=5000)}\{< p, n > \mid \exists m, n, o(< m, n, o > \in auto\_parts) \land \exists p, q, r(< p, q, r > \in auto\_suppliers \land r = \textit{‘Mumbai’}) \land \exists a, b, c(< a, b, c > \in catalog \land c = 5000)\}
h. {<m,q>∣∃m,n,o(<m,n,o>∈auto_parts∧n=‘Suspension’)∧∃p,q,r(<p,q,r>∈auto_suppliers)∧∃a,b,c(<a,b,c>∈catalog∧c=5000)}\{< m, q > \mid \exists m, n, o(< m, n, o > \in auto\_parts \land n = \textit{‘Suspension’}) \land \exists p, q, r(< p, q, r > \in auto\_suppliers) \land \exists a, b, c(< a, b, c > \in catalog \land c = 5000)\}

Match the TRC expression to its correct equivalent DRC expression.

  1. A

    1-e, 2-d, 3-f, 4-c

  2. B

    1-e, 2-a, 3-f, 4-b

  3. C

    1-g, 2-a, 3-h, 4-b

  4. D

    1-g, 2-d, 3-h, 4-c

11 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 Quiz 1 13 Jul 2025 paper

The IIT Madras BS Database Management Systems (DBMS) Quiz 1 paper sat on 13 Jul 2025, in the May 2025 term: 14 questions for 50 marks in 120 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 Quiz 1 13 Jul 2025 at a glance
TermMay 2025 term
SubjectDatabase Management Systems
Course codeBSCS2001
Questions14
Marks50
Duration120 min
MCQ11
MSQ1
Numerical2
Official paperIIT M DIPLOMA AN EXAM QDD2 13 July 2025
Negative markingNo negative marking.
Updated

Same Quiz 1, other subjects

More DBMS