Multiple choice technology databases

What is the minimum number of control files are required to start a database?

  1. One

  2. Two

  3. Three

  4. None
Reveal answer Fill a bubble to check yourself
A Correct answer
Explanation

Oracle can start with just one control file, though production databases should multiplex control files (maintain multiple copies) for redundancy. The control file contains critical metadata like database name, file locations, and checkpoint information.

AI explanation

Oracle requires a minimum of one control file to mount and open a database — the control file tracks essential structural metadata like datafile and redo log locations, checkpoint information, and the database name. In practice, Oracle strongly recommends multiplexing multiple copies for safety, but functionally only one is required to start the instance.

Keep practicing — related questions