Multiple choice

Which of the following Oracle Dynamic Performance Views gives the names and status of control files for an Oracle instance?

  1. V$CONTROLFILE_RECORD_SECTION
  2. V$CONTROLFILE
  3. V$PARAMETER
  4. V$DATABASE
  5. SHOW PARAMETER CONTROL_FILES

Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

V$CONTROLFILE_RECORD_SECTION displays information about the control file record sections.