Examine this SQL statement:
Which two are true?
A. The subquery is not a correlated subquery.
B. The subquery is executed before the DELETE statement is executed.
C. The DELETE statement executes successfully even if the subquery selects multiple rows.
D. The subquery is executed for every row in the EMPLOYEES table.
E. All existing rows in the EMPLOYEES table are deleted.
BD
I think CD
BC
“E” is correct too. I have tried it!
not necessarily, because if the subquery does not return data, nothing is removed