The moose likes Oracle/OAS and the fly likes create sequence Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login


Win a copy of The Mikado Method this week in the Agile and other Processes forum!
JavaRanch » Java Forums » Products » Oracle/OAS
Reply Bookmark "create sequence" Watch "create sequence" New topic
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
    
    2

What does the documentation say?
 
I agree. Here's the link: http://zeroturnaround.com/jrebel - it saves me about five hours per week
 
subject: create sequence
 
Similar Threads
Array out of bounds exception
db2 - 703 certification
DB2 700 and 701 - Test Sample
sequence in oracle
ibm websphere test 157 for websphere studio application developer 4.0.3 for windows