When a COMMIT statement is executed, what happens?

When a COMMIT statement is executed, what happens?
A. All locks held on the database are automatically released.
B. Data stored in global temporary tables is automatically deleted.
C. Open cursors defined WITH HOLD are closed, but their data is retained.
D. The current transaction is terminated and a new transaction boundary is started.

Download Printable PDF. VALID exam to help you PASS.

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.