Q12
Single choice
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?
