Multiple choice technology databases

I have just now created sequence abc and If you immediately run the below select statement , what is the output? CREATE SEQUENCE abc MINVALUE 1 MAXVALUE 10 START WITH 1 INCREMENT BY 1 CACHE 20 Select abc.currval from dual;

  1. 1

  2. Null

  3. Error

  4. None of the above
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

In Oracle, a sequence's CURRVAL pseudocolumn cannot be used until NEXTVAL has been called at least once in the current session. Since the sequence was just created and NEXTVAL has not been called, attempting to select CURRVAL will raise an error: ORA-08002: sequence ABC.CURRVAL is not yet defined in this session.

Keep practicing — related questions