Multiple choice technology databases

Query to view installed Oracle version information ?

  1. 1. select banner from v$version;
  2. 2. select version from v$instance;
  3. 3. select version from v$version;

  4. Both 1 and 2

  5. Both 2 and 3
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

To view Oracle version: (1) SELECT banner FROM v$version; displays version banners for all components. (2) SELECT version FROM v$instance; shows instance version. Option 3 is invalid - v$version doesn't have a 'version' column (it has 'banner'). So 'Both 1 and 2' is correct, not 'Both 2 and 3'.

Keep practicing — related questions