nerdexam
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

1Z0-882 question #49 exhibit 1
1Z0-882 question #49 exhibit 2

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.

Full 1Z0-882 Practice