Oracle Certification Exam Question: Download Oracle Certification PDF
Explain When does a transaction complete? (Choose all that apply.)
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 statement is executed
E. When a TRUNCATE statement is executed after the pending transaction
Answer:
B. When a ROLLBACK command is executed
D. When a data definition language statement is executed
E. When a TRUNCATE statement is executed after the pending transaction
D. When a data definition language statement is executed
E. When a TRUNCATE statement is executed after the pending transaction
| Previous Question | Next Question |
| what is the difference between TRUNCATE, DELETE, DROP? | What is the difference between primary key and foreign key |