Which view will contain the name of the database?
- V$database
- v$controlfile
- v$log
- V$DB
Reveal answer
Fill a bubble to check yourself
A
Correct answer
Explanation
V$DATABASE is the dynamic performance view that contains database name, creation date, and other core database information. Views like V$CONTROLFILE, V$LOG, and V$DB don't exist or don't contain the database name.
AI explanation
V\$DATABASE is the dynamic performance view that exposes database-level metadata, including the database name, creation timestamp, log mode, and other global attributes. V\$CONTROLFILE lists control file names/locations, and V\$LOG describes redo log groups — neither of those directly exposes the database's name the way V\$DATABASE does, and V$DB isn't a real view.