Multiple choice technology programming languages

Which three statements are true about the stages of database startup?

  1. Data files and redo log files can be renamed at the MOUNT stage

  2. Control files are required to bring the database to the NOMOUNT stage.

  3. Data files and online redo log files are checked for consistency while opening the database

  4. Data files and redo log files are made available to users at the OPEN stage.
Reveal answer Fill a bubble to check yourself
A,C,D Correct answer
Explanation

During database startup: At the MOUNT stage, data files and redo log files can be renamed (A). Control files are NOT required for NOMOUNT stage - they're needed for MOUNT stage (B is false). During the OPEN stage, data files and online redo log files are checked for consistency (C). At the OPEN stage, these files become available to users (D). The NOMOUNT stage only starts the instance without accessing control files.

Keep practicing — related questions