What is displayed by the SELECT statement?

Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seql
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 seql.nextval FROM dual; What is displayed by the SELECT statement?

Evaluate the following CREATE SEQUENCE statement: CREATE SEQUENCE seql
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 seql.nextval FROM dual; What is displayed by the SELECT statement?

A.
an error

B.
100

C.
1

D.
10



Leave a Reply 2

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


George

George

Why “C”?

DmPro

DmPro

the “C” is a valid answer.
Try do it yourself, it’s easy.