Question 11

A user executes a PL/SQL block containing complex data with several update and insert statements using multiple row subqueries and complex inline view. Under which of the following conditions will the database save the change after executing one or more PL/SQL blocks? (Choose two)

a.        When you disconnect from your session abnormally

b.       After PL/SQL block is executed successfully

c.       When you issue TRUNCATE command at SQL prompt

d.       When COMMIT command is issued

e.       When each UPDATE statement is executed