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?
Answer options
A
Use the ALTER TABLE command with the ADD clause on the EMP table.
B
Use the ALTER TABLE command with the MODIFY clause on the EMP table.
C
Use the CREATE TABLE command with the FOREIGN KEY clause.
D
Use the DROP TABLE command and recreate the table.
Correct answer: Use the ALTER TABLE command with the ADD clause on the EMP table.
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.