多选题What are the consequences of executing the SHUTDOWN ABORT command？ （）AThe database files are synchronized.BUncommitted changes are not rolled back.CThe database is closed， but the instance is still started.DDatabase buffers and redo buffers are not written to the disk.EThe database undergoes automatic media recovery during the next startup.
多选题
What are the consequences of executing the SHUTDOWN ABORT command？ （）
A
The database files are synchronized.
B
Uncommitted changes are not rolled back.
C
The database is closed， but the instance is still started.
D
Database buffers and redo buffers are not written to the disk.
E
The database undergoes automatic media recovery during the next startup.
参考解析
解析：
暂无解析
相关考题：
SHUTDOWN的()选项在下次启动数据库时需要进行数据库恢复。 A.SHUTDOWN IMMEDIATEB.SHUTDOWN TRANSACTIONALC.SHUTDOWN NORMALD.SHUTDOWN ABORT
You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, while all three production database instances are running, you execute the following command on the ASM instance :SQL shutdown immediate;What is the result of executing this command?（）A. The ASM instance is shut down, but the other instances are still running.B. It results in an error because other database instances are connected to it.C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode.
What happens if you shutdown abort ASM instance?() A. The RDBMSs connected will shutdown abort tooB. CLUSTER SERVICE will shutdownC. ASM wil do instance recovery after startup
假设用户正在执行UPDATE操作,此时用以下哪种方法可以关闭数据库() A.SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORTB.SHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONALC.SHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATED.SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONALE.SHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
What are the consequences of executing the SHUTDOWN ABORT command？ （）A、The database files are synchronized.B、Uncommitted changes are not rolled back.C、The database is closed， but the instance is still started.D、Database buffers and redo buffers are not written to the disk.E、The database undergoes automatic media recovery during the next startup.
如果一个数据库举例（instance）失败，但是没有停止运行，你必须使用哪个命令使实例恢复能被执行？（）A、startup nomountB、shutdown immediate;start forceC、startup mountD、shutdown abort;startup
SHUTDOWN的（）选项在下次启动数据库时需要进行实例恢复。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（） A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.
假设用户正在执行UPDATE操作，此时用以下哪种方法可以关闭数据库（）A、SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORTB、SHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATED、SHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONALE、SHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
What is the proper command to shut down the database in a consistent manner?（）A、shutdown abort B、shutdown kill C、Shutdown nowait D、shutdown immediateE、shutdown halt
Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A、 The queries that are currently executing will abort and an error message will be returned to the user.B、 The queries that are currently executing will execute normally but future queries will not executed.C、 Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D、 The currently executing and future queries will execute normally， but will be slower
What happens if you shutdown abort ASM instance?（）A、The RDBMSs connected will shutdown abort tooB、CLUSTER SERVICE will shutdownC、ASM wil do instance recovery after startup
SHUTDOWN的（）选项会等待用户完成他们没有提交的事务。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
SHUTDOWN的（）选项在下次启动数据库时需要进行数据库恢复。A、SHUTDOWN IMMEDIATEB、SHUTDOWN TRANSACTIONALC、SHUTDOWN NORMALD、SHUTDOWN ABORT
单选题Your database is in ARCHIVELOG mode. You lost an index tablespace due to a disk failure while the database was open. You have neither a backup of the lost index tablespace nor the scripts containing the CREATE INDEX statements to recreate the indexes. Currently， several users are executing long-running queries on the database. What will happen to the ongoing activity in the database？（）A The queries that are currently executing will abort and an error message will be returned to the user.B The queries that are currently executing will execute normally but future queries will not executed.C Data Manipulation Language （DML） statements cannot be performed on the tables on which the indexes are based.D The currently executing and future queries will execute normally， but will be slower
单选题假设用户正在执行UPDATE操作，此时用以下哪种方法可以关闭数据库（）ASHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN ABORTBSHUTDOWN或SHUTDOWN NORMAL或SHUTDOWN TRANSACTIONALCSHUTDOWN NORMAL或SHUTDOWN ABORT或SHUTDOWN IMMEDIATEDSHUTDOWN或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONALESHUTDOWN ABORT或SHUTDOWN IMMEDIATE或SHUTDOWN TRANSACTIONAL
单选题You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance. At the end of the day, you execute the following command on the ASM instance to shut down: SQL shutdown immediate; What is the result of executing this command?（）AAll the instances, including the ASM instance, are shut down in the ABORT modeBThe ASM instance is shut down, but the other instances are still running CThe ASM instance is still functional, but the other instances are shut down DAll the instances, including the ASM instance, are shut down in the IMMEDIATE mode. EHRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode FHRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
单选题SHUTDOWN的（）选项会等待用户完成他们没有提交的事务。ASHUTDOWN IMMEDIATEBSHUTDOWN TRANSACTIONALCSHUTDOWN NORMALDSHUTDOWN ABORT
单选题SHUTDOWN的（）选项在下次启动数据库时需要进行实例恢复。ASHUTDOWN IMMEDIATEBSHUTDOWN TRANSACTIONALCSHUTDOWN NORMALDSHUTDOWN ABORT
单选题What happens if you shutdown abort ASM instance?（）AThe RDBMSs connected will shutdown abort tooBCLUSTER SERVICE will shutdownCASM wil do instance recovery after startup
单选题SHUTDOWN的（）选项在下次启动数据库时需要进行数据库恢复。ASHUTDOWN IMMEDIATEBSHUTDOWN TRANSACTIONALCSHUTDOWN NORMALDSHUTDOWN ABORT
单选题Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）A If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.B If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.C If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.D If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.
多选题In which three situations is incomplete recovery required？（）AAfter a shutdown abort.BWhen recovering to an SCN.CWhen recovering until a specific time.DWhen a required archived log is missing.
问答题What were the consequences of the Norman Conquest?