Oracle Database 12c: Advanced Administration — Question 97

Your multitenant container database (CDB) CDB1, has no startup triggers and contains multiple pluggable databases (PDBs).
It was started up by using the command which executed successfully with no errors:

SQL> STARTUP MOUNT -
Which two statements are true? (Choose two.)

Answer options

• A. All redo logs are opened.
• B. All control files are opened.
• C. All tempfiles are opened.
• D. CDB$ROOT is opened.
• E. The SPFILE is opened.

Correct answer: A, D

Explanation

When a database is in the MOUNT state, redo logs are accessible, allowing for recovery operations, which makes option A correct. Additionally, CDB$ROOT is opened in this state to manage the container, making option D correct. However, control files and tempfiles are not accessible in the MOUNT state, which is why options B and C are incorrect. The SPFILE is not opened in the MOUNT state, making option E incorrect as well.