Multiple choice technology databases

Which one is not a valid pseudo-columns?

  1. USER

  2. UID

  3. CURVAL

  4. All are valid
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

CURVAL is not a valid Oracle pseudo-column, whereas CURRVAL is the correct spelling used to find the current value of a sequence. USER and UID are both valid pseudo-columns in Oracle SQL used to retrieve session information.

AI explanation

Oracle pseudo-columns include ROWID, ROWNUM, LEVEL, USER, UID, and sequence pseudo-columns NEXTVAL/CURRVAL (the option 'CURVAL' is very likely a typo for CURRVAL). USER returns the current session's username, UID returns the numeric user ID, and CURRVAL returns the current value of a sequence in the session — all are legitimate, standard Oracle pseudo-columns. Since all three listed items correspond to real pseudo-columns, 'All are valid' is correct, meaning there is no invalid one among the choices given.

Keep practicing — related questions