Oracle
1Z0-071 · Question #6
When does a transaction complete? (Choose all that apply.)
The correct answer is C. When a data definition language statement is executed D. When a TRUNCATE statement is executed after the pending transaction E. When a ROLLBACK command is executed. See the full explanation below for the reasoning.
Question
When does a transaction complete? (Choose all that apply.)
Options
- AWhen a PL/SQL anonymous block is executed
- BWhen a DELETE statement is executed
- CWhen a data definition language statement is executed
- DWhen a TRUNCATE statement is executed after the pending transaction
- EWhen a ROLLBACK command is executed
How the community answered
(37 responses)- A8% (3)
- B14% (5)
- C78% (29)
Community Discussion
No community discussion yet for this question.