PrepAway - Latest Free Exam Questions & Answers

what happens?

When a COMMIT statement is executed, what happens?

PrepAway - Latest Free Exam Questions & Answers

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.


Leave a Reply