【简答题】A dedicated F excellence K sincerely B efficiency G designated L overrated C chronic H discarded M rejection D positive I Incorporate N differentiate E Coherently J deficiency O dissipate The key elem...
【单选题】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_...
A.
Only the row with department ID 40 is deleted in the DEPARTMENTS table.
B.
The statement fails because there are child records in the EMPLOYEES table with department ID 40.
C.
The 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.
D.
The 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.
E.
The row with department ID 40 is deleted in the DEPARTMENTS table. Also all the rows in the EMPLOYEES table are deleted.
F.
The statement fails because there are no columns specifies in the DELETE clause of the DELETE statement.