Meaningless Drivel is fun!*
The moose likes Oracle/OAS and the fly likes create sequence Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Products » Oracle/OAS
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
Sheriff

Joined: Aug 22, 2010
Posts: 3606
    
  60

What does the documentation say?
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: create sequence
 
Similar Threads
ibm websphere test 157 for websphere studio application developer 4.0.3 for windows
sequence in oracle
DB2 700 and 701 - Test Sample
db2 - 703 certification
Array out of bounds exception