Multiple choice technology mainframe

Which of the following delete rules will not allow a row to be deleted from the parent table if a row with the corresponding key value still exists in the child table?

  1. DELETE

  2. CASCADE

  3. RESTRICT

  4. SET NULL
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The RESTRICT referential integrity rule prevents the deletion of a row in the parent table if any dependent rows exist in the child table. CASCADE would delete the child rows, SET NULL would set the foreign keys to null, and DELETE is not a standard delete rule.

Keep practicing — related questions