Oracle Database SQL 12c 1z0-071 Exam Practice Test 3

© examsnet.com

Question : 3 of 50

Marks: +1, -0

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?

100
an error
10
1

Go to Question:

Advertisements