Sunday, March 28, 2010

Add a foreign key

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.

1 comment:

  1. Ahaa, its pleasant dialogue on the topic of this post at this place at this
    blog, I have read all that, so at this time me also commenting
    at this place.
    My webpage: dora the explorer theme party

    ReplyDelete