Oracle

1Z0-071 · Question #285

Examine this SQL statement: Which two are true? (Choose two.)

The correct answer is B. The subquery is executed before the DELETE statement is executed. D. The subquery is executed for every row in the EMPLOYEES table. See the full explanation below for the reasoning.

Question

Examine this SQL statement:

Which two are true? (Choose two.)

Options

AThe subquery is not a correlated subquery.
BThe subquery is executed before the DELETE statement is executed.
CThe DELETE statement executes successfully even if the subquery selects multiple rows.
DThe subquery is executed for every row in the EMPLOYEES table.
EAll existing rows in the EMPLOYEES table are deleted.

How the community answered

(65 responses)

A
8% (5)
B
71% (46)
C
5% (3)
E
17% (11)

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion

Full 1Z0-071 Practice