Multiple choice technology databases

when the control file is to be created the database has to be in the

  1. mounted

  2. not mounted

  3. restricted

  4. open
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

When creating a control file (using the CREATE CONTROLFILE command or with CREATE DATABASE), the database must be in NOMOUNT state. In NOMOUNT state, the instance has started with SGA and background processes, but the database is not mounted or open - this is the required state for control file operations.

Keep practicing — related questions