1Z0-062 · Question #367
Which four statements are true about database instance behavior? (Choose four.)
The correct answer is 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. Database instance states determine available operations; in MOUNT state, administrative tasks like renaming data and redo log files are possible, and SPFILEs can be updated even from an idle instance.
Question
Which four statements are true about database instance behavior? (Choose four.)
Options
- AAn idle instance is created when a STARTUP NOMOUNT is successful
- BAll dynamic performance views (v$ views) return data when queried from a session connected to
- CThe consistency of redo logs and data files is checked when mounting the database
- DRedo log files can be renamed in MOUNT state
- EAn SPFILE can be updated when connected to an idle instance
- FDatafiles can be renamed in MOUNT state
How the community answered
(40 responses)- A5% (2)
- B13% (5)
- C83% (33)
Why each option
Database instance states determine available operations; in MOUNT state, administrative tasks like renaming data and redo log files are possible, and SPFILEs can be updated even from an idle instance.
STARTUP NOMOUNT brings up a fully functional instance (SGA and background processes); an 'idle instance' typically refers to the state before any STARTUP command, where only a connection to the software exists without an active instance.
Not all V$ views return data in NOMOUNT or MOUNT states, as many require the database to be open to access actual database file information or session activity.
Although full data block consistency checks occur during the OPEN phase, the MOUNT operation implicitly verifies the control file's integrity and its ability to properly identify and locate the registered redo logs and data files, which is a form of consistency check necessary for database startup.
In the MOUNT state, the database control file is read, but data files and redo log files are not yet open, allowing administrative commands like ALTER DATABASE RENAME FILE to modify their paths within the control file.
An SPFILE is a server parameter file which is read during instance startup; even when connected to an idle instance (before STARTUP NOMOUNT), the SPFILE is accessible as a regular file and can be updated using ALTER SYSTEM SET ... SCOPE=SPFILE.
Similar to redo log files, data files are known but not open in the MOUNT state, which enables administrative operations such as renaming their physical location using the ALTER DATABASE RENAME FILE command.
Concept tested: Oracle instance states and operations
Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/admin/starting-up-and-shutting-down-a-database.html#GUID-82ECF1C7-49D9-4DA3-B9E6-D030D268154D
Topics
Community Discussion
No community discussion yet for this question.