679.Which mode of database shutdown requires an instance recovery at the time of the next database
startup?
A.ABORT
B.NORMAL
C.IMMEDIATE
D.TRANSACTIONAL
Answer: A
答案解析：
The possible SHUTDOWN statements are:
SHUTDOWN ABORT
This mode is intended for emergency situations, such as when no other form of shutdown is successful.
This mode of shutdown is the fastest. However, a subsequent open of this database may take substantially longer
because instance recovery must be performed to make the data files consistent.
Note:
Because SHUTDOWN ABORT does not checkpoint the open data files, instance recovery is necessary before the database can reopen.
The other shutdown modes do not require instance recovery before the database can reopen.
因为shutdown abort不会生成检查点，所以再次打开数据库时要进行实例恢复。
SHUTDOWN IMMEDIATE
This mode is typically the fastest next to SHUTDOWN ABORT.
Oracle Database terminates any executing SQL statements and disconnects users.
Active transactions are terminated and uncommitted changes are rolled back.
SHUTDOWN TRANSACTIONAL
This mode prevents users from starting new transactions, but waits for all current transactions to complete before shutting down.
This mode can take a significant amount of time depending on the nature of the current transactions.
SHUTDOWN NORMAL
This is the default mode of shutdown. The database waits for all connected users to disconnect before shutting down.