| Author |
create sequence
|
Ivan Turner
Ranch Hand
Joined: Feb 27, 2012
Posts: 37
|
|
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
|
 |
Martin Vajsar
Bartender
Joined: Aug 22, 2010
Posts: 2331
|
|
What does the documentation say?
|
 |
 |
|
|
subject: create sequence
|
|
|