A. Deleting a primary key that is referenced by a foreign key
B. All of the above
C. Updating a primary key that is referenced
D. Inserting a value in a foreign key column that does not exist in the referenced primary key
Answer: Option B
Solution (By JKSSB Mock Tests)
Any action that breaks referential integrity, such as inserting an orphan record, deleting a referenced record, or updating a referenced key, will violate the foreign key constraint.
Explanation:
Data independence is the capacity to change the database schema at one level without affecting the next higher level, minimizing impact on applications.
No comments yet. Be the first to start the discussion!