Multiple choice technology databases

Select the correct pseudocolumns

  1. CURRVAL

  2. LEVEL

  3. ROWNUM

  4. COUNT
Reveal answer Fill a bubble to check yourself
A,B,C Correct answer
Explanation

Pseudocolumns behave like columns but aren't actual table columns. ROWNUM assigns a sequential number to each row returned. LEVEL indicates the depth in hierarchical queries. CURRVAL returns the current value of a sequence. COUNT is an aggregate function that calculates row counts, not a pseudocolumn. Oracle uses these special values for metadata and query control.

Keep practicing — related questions