Which statement is true regarding the startup of a database instance?
A.
The instance does not start up normally and requires manual media recovery after a shutdown
using the abort option.
B.
Uncommitted transactions are rolled back during the startup of the database instance after a
shutdown using the immediate option.
C.
There is no difference in the underlying mechanics of the startup whether the database is shut
down by using the immediate option or the abort option.
D.
Media recovery is required when the database is shut down by using either the immediate
option or the abort option.
E.
Instance recovery is not required if the database instance was shut down by using
SHUTDOWN IMMEDIATE.
Explanation:
http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm
As per the explanation link answer will be E.
As the doc:
The next startup of the database will not require any instance recovery procedures.
Not b: uncommited transactions are rolled back but not during startup.
I mean “The next startup of the database will not require any instance recovery procedures.” for immediate option
I totally agree with Liz and Winner2001. Only E is correct.
I agree only E is correct.
B wrong.
Uncommitted transactions are rolled back during the shutdown immediate and not during start up
E is correct
E is the correct answer :
Docummentation: http://docs.oracle.com/cd/A87860_01/doc/server.817/a76956/start.htm
extract from link:
Shutting Down with the IMMEDIATE Option
Use immediate database shutdown only in the following situations:
A power shutdown is going to occur soon.
The database or one of its applications is functioning irregularly.
Immediate database shutdown proceeds with the following conditions:
Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)
Oracle does not wait for users currently connected to the database to disconnect; Oracle implicitly rolls back active transactions and disconnects all connected users.
The next startup of the database will not require any instance recovery procedures.
E
E
E
roll back si during shutdown
E
Immediate database shutdown proceeds with the following conditions:
Any uncommitted transactions are rolled back. (If long uncommitted transactions exist, this method of shutdown might not complete quickly, despite its name.)
Oracle does not wait for users currently connected to the database to disconnect; Oracle implicitly rolls back active transactions and disconnects all connected users.
The next startup of the database will not require any instance recovery procedures.
C is correct