ocp1z0-047: What is the default value for the sequence MinValue?

Here is the test sequence of start with N and Minvaluen (the default minimum is 1)

OK, let's start with a sequence and then do a test to get the value of start with or MinValue value, and I don't have a minvalue here.

Gyj@ocm>create sequence seq1

2 Start with 100

3 Increment by 10

4 MaxValue 200

5 Cycle

6 NoCache;

Sequencecreated.

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

100

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

110

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

120

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

130

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

140

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

150

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

160

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

170

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

180

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

190

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

200

gyj@ocm> Select Seq1.nextval fromdual;

Nextval

----------

1

Loop back to 1.

The result is obvious, the correct answer is: A

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/