Question

How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the id column in theDEPT table?Select one:O Use the ALTER TABLE command with the MODIFY clause on the EMP table.O Use the ALTER TABLE command with the MODIFY clause on the EMP table.O Use the ALTER TABLE command with the ADD clause on the EMP table.This task cannot be accomplished.O Use the ALTER TABLE command with the MODIFY clause on the DEPT table.​

Answer 1

Answer:

The correct answer is: Use the ALTER TABLE command with the ADD clause on the EMP table.

Explanation:

Answer 2

Answer:

Use the ALTER TABLE command with the ADD clause on the EMP table.

Explanation: