GATE DA 2026 Set 1 — Question 26
Go beyond PYQs with Success TrackerAI-powered personalised practice and doubt support. Unlimited practice on eligible plans; AI usage limits apply.MSQ+1 / -0EasyIntegrity ConstraintsRelational ModelDatabase Management & Warehousing
Database Management & Warehousing → Relational Model → Integrity Constraints
Last updated
Question
Consider two relations r and s defined on the relational schemas R(A,B) and S(E,C), respectively. A is the primary key of R and E is a foreign key of S referencing A in R.Which of the following operations will NEVER violate the foreign key constraint?
Correct answer
(A) Inserting records into relation r; (B) Deleting records from relation s
Solution
The foreign key constraint states that for every tuple in , the value of attribute must exist in the attribute of relation (i.e., ).Let's analyze the operations:
1.Inserting into R (Option A): Adding a new record to adds a new value to . This expands the set of valid referenced values. It cannot invalidate existing references in . Thus, it never violates the FK constraint.
2.Deleting from S (Option B): Removing a record from removes a dependency. If the constraint held before, it holds after (removing an element from a subset keeps it a subset). Thus, it never violates the FK constraint.
3.Deleting from R (Option C): If we delete a record from whose value is referenced by some record in , the FK constraint is violated. This can violate the constraint.
4.Inserting into S (Option D): If we insert a record into with an value that does not exist in , the FK constraint is violated. This can violate the constraint.
Both A and B are correct operations that never violate the foreign key constraint.Continue learning with Success Tracker
A step still unclear? Work through it with support
Use Success Tracker to ask about the reasoning, then try another GATE DA question to check your understanding.
AI-powered practice· Unlimited practice on eligible plans
- PYQs with solutions
- Attempt available previous-year questions, then compare your reasoning with the worked solution. Coverage varies by stream.
- Practice that adapts
- Choose a topic, work on weaker areas and bookmark questions to revisit. Your attempts feed your progress tracking.
- AI doubt support
- Ask follow-up questions about a step or concept while practising, instead of stopping at the final answer.
Unlimited practice is available on eligible plans. Free practice and AI usage have limits; check the current plan allowances before choosing.
This page stays readable without an account. AI responses can be wrong; check them against the solution and source material.
More questions on Relational Model
2026 Set 1 Q17 be a relational schema with functional dependency set…2026 Set 1 Q18Consider that the visualization of a 3-dimensional data cube is showing Sales Quantity for each…2026 Set 1 Q32In a relational database, a B+ Tree Index is to be constructed for a relation on a key field. In a…2026 Set 1 Q41Consider a B+ Tree where the maximum number of key values in each leaf node is 2 and the maximum…2026 Set 1 Q42Consider the given relations , and . The relation has three columns , and .…