aspose file tools*
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
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: 3435
    
  47

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