posted 12 years ago
This might be off topic but chinatag.com has a sql expert exam that says the answer is A. Since I have no other resource, I asked here. Is A the correct answer? I would choose C.
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?
A. 1
B. 10
C. 100
D. an error