Oracle Database Administration I — Question 160

Which two tasks can be performed in the NOMOUNT state? (Choose two.)

Answer options

• A. renaming data files
• B. full database recovery
• C. re-creating control files
• D. creating a database
• E. enabling online redo log archiving

Correct answer: C, D

Explanation

In the NOMOUNT state, the database instance has started, but no database is yet mounted. This allows for tasks like re-creating control files and creating a database, as these actions do not require the database to be fully mounted. The other options, such as renaming data files and performing a full database recovery, require the database to be in a mounted or open state.