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 ADD clause in the DEPT table.
B. Use the ALTER TABLE command with the ADD clause on the EMP table.
C. Use the ALTER TABLE command with the MODIFY clause on the DEPT table.
D. Use the ALTER TABLE command with the MODIFY clause on the EMP table.
E. This task cannot be accomplished.
Answer:[B]
Highlight to find out the answer.
Sunday, March 28, 2010
Add a foreign key
at 9:12 AM
Labels: Oracle, Oracle Query, Oracle Test, PL/SQL
Subscribe to:
Post Comments (Atom)
Ahaa, its pleasant dialogue on the topic of this post at this place at this
ReplyDeleteblog, I have read all that, so at this time me also commenting
at this place.
My webpage: dora the explorer theme party