Using frequent COMMIT statements in the code frees up resources like undo segments, locks acquired etc.
Reveal answer
Fill a bubble to check yourself
Keep practicing — related questions
- Without the use of ________ keyword in a cursor, the cursor is closed each time a commit is performed
- Locking can be used for
- Locking can be used for
- Ending an application program without disconnecting from queue manager will result in a commit of unit of w...
- When you COMMIT, is the cursor closed?
- When you COMMIT, is the cursor closed?
- With optimistic locking a user may have to redo their work when a conflict occurs?
- Can you use a commit statement within a database trigger?