PrepAway - Latest Free Exam Questions & Answers

Based on the definition of these two tables, what happens if a department is deleted from the Department Table

Click the Exhibit button.

The exhibit shows the Employee and Department Tables.
Based on the definition of these two tables, what happens if a department is deleted from the Department Table
without checking that an employee belongs to the department.

PrepAway - Latest Free Exam Questions & Answers

A.
The employee data references a department that does not exist.

B.
SQL returns a referential integrity violation error message.

C.
The employee has no manager to report to.

D.
The employee data is updated automatically to the new department.


Leave a Reply