What is displayed by the SELECT statement?

Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1
START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The SEQ1
sequence 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?

Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seq1
START WITH 100 INCREMENT BY 10 MAXVALUE 200 CYCLE NOCACHE; The SEQ1
sequence 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?

A.
1

B.
10

C.
100

D.
an error

Explanation:



Leave a Reply 1

Your email address will not be published. Required fields are marked *