Oracle Exam 1Z0-061 Topic 1 Question 1 Discussion

Actual exam question for Oracle's 1Z0-061 exam

Question #: 1
Topic #: 1

[All 1Z0-061 Questions]

A sequence is created as follows:

create sequence seq1 maxvalue 50;

If the current value is already 50, when you attempt to select SEQ1.NEXTVAL what will happen?

AThe sequence will cycle and issue 0.

BThe sequence will cycle and issue 1.

CThe sequence will reissue 50.

DThere will be an error.

Show Suggested Answer

Suggested Answer: D

The default is NOCYCLE, and the sequence cannot advance further.

by Roselle at Jun 13, 2022, 06:23 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!