Oracle
1Z0-882 · Question #80
1Z0-882 Question #80: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #80. The question stem and answer options stay visible for context.
Question
You try to add a foreign key to the InnoDB table employees: Mysq1> ALTER TABLE employees ADD FOREIGN KEY (Department_ID) REFERENCES departments (Department_ID); ERROR 1215 (HY000): cannot add foreign key constraint Which command will provide additional information about the error?
Options
- ASHOW ERRORS
- BError 1215
- CSHOW ENGINE INNODB STATUS
- DSELECT FROM information_schema.INNODB_SYS_FOREIGN
Unlock 1Z0-882 to see the answer
You've previewed enough free 1Z0-882 questions. Unlock 1Z0-882 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.