Oracle
1Z0-882 · Question #49
1Z0-882 Question #49: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-882 to reveal the answer and full explanation for question #49. The question stem and answer options stay visible for context.
Question
You have two tables: CREATE TABLE department ( Department_ID int unsigned NOT NULL auto_increment PRIMARY KEY, Department _Name varchar(12) NOT NULL ) ENGINE=InnoDB CREATE TABLE employee ( Employee_Number int unsigned NOT NULL PRIMARY KEY, Employee_Name varchar(10) NOT NULL, Department_ID int unsigned DEFAULT NULL, FOREIGN KEY (Department ID) REFERENCES Department (Department_ID) ON UPDATE SET NULL ON DELETE CASCADE ) ENGINE= InnoDB The tables have the data: Department You execute the statement: REPLACE INTO department (Department_ID, Department_Name) VALUES (1, `Admin'); What data is in the employee table after the statement?
Exhibits
Options
- AOption A
- BOption B
- COption C
- DOption D
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.

