Evaluate the following CREATE SEQUENCE statement:

CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:

SELECT seq1.nextval FROM dual; What is displayed by the SELECT statement?

Question

Evaluate the following CREATE SEQUENCE statement:

CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:

SELECT seq1.nextval FROM dual; What is displayed by the SELECT statement?

Accepted Answer

D. 1

Answer

A. 100

Answer

B. an error

Answer

C. 10

Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1 START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The sequence SEQ1 has generated numbers up to the maximum limit of…

Question

Options

How the community answered

Community Discussion