Your database instance is down because there was a user-initiated shutdown. Which option
represents the actions performed, in the correct order, if you start up the instance?
a – The control file is read.
b – Memory is allocated.
c – Background processes pre started.
d -The initialization parameter file is read,
e- Redo log files and data files are opened.
A.
b, c, a
B.
d, a, e
C.
a, e, d, b
D.
d, b, c, a, e
E.
c, b, d, a, e
http://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT955
How an Instance Is Started
When Oracle Database starts an instance, it performs the following basic steps:
Searches for a server parameter file in a platform-specific default location and, if not found, for a text initialization parameter file (specifying STARTUP with the SPFILE or PFILE parameters overrides the default behavior)
Reads the parameter file to determine the values of initialization parameters
Allocates the SGA based on the initialization parameter settings
Starts the Oracle background processes
Opens the alert log and trace files and writes all explicit parameter settings to the alert log in valid parameter syntax
Answer: D
d
D
D
answer D
http://docs.oracle.com/cd/E11882_01/server.112/e40540/startup.htm#CNCPT602
1. Searches for a server parameter file in a platform-specific default location and, if not found, for a text initialization parameter file (specifying STARTUP with the SPFILE or PFILE parameters overrides the default behavior)
2. Reads the parameter file to determine the values of initialization parameters
3. Allocates the SGA based on the initialization parameter settings
4. Starts the Oracle background processes
5. Opens the alert log and trace files and writes all explicit parameter settings to the alert log in valid parameter syntax