搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）

A、Inactive and current redo log files are required to accomplish recovery.

B、Online and archived redo log files are required to accomplish instance recovery.

C、All redo log entries after the last checkpoint are applied from redo log files to data files.

D、All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.

查看正确答案
更多“The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）”相关的问题
第1题
[单选题] Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

A、mount the new disk group in the ASM instance  B、restart the ASM instance and the production database instance  C、register the new disk groups in the production database instance  D、restart the ASM instance without restarting the production database instance  E、include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance  

点击查看答案
第2题
[单选题] 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 mode  B、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  

点击查看答案
第3题
[单选题] You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

A、 mount the new disk group in the ASM instance  B、 restart the ASM instance and the production database instance  C、 register the new disk groups in the production database instance  D、 restart the ASM instance without restarting the production database instance  E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance  

点击查看答案
第4题
[单选题] You have been assigned to manage a set of databases. The previous DBA did not leave you notes regarding the structure of each of the databases. While analyzing an instance， you notice that the system identifier （SID） for the instance is set to ’+ASM’. What is the purpose of this instance？（）

A、 This instance is being used to manage the operating system files.  B、 This instance is being used to manage the files of other databases.  C、 This instance is being used to manage the instances of other databases.  D、 This instance is being used to manage the background processes of other instances.  

点击查看答案
第5题
[单选题] You work as a database administrator for Supportcenter.cn. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）

A、The instance would hang.  B、The instance needs to be shut down.  C、The instance would be in the open state.  D、The instance would abort in such cases.  E、The instance would be in the open and invalid state.  F、The instance would in the open state， but all the background processes will be restarted.  

点击查看答案
第6题
[单选题] You work as a database administrator for Certkiller .com. The database is open. A media failure has occurred， resulting in loss of all the control files in your database. Which statement regarding the database instance is true in this scenario？（）

A、The instance would hang.  B、The instance needs to be shut down.  C、The instance would be in the open state.  D、The instance would abort in such cases.  E、The instance would be in the open and invalid state.  F、The instance would in the open state， but all the background processes will be restarted.  

点击查看答案
第7题
[] Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）  

A、A. If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.  B、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、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、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.  

点击查看答案
第8题
[单选题] You work as a database administrator for Supportcenter.cn. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file. How does the loss of a redo log member affect the instance of the database that is currently running？（）

A、The instance would normally abort.  B、The instance would not be affected.  C、The instance would be invalid， so would have to be aborted.  D、The instance would remain open， but the LGWR process would fail.  E、The instance would remain open and would automatically create the missing file  

点击查看答案
第9题
[单选题] Which of the following would be true if an administrator tried to create a commerce instance with Commerce Payments configuration values， without having Commerce Payments installed？（）

A、The commerce instance would be created successfully.  B、Attempting to configure payments instance after the commerce instance is already created will not be possible.  C、The commerce instance creation will fail on the step that would normally configure the payments instance.  D、After installing Commerce Payments， the administrator can enter the needed payment configuration values through the Administration Console.  

点击查看答案
第10题
[] Which statements concerning the correlation between the inner and outer instances of non-static inner classes are true？（）  

A、A.Member variables of the outer instance are always accessible to inner instances， regardless of their accessibility modifiers.  B、B.Member variables of the outer instance can never be referred to using only the variable name within  the inner instance.  C、C.More than one inner instance can be associated with the same outer instance.  D、D.All variables from the outer instance that should be accessible in the inner instance must be declared  final.  E、E.A class that is declared final cannot have any inner classes.  

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服