How would you add a foreign key constraint on the dept_no column in - ProProfs Discuss
Topics
Products
Follow Us:

How would you add a foreign key constraint on the dept_no column in the EMP table, referring to the ID column in the DEPT table?



A. Use the ALTER TABLE command with the MODIFY clause on the EMP table.
B. Use the ALTER TABLE command with the MODIFY clause on the DEPT table.
C. Use the ALTER TABLE command with the ADD clause on the EMP table.
D. This task cannot be accomplished.

This question is part of ORACLE SQL
Asked by Karthicksugadev, Last updated: Jan 16, 2020

+ Answer
Request

1 Answer

karthicksugadev

Karthicksugadev

Answered May 02, 2018

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

Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer
Search for Google images
Select a recommended image
Upload from your computer

Email Sent
We have sent an email to your address "" with instructions to reset your password.