ORA-02292: Integrity constraint violated - child record found
The parent row still has child rows and the foreign key has no ON DELETE CASCADE or SET NULL. Delete or re-point the children first.
On the exam
This error belongs to the topic Tables and constraints of exam 1Z0-071.
In the SQL lab the same explanation appears next to your own statement, with a hint about what to change in it.