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 questionsWhen 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.
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.
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.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
