🎴 Flashcard Mode
Oracle PL/SQL Database Fundamentals
Card1 / 19
Mastered0
Review0
QuestionClick to flip
Query to view installed Oracle version information ?
AnswerClick to flip back
A
Both 1 and 2
💡 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'.