Multiple choice technology databases

The following statements are executed: create sequence my_seq; select my_seq.nextval from dual; select my_seq.nextval from dual; rollback; select my_seq.nextval from dual;

  1. 0

  2. 1

  3. 2

  4. 3
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

Sequences in Oracle are outside transaction control. After creating a sequence, first nextval returns 1, second returns 2. ROLLBACK does not affect sequence values, so the third nextval call returns 3, not 1.

Keep practicing — related questions