Oracle Database SQL 12c 1z0-071 Exam Practice Test 3
© examsiri.com
Question : 3 of 50
Marks:
+1,
-0
Evaluate the following CREATE SEQUENCE statement:
The sequence SEQ1 has generated numbers up to the maximum limit of 200. You issue the following SQL statement:
What is displayed by the SELECT 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?
Go to Question: