Examine this SQL statement:
Which two are true?
A. All existing rows in the ORDERS table are updated
B. The subquery is executed for every updated row in the ORDERS table
C. The subquery is executed before the UPDATE statement is executed
D. The subquery is not a correlated subquery
E. The UPDATE statement executes successfully even if the subquery selects multiple rows
|
Download Printable PDF. VALID exam to help you PASS. |
 |
AB is correct
BC
AB
AC
BD
AB
AB is correct
A is correct because there is where condition is NOT mentioned for the orders table
so all rows will be updated
B is correct because this is a correlated subquery so subquery is executed for every updated row in the ORDERS table
AC
I think CE…
A,c is correct