Which two statements about sequences are true?

Previous Question
Next Question

Which two statements about sequences are true? (Choose two.)

A.
You use a CURRVAL pseudo column to generate a value from a sequence that would be used
for a specified database column.

B.
You use a CURRVAL pseudo column to look at the current value just generated from a
sequence, without affecting the further values to be generated from the sequence.

C.
You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by
actually retrieving the value from the sequence.

D.
You use a NEXTVAL pseudo column to look at the next possible value that would be generated
from a sequence, without actually retrieving the value.

E.
You use a REUSE clause when creating a sequence to restart the sequence once it generates
the maximum value defined for the sequence.

F.
If a sequence starting from a value 100 and incremented by 1 is used by more than one
application, then all of these applications could have a value of 105 assigned to their column
whose value is being generated by the sequence.

Explanation:

You use a CURRVAL pseudo column to look at the current value just generated from a sequence,
without affecting the further values to be generated from the sequence. You use a NEXTVAL
pseudo column to obtain the next possible value from a sequence by actually retrieving the value
from the sequence.
Incorrect Answers:
A: You use a NEXTVAL pseudo column to obtain the next possible value from a sequence by
actually retrieving the value from the sequence.
D: You use a CURRVAL pseudo column to look at the current value just generated from a
sequence, without affecting the further values to be generated from the sequence.
E: This statement is not correct. There is no limitation like that in Oracle.
F: You use CYCLE clause, not REUSE, when creating a sequence to restart the sequence once it
generates the maximum value defined for the sequence.OCP Introduction to Oracle 9i: SQL Exam
Guide, Jason Couchman, p. 315-322Chapter 7: Creating Other Database Objects in Oracle

Previous Question
Next Question

Leave a Reply

Your email address will not be published. Required fields are marked *