Multiple choice technology

If Start Value = 75 , Current Value = 80 and End Value = 1000,Increment by = 1 When the session runs what will be the value of the first sequence number for port NEXTVAL

  1. 75

  2. 80

  3. 81

  4. Session will fail.
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When NEXTVAL is called, it returns the Current Value and then increments by the Increment value. Since Current Value = 80 and Increment = 1, the first call to NEXTVAL returns 80 (not 81). The internal counter becomes 81 after this call, but the returned value is 80.

Keep practicing — related questions