Multiple choice

Which statement should be used to obtain information about the number, names, status, and location of the control files?

  1. SELECT name, status FROM v$parameter;
  2. SELECT name, status FROM v$controlfile;
  3. SELECT name, status, location FROM v$control_files;
  4. SELECT status, location FROM v$parameter WHERE parameter=control_files;
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

V$CONTROLFILE is the dynamic performance view that contains information about control files, including their names and status. This view provides a list of all control files currently in use by the database instance.

Keep practicing — related questions