A sequence is created as follows:

create sequence seq1 maxvalue 50; If the current value is already 50, when you attempt to select SEQ1.NEXTVAL what will happen? (Choose the best answer.)

Question

A sequence is created as follows: create sequence seq1 maxvalue 50; If the current value is already 50, when you attempt to select SEQ1.NEXTVAL what will happen? (Choose the best answer.)

Accepted Answer

D. There will be an error.

Answer

A. The sequence will cycle and issue 0.

Answer

B. The sequence will cycle and issue 1.

Answer

C. The sequence will reissue 50.

A sequence is created as follows: create sequence seq1 maxvalue 50; If the current value is already 50, when you attempt to select SEQ1.NEXTVAL what will happen? (Choose the best answer.)

Question

Options

How the community answered

Community Discussion