Multiple Choice
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
Correct Answer:
Verified
Q2: Which of the following statements about sequences
Q6: The _ clause identifies the lowest value
Q22: Structure of the CUSTOMERS table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q36: A synonym is an alternate name assigned
Q51: The _ clause is used to specify
Q75: The _ options are used to determine
Q82: After a value is generated,it is stored
Q89: To change the starting value for a
Q106: The _ pseudocolumn is used to generate
Q121: An index is implicitly created when a