Multiple choice technology databases

Your database is having two control files; three redo log file groups with two members in each group. Failure of which file would cause a instance to shut down?

  1. Loss of the initialization parameter file.

  2. One of the redo log members.

  3. Any data file belonging to the default permanent tablespace

  4. Any archive log file.

  5. Any control file.
Reveal answer Fill a bubble to check yourself
E Correct answer
Explanation

The loss of any control file will cause an Oracle instance to immediately shut down because control files are continuously accessed and must be synchronized. Redo log members are multiplexed, so losing one member of a group does not crash the instance.

Keep practicing — related questions