Multiple choice technology databases

select version from dual ;

  1. Error: "VERSION": invalid identifier

  2. Error: "VERSION": invalid character

  3. Error: invalid SQL statement

  4. shows oracle database version

  5. Null
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

VERSION is not a column in the DUAL table. Selecting a non-existent column causes ORA-00904 invalid identifier error. To get version info, use V$VERSION or PRODUCT_COMPONENT_VERSION from the dictionary views, not DUAL.

Keep practicing — related questions