网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
多选题
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.
参考答案
参考解析
解析：
暂无解析
更多 “多选题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.” 相关考题
考题
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 were the consequences of the decision she had made?A: reasons
B: results
C: causes
D: bases
考题
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操作，此时用以下哪种方法可以关闭数据库（）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
考题
单选题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?（）A
All the instances, including the ASM instance, are shut down in the ABORT modeB
The ASM instance is shut down, but the other instances are still running C
The ASM instance is still functional, but the other instances are shut down D
All the instances, including the ASM instance, are shut down in the IMMEDIATE mode. E
HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is shut down in the IMMEDIATE mode F
HRDB, FINDB, and ORGDB instances are shut down in the NORMAL mode and the ASM instance is shut down in the IMMEDIATE mode
考题
单选题SHUTDOWN的（）选项会等待用户完成他们没有提交的事务。A
SHUTDOWN IMMEDIATEB
SHUTDOWN TRANSACTIONALC
SHUTDOWN NORMALD
SHUTDOWN ABORT
考题
单选题SHUTDOWN的（）选项在下次启动数据库时需要进行实例恢复。A
SHUTDOWN IMMEDIATEB
SHUTDOWN TRANSACTIONALC
SHUTDOWN NORMALD
SHUTDOWN ABORT
考题
单选题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
考题
单选题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?
热门标签
最新试卷