Multiple choice technology mainframe

Which of the following statement establishes Syncpoint when an unsuccessful end of transaction is signaled?

  1. COMMIT

  2. ROLLBACK

  3. ALLOCATE

  4. DEALLOCATE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

ROLLBACK establishes a syncpoint (rollback point) when a transaction ends unsuccessfully, undoing all changes since the last commit. COMMIT establishes a syncpoint for successful transactions. ALLOCATE and DEALLOCATE are resource management commands for memory or cursors, unrelated to transaction syncpoints.

Keep practicing — related questions