What is a 'foreign key' constraint specifically designed to prevent?
A. Unauthorized login attempts to the database.
B. The use of duplicate data values within the primary key column.
C. Slow search execution times.
D. Actions that would destroy links or introduce invalid references between tables.
Answer: Option D
Solution (By JKSSB Mock Tests)
A Foreign Key constraint enforces referential integrity, preventing updates or deletions that would leave orphaned child records pointing to non-existent parent rows.
No comments yet. Be the first to start the discussion!