nerdexam
Oracle

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.

Exploring the Oracle Database Architecture

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)
  • A
    5% (2)
  • B
    13% (5)
  • C
    83% (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.

AAn idle instance is created when a STARTUP NOMOUNT is successful

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.

BAll dynamic performance views (v$ views) return data when queried from a session connected to

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.

CThe consistency of redo logs and data files is checked when mounting the databaseCorrect

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.

DRedo log files can be renamed in MOUNT stateCorrect

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.

EAn SPFILE can be updated when connected to an idle instanceCorrect

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.

FDatafiles can be renamed in MOUNT stateCorrect

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

#Database startup#instance states#MOUNT state#SPFILE

Community Discussion

No community discussion yet for this question.

Full 1Z0-062 Practice