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.
1

B.
10

C.
100

D.
an error



Leave a Reply 1

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


Exmr

Exmr

Tested 11G r1. Answer C.