A NEXTVAL call generates the sequence value of 5.After the value is generated,what value will be stored in CURRVAL?
A) 5
B) 4
C) 6
D) unknown

Name: A NEXTVAL call generates the sequence value of 5.After the value is generated,what value will be stored in CURRVAL? A) 5 B) 4 C) 6 D) unknown
Brand: Quizplus
Rating: 4.9 (31 reviews)

Question

A NEXTVAL call generates the sequence value of 5.After the value is generated,what value will be stored in CURRVAL?
A) ​5
B) ​4
C) ​6
D) unknown

Quizplus · Accepted Answer

After a NEXTVAL call generates a sequence value of 5, CURRVAL will store the same value, which is 5. CURRVAL always holds the most recently generated value by NEXTVAL for the session.

A NEXTVAL Call Generates the Sequence Value of 5