Database Management Systems Quiz 2: 24 March 2024 (January 2024 term)

Question 1

+3 marksOne correct option

Let P and Q be two relations. Let D(P) be a decomposition of P based on a set M of functional dependencies. Let D(Q) be a decomposition of Q based on a set N of functional dependencies. It is known that one among D(P) and D(Q) is in 3NF and the other is in 2NF. In order to correctly classify D(P) and D(Q) as being in 3NF or 2NF,what is the MINIMAL test needed?

A
Test whether both are in 3NF
B
Test whether both are in 2NF
C
Test whether one of them is in 2NF
D
Test whether one of them is in 3NF

Question 2

+3 marksOne correct option

A
Maximum= 60, Minimum= 0
B
Maximum= 100, Minimum= 60
C
Maximum= 100, Minimum= 0
D
Maximum= 60, Minimum= 40

Question 3

+4 marksOne correct option

Consider the table Sample as shown below:

A	B	C	D
a1	b1	c1	d1
a1	b2	X	d2
a1	b2	c2	Y
a1	P	Q	d2

If the functional dependency $B \rightarrow C$ and multivalued dependency $A \rightarrow\rightarrow BC$ hold on table Sample, then what will be the values of X, Y, P, and Q?

A
X: c2, Y: d1, P: b2, Q: c2
B
X: c2, Y: d2, P: b2, Q: c2
C
X: c1, Y: d1, P: b1, Q: c1
D
X: c2, Y: d1, P: b1, Q: c1

12 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 2 24 Mar 2024 paper

The IIT Madras BS Database Management Systems (DBMS) Quiz 2 paper sat on 24 Mar 2024, in the January 2024 term: 15 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.

Feature	DBMS Quiz 2 24 Mar 2024 at a glance
Term	January 2024 term
Subject	Database Management Systems
Course code	BSCS2001
Questions	15
Marks	50
Duration	120 min
MCQ	6
MSQ	5
Numerical	4
Official paper	IIT M DIPLOMA AN EXAM QDD2 24 Mar 2024
Negative marking	No negative marking.
Updated	25 Sept 2026