Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: 
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: 
What happens when you execute the DELETE statement?（） 
（单选题）
Examine the data in the EMPLOYEES and DEPARTMENTS tables: 
Also examine the SQL statements that create the EMPLOYEES and DEPARTMENTS tables: 
On the EMPLOYEES table, EMPLOYEE_ID is the primary key. MGR_ID is the ID of managers and refers to the EMPLOYEE_ID. DEPT_ID is foreign key to DEPARTMENT_ID column of the DEPARTMENTS table. On the DEPARTMENTS table, DEPARTMENT_ID is the primary key. Examine this DELETE statement: 
What happens when you execute the DELETE statement?（）
AOnly the row with department ID 40 is deleted in the DEPARTMENTS table.
BThe statement fails because there are child records in the EMPLOYEES table with department ID 40.
CThe row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 110 and 106 are deleted from the EMPLOYEES table.
DThe row with department ID 40 is deleted in the DEPARTMENTS table. Also the rows with employee IDs 106 and 110 and the employees working under employee 110 are deleted from the EMPLOYEES table.
EThe row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
FThe statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.
正确答案
答案解析
略
