1Z0-082 practice question 11 of 25

Your database instance was shut down normally and then started in NOMOUNT state. You then execute this command: ALTER DATABASE MOUNT; Which two actions are performed? (Choose two.)

Full set: 142 questions
Answer options
A: The online redo logs are opened
B: The online data files are opened
C: The alert log records the execution details Correct answer
D: The Oracle background processes are started
E: The initialization parameter file is read
F: The control file is read Correct answer
Correct Answer:
C. The alert log records the execution details; F. The control file is read
Explanation

When an Oracle instance is started, it proceeds through stages. The NOMOUNT stage starts the instance (allocates SGA, starts background processes) by reading the parameter file. The ALTER DATABASE MOUNT command proceeds to the MOUNT stage. In this stage, the instance locates and opens the control files specified in the parameter file. It then reads the control files to obtain the names and locations of the database's data files and redo log files. All significant actions, including mounting the database, are recorded in the alert log.

Why Incorrect

A. The online redo logs are opened during the OPEN stage (ALTER DATABASE OPEN), not the MOUNT stage.
B. The online data files are opened during the OPEN stage, which follows the MOUNT stage.
D. The Oracle background processes are started during the initial STARTUP NOMOUNT phase, before the database is mounted.
E. The initialization parameter file is read during the STARTUP NOMOUNT phase to configure the instance.

References

1. Oracle Database Administrator's Guide, 19c. Chapter 3, "Starting Up and Shutting Down". Section: "About Database Mounting". It states, "To mount the database, the instance obtains the names of the control files from the CONTROLFILES initialization parameter and opens the files."

2. Oracle Database Concepts, 19c. Chapter 5, "Startup and Shutdown". Section: "About Instance and Database Startup". The "Mount a Database" step description states: "The instance finds the database control files and opens them. Control files contain information about the data files and online redo log files".

3. Oracle Database Concepts, 19c. Chapter 13, "Monitoring Operations". Section: "Alert Log". It states the alert log is a chronological log of messages and errors, which includes startup and shutdown events.

Scroll to Top