Oracle
1Z0-146 · Question #158
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?
Sign in or unlock 1Z0-146 to reveal the answer and full explanation for question #158. The question stem and answer options stay visible for context.
Introduction to PL/SQL
Question
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?
Options
- AUse the ALTER TABLE command with the ADD clause on the DEPT table.
- BUse the ALTER TABLE command with the ADD clause on the EMP table.
- CUse the ALTER TABLE command with the MODIFY clause on the DEPT table.
- DUse the ALTER TABLE command with the MODIFY clause on the EMP table.
- EThis task cannot be accomplished.
Unlock 1Z0-146 to see the answer
You've previewed enough free 1Z0-146 questions. Unlock 1Z0-146 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#ALTER TABLE#foreign key constraint#ADD clause#DDL