Assume that EMPLOYEE table has a foreign key constraint on the DEP_ID field that sets a relationship with the ID field of the DEPARTMENT table. Which of the following actions could be performed when deleting a record with ID=5 in the DEPARTMENT table?

Question

Accepted Answer

All records in the EMPLOYEE table for which DEP_ID=5, are also deleted

Accepted Answer

This operation will not be allowed if there are any records in the EMPLOYEE table with DEP_ID=5

Accepted Answer

The DEP_ID field for those records of the EMPLOYEE table for which DEP_ID=5, is set to NULL

Answer

This operation will also delete the EMPLOYEE table

Answer

This operation will not be allowed even if there’s no records in the EMPLOYEE table with DEP_ID=5

Crowdly

Assume that EMPLOYEE table has a foreign key constraint on the DEP_ID field that...

Want instant access to all verified answers on softserve.academy?