Multiple choice technology databases

Within the application MY_APP the following PREVIOUS VALUE expression references the sequence MY_SEQ: PREVIOUS VALUE FOR my_seq After which of the following events will the most recently generated value of MY_SEQ persist so that it can be returned to the active MY_APP application?

  1. After a ROLLBACK is issued

  2. .After the sequence is altered

  3. After the sequence is dropped

  4. After the current session ends
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

The PREVIOUS VALUE for a sequence is session-specific and persists within the active application session even after a transaction ROLLBACK. Altering or dropping the sequence deletes its definition or state, and ending the current session destroys the session-bound context where the previous value is tracked.

Keep practicing — related questions