单选题The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery（）AInactive and current redo log files are required to accomplish recovery.BOnline and archived redo log files are required to accomplish instance recovery.CAll redo log entries after the last checkpoint are applied from redo log files to data files.DAll 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（）
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.
参考解析
解析：
暂无解析
相关考题：
Which of the following can occur if the maximum rated load is exceeded on an uninterruptible power supply (UPS)?() A. There is a fire hazard potential if a power outage occurs.B. The last system plugged into the UPS will not be provided any power.C. The UPS will draw more power from the circuit to compensate.D. The runtime of the UPS will be insufficient if a power outage occurs.
Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure. Which scenarios require DBAintervention to perform recovery（）A、1， 3， and 6B、4， 5， and 6C、3， 4， and 5D、1， 2， and 6
To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10; What is the significance of this setting?（）A、It terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.B、It terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.C、It terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.D、It terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.
A data center has had a power outage. Which of the following should the administrator do FIRST once the power is restored?（）A、Identify which systems are the most critical and bring them up by level of importance.B、Retrieve the latest backup tapes for immediate system restore using the GFS rotation.C、Identify the least critical systems and then power those systems on first.D、Determine the cause of the power outage and install UPS systems to prevent its reoccurrence.
Which of the following can occur if the maximum rated load is exceeded on an uninterruptible power supply （UPS）？（）A、 There is a fire hazard potential if a power outage occurs.B、 The last system plugged into the UPS will not be provided any power.C、 The UPS will draw more power from the circuit to compensate.D、 The runtime of the UPS will be insufficient if a power outage occurs.
Following an unscheduled power outage, theadministrator needs to power up an IVM-managed system. For the given system,what is the first step in this process?（）A、Physically press the appropriate button on the system.B、Physically disconnect and reconnect the power cable on the system.C、Log into the IVM using a Web Browser, select the managed-system and select the Power on option from the Operations menu.D、Log into the HMC using a Web Browser, select the managed-system and select the Power on option from the Operations menu.
Company.com recently experienced an unanticipated system outage when the VIO server was upgraded. The current p5-570 has six Micro-Partitions and a VIO server partition. How can a similar outage be avoided in the future？（）A、Use DLPAR to avoid an outage.B、Deploy a redundant VIO server in the POWER5 system.C、Add additional Host Bus Adapters and Network adapters to the VIO server.D、Implement a standby server and move all partitions to it before applying future updates.
You are in the middle of a transaction updating a very important table. The machine on which a database wasrunning reboots because of power outage. This caused a database instance failure. Which statement is true inthis situation（）A、The online redo log files and archived redo log files are required to accomplish the recovery.B、The uncommitted transaction will be committed at the next startup of the database instance.C、The uncommitted transaction is rolled back automatically at the next opening of the database.D、The DBA has to perform the recovery on the database to recover the uncommitted transaction
Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？（）A、current redo log and inactive redo logB、checkpoint position to end of redo logC、beginning of redo log to end of redo logD、all redo logs before the point of last commitE、beginning of redo log to checkpoint position
You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）A、The database will open, and the tablespace automatically comes out of the backup modeB、The database will be mounted, and recovery must be performed on the USERS tablespace.C、The database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.D、The database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
单选题A data center has had a power outage. Which of the following should the administrator do FIRST once the power is restored？ （）A Identify which systems are the most critical and bring them up by level of importance.B Retrieve the latest backup tapes for immediate system restore using the GFS rotation.C Identify the least critical systems and then power those systems on first.D Determine the cause of the power outage and install UPS systems to prevent its reoccurrence.
单选题ou are in the middle of a transaction updating a very important table. The machine on which adatabase was running reboots because of power outage. This caused a database instance failure. Which statement is true in this situation（）AThe online redo log files and archived redo log files are required to accomplish the recovery.BThe uncommitted transaction will be committed at the next startup of the database instance.CThe uncommitted transaction is rolled back automatically at the next opening of the database.DThe DBA has to perform the recovery on the database to recover the uncommitted transaction.
单选题To control the execution of a server process when it is receiving bad packets from a potentially malicious client, you set the SEC_PROTOCOL_ERROR_FURTHER_ACTION initialization parameter as follows: SQL ALTER SYSTEM SET SEC_PROTOCOL_ERROR_FURTHER_ACTION = Drop,10; What is the significance of this setting?（）AIt terminates the client connection after 10 bad packets and the client cannot reconnect to the same instance.BIt terminates the client connection after 10 bad packets but the client can still reconnect, and attempt the same operation again.CIt terminates the client connection 10 seconds after receiving a bad packet and the client cannot reconnect to the same instance.DIt terminates the client connection after receiving a bad packet and the client can reconnect to the same instance after 10 minutes.
单选题Given below is a list of scenarios： 1）A user terminates his session abnormally. 2）The connection between the server and the client application terminates because of a network failure. 3）A schema is accidentally dropped. 4）The tablespace is accidentally dropped from the database. 5）The hard disk gets corrupted and the data files in the disk are lost. 6）The database instance abnormally shuts down because of power failure. Which scenarios require DBA intervention to perform recovery（）A4 and 5B1，3，and 6C4，5，and 6D3，4，and 5E1，2，and 6
单选题Examine the following scenario: - Database is running in ARCHIVELOG mode. - Complete consistent backup is taken every Sunday. - On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted - The disk having active online redo log files is also corrupted. - The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS option.CRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS option.DRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option.
单选题To accomplish user-managed backup for the USERS tablespace, you issued the following command to put the database in backup mode: SQL ALTER TABLESPACE users BEGIN BACKUP; While copying the file to the backup destination a power outage caused the instance to terminate abnormally. Which statement is true about the next database startup and the USERS tablespace?（）AThe database will open, and the tablespace automatically comes out of the backup mode.BThe database will be mounted, and recovery must be performed on the USERS tablespace.CThe database will be mounted, and data files in the USERS tablespace must be taken out of the backup mode.DThe database will not be mounted, and you must restore all the data files for the USERS tablespace from the backup, and perform recovery.
单选题Given below is a list of scenarios： 1） A user terminates his session abnormally. 2） The connection between the server and the client application terminates because of a network failure. 3） A schema is accidentally dropped. 4） The tablespace is accidentally dropped from the database. 5） The hard disk gets corrupted and the data files in the disk are lost. 6） The database instance abnormally shuts down because of power failure. Which scenarios require DBAintervention to perform recovery（）A1， 3， and 6B4， 5， and 6C3， 4， and 5D1， 2， and 6
单选题Examine the following scenario: -Database is running in ARCHIVELOG mode. -Complete consistent backup is taken every Sunday. -On Tuesday the instance terminates abnormally because the disk on which control files are located gets corrupted -The disk having active online redo log files is also corrupted. -The hardware is repaired and the paths for online redo log files and control files are still valid. Which option would you use to perform the recovery of database till the point of failure?（）ARestore the latest whole backup, perform complete recovery, and open the database normallyBRestore the latest whole backup, perform incomplete recovery, and open the database with the RESETLOGS optionCRestore the latest backups control file, perform complete recovery, and open the database with the RESETLOGS optionDRestore the latest backup control file, perform incomplete recovery using backup control file, and open the database with the RESETLOG option
单选题Because of a power outage， instance failure has occurred. From what point in the redo log does recovery begin and where does it end？ （）Acurrent redo log and inactive redo logBcheckpoint position to end of redo logCbeginning of redo log to end of redo logDall redo logs before the point of last commitEbeginning of redo log to checkpoint position
多选题In which of the scenarios will the DBA perform recovery（）AThe alert log file is corrupted.BA tablespace is accidentally dropped.COne of the redo log members is corrupted.DA database user terminates the session abnormally.EThe hard disk on which the data file is stored is corrupted.
单选题Which of the following can occur if the maximum rated load is exceeded on an uninterruptible power supply (UPS)?（）AThere is a fire hazard potential if a power outage occurs.BThe last system plugged into the UPS will not be provided any power.CThe UPS will draw more power from the circuit to compensate.DThe runtime of the UPS will be insufficient if a power outage occurs.
单选题You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command： ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）AThe rebalancing of the disk group would be stopped.BThe rebalancing of the disk group would be completed as fast as possible.CThe command would result in an error because the value of POWER cannot be 0.DThe rebalancing of the disk group would be completed without affecting the disk group DG3.EThe command would result in an error because the disk groups cannot be manually rebalanced.