Which of the following statements about NEXTVAL and CURRVAL is incorrect?
A) The pseudocolumn NEXTVAL is used to actually generate the sequence value.
B) After the value is generated,it is stored in the CURRVAL pseudocolumn so it can be referenced again by a user.
C) A reference to CURRVAL will not cause Oracle 12c to generate a new sequence number; a reference to NEXTVAL,however,will generate a new number.
D) NEXTVAL and CURRVAL are pseudocolumns that store unique names for database objects.

Question

Which of the following statements about NEXTVAL and CURRVAL is incorrect?​
A) ​The pseudocolumn NEXTVAL is used to actually generate the sequence value.
B) ​After the value is generated,it is stored in the CURRVAL pseudocolumn so it can be referenced again by a user.
C) A reference to CURRVAL will not cause Oracle 12c to generate a new sequence number; a reference to NEXTVAL,however,will generate a new number.
D) ​NEXTVAL and CURRVAL are pseudocolumns that store unique names for database objects.

Quizplus · Accepted Answer

NEXTVAL and CURRVAL are pseudocolumns used for generating and referencing sequence numbers respectively. They do not store unique names for database objects.

Which of the Following Statements About NEXTVAL and CURRVAL Is