Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

create sequence

 
Ivan Turner
Ranch Hand
Posts: 37
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3752
62
Chrome Netbeans IDE Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What does the documentation say?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic