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
D Correct answer
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