8
AssignmentMultiple Choice

Designing a Relational Database

Question 8 • DRHS-Business and Tech BLOCK (07.4410030)

If the Cascade Update Related Records setting is activated, what happens when a change is made to the primary key of the primary table?

Answer
A
The Enforce Referential Integrity setting is deactivated.
B
Related records that refer to that primary key are orphaned.
C
A junction table is created to link the table with its related records.
D
Related records that refer to that primary key are edited to match.

Explanation

Cascade Update Related Records automatically updates matching foreign-key values when a primary key changes. So if the primary key is changed, related records are edited to refer to the new value. The correct choice is “Related records that refer to that primary key are edited to match.”

AI-written and checked against the verified answer.