Oracle Database 12c: Installation and Administration — Question 100

Which four statements are true about database instance behavior? (Choose four.)

Answer options

• A. An idle instance is created when a STARTUP NOMOUNT is successful
• B. All dynamic performance views (v$ views) return data when queried from a session connected to an instance in NOMOUNT state
• C. The consistency of redo logs and data files is checked when mounting the database
• D. Redo log files can be renamed in MOUNT state
• E. An SPFILE can be updated when connected to an idle instance
• F. Datafiles can be renamed in MOUNT state

Correct answer: C, D, E, F

Explanation

The correct answer is C, D, E, and F because these statements accurately reflect the behaviors relevant to database instances. For example, the consistency of redo logs is indeed checked during the mounting process, and datafiles and redo logs can be renamed while in MOUNT state. Options A and B are incorrect as they misrepresent the capabilities and states of the database instance.