Oracle Database Administration I — Question 95

You start your database instance in NOMOUNT state.

Which two actions are performed? (Choose two.)

Answer options

• A. SYS can access the database.
• B. The consistency of the database is checked.
• C. The control files are opened.
• D. All required background processes are started.
• E. Memory is allocated for the SGA.

Correct answer: D, E

Explanation

In NOMOUNT state, the database instance is not fully initialized, which means that only the System Global Area (SGA) memory is allocated (option E) and the necessary background processes are not yet running (option D). The control files are not opened, and the database consistency is not checked until the instance is in MOUNT state.