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.)
A. The online redo logs are opened - OPEN
B. The online data files are opened - OPEN
C. The alert log records the execution details - MOUNT
D. The Oracle background processes are started - NOMOUNT
E. The initialization parameter file is read - NOMOUNT
F. The control file is read - MOUNT
When you execute the ALTER DATABASE MOUNT command, the following two actions are performed:
The control file is read. The control file contains information about the database, including the names and locations of the data files and redo log files.
The online data files are opened. The online data files contain the data for the database.
The other actions are not performed when you execute the ALTER DATABASE MOUNT command:
The online redo logs are opened. The online redo logs are used to record changes to the database. They are not opened until you execute the ALTER DATABASE OPEN command.
The Oracle background processes are started. The Oracle background processes are responsible for managing the database. They are started when you execute the STARTUP command.
The initialization parameter file is read. The initialization parameter file contains configuration parameters for the database. It is read when you start the Oracle instance.
Initialization parameters are read and Oracle background processes are started in NOMOUNT mode.
The control file is read , alert log records the execution details along with trace files starts in MOUNT mode because the control file is read at this stage.
Redo logs and datafiles are opened after OPEN mode.
E,D 100%
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
baeji
Highly Voted 3 years agoRivaldo11
Highly Voted 3 years, 6 months agoEkos
3 years, 1 month agoLalala8
Most Recent 3 months, 2 weeks agoOracle2020
4 months, 4 weeks agoKuraudio
1 year, 1 month ago[Removed]
2 years, 3 months ago[Removed]
2 years, 3 months ago