Given an instance of the STUDENTS relation as shown below: For ( StudentName, StudentAge) to be a key for this instance, the value X should NOT be equal to …
Topic-wise GATE CS PYQs with verified steps
GATE CSE 2014 Set 2 · Q22
Time

Your answerNumerical answer
Solution
Official answer: 19
Integrity Constraints and Normal FormsA set of attributes forms a key for a relation instance if and only if no two distinct tuples have identical values for that set of attributes (uniqueness property).
Examining the tuples in the given relation for :
If , the first tuple becomes , which is identical to the third tuple's . This would violate the uniqueness property required of a candidate key.
Therefore, should NOT be equal to 19.
Try the question first, then check your work.
Examiner trap
Check which existing tuple shares the same as the tuple containing .
This Integrity Constraints and Normal Forms previous year question is Q22 of the GATE CSE 2014 Set 2 paper. Find more GATE CSE PYQs on Integrity Constraints and Normal Forms in Databases, or browse all GATE CSE PYQs.
Free diagnostic
Take the 20-minute diagnostic: the 3 topics that cost you the most marks, and a rank range. Or sit 5 related Integrity Constraints and Normal Forms PYQs now with no account.
An official question by email at 7 AM IST, with a link to its verified solution. Unsubscribe in one click.
Integrity Constraints and Normal Forms has 30 GATE CSE PYQs across 20 papers from 2011 to 2026. 4 of them are 1-mark NAT questions like this one, and GATE CSE 2014 Set 2 has 2.
How GATE tests Integrity Constraints and Normal FormsIndependent practice explanation verified by the GateAI team. GATE is conducted by the IITs; question text follows the official paper.