Multiple choice technology databases

How to view installed Oracle version information

  1. select banner from v$version;
  2. select # from v$version;
  3. select ver from v$version
  4. select version from v$version;
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Querying select banner from v\$version; retrieves Oracle version and component information. The v\$version view contains a banner column holding the full version details. Other queries fail because columns like ver or version or symbol # do not exist in this view.

Keep practicing — related questions