Sequence values can be accessed using the ____ and NEXTVAL pseudocolumns.
A) PREVVAL
B) FIRSTVAL
C) CURRVAL
D) UPVAL

Name: Sequence values can be accessed using the ____ and NEXTVAL pseudocolumns. A) PREVVAL B) FIRSTVAL C) CURRVAL D) UPVAL
Brand: Quizplus
Rating: 4.8 (30 reviews)

Question

Quizplus · Accepted Answer

The correct pseudocolumns for accessing sequence values are CURRVAL (to access the current sequence value) and NEXTVAL (to generate and retrieve the next sequence value). There is no pseudocolumn called PREVVAL or FIRSTVAL. UPVAL is not a valid pseudocolumn at all.

Sequence Values Can Be Accessed Using the ____ and NEXTVAL