Oracle
1Z0-882 · Question #64
1Z0-882 Question #64: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #64. The question stem and answer options stay visible for context.
Question
You attempt to create two new tables: CREATE TABLE
warehouse' ( id' int (11) NOT NULL AUTO_INCREMENT, name' varchar (20) NOT NULL, phone' varchar (20) NOT NULL, PRIMARY KEY (id) ) ENGINE=MyISAM CREATE TABLEwarehouseitem' ( warehouse_id' bigint (11) NOT NULL, item_id' int (11) NOT NULL, count' int(11) NOT NULL DEFAULT 0', KEY "warehouse_id' (`warehouse-id) , FOREIGN KEY (warehouse_id) REFFERENCES warehouse (id) ) ENGINE= InnoDB You get this error : ERROR 1215 ( HYooo): cannot add foreign key constraint Which two changes are required to permit these statements to execute without any error?Options
- AThe `warehouseitem' table must be managed by the MySAm storage engine.
- BThe `warehouse-table must be managed by the InnoDB storage engine.
- CThe foreign key clause must be reversed: FOREIGN KEY warehouse(1)REFERENCES
- DThe data types of the
warehouse'.'id' andwarehouseitem.warehouse_is columns must match. - EThe warehouse_id' column must be renamed
id' to match the definition on thewarehouse' table. - FA UNIQUE key must be defined for the columns (`item_id','warehouse_id').
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.