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 Oracle10g 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.
Correct Answer:
Verified
Q65: Which options are used in application cluster
Q72: When creating a sequence,which of the following
Q76: The _ clause is used to specify
Q77: Which command will create an index?
A) CREATE
Q77: Which command will modify a sequence?
A) ALTER
Q78: Oracle10g will begin each sequence with the
Q80: Which of the following is used to
Q80: Which option is used to have Oracle11g
Q85: Which of the following commands can be
Q88: Which of the following keywords is used
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents