In which three situations does a transaction complete?
A. When a DELETE statement is executed
B. When a ROLLBACK command is executed
C. When a PL/SQL anonymous block is executed
D. When a data definition language (DDL) statement is executed
E. When a TRUNCATE statement is executed after the pending transaction
ROLL BACK CANT CONTROL TRANSTACTION …it is not a DDL command
the question says that “…situations does a transaction complete?”
Yes it is true that, rollback is not a DDL command, but it was not the question.
Rollback is an TCL command (like COMMIT) –>Transactional Control Language.
In this situation it is correct.
so B,D,E
It’s ROLLBACK not ROLLBACK TO.