单选题You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）AGroup 2 is the active group.BGroup 2 is the current group.CDatabase is in the MOUNT state.DGroup 2 has been already archived.
单选题
You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）
A
Group 2 is the active group.
B
Group 2 is the current group.
C
Database is in the MOUNT state.
D
Group 2 has been already archived.
参考解析
解析：
暂无解析
相关考题：
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?（）A. You should perform a log switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery
Upon starting your database, you receive the following error:You can choose from the following steps:1.Restore the database datafiles.2.Issue the alter database clear unarchived logfile group 1 command.3.Issue the alter database open command.4.Issue the alter database open resetlogs command.5.Recover the database using point-in-time recovery.6.Issue the Startup Mount command to mount the database.7.Back up the database.Which is the correct order of these steps in this case?（）A. 1,6,5,4,7B. 6,5,4C. 6,2,3,7D. 1,6,3E. The database cannot be recovered
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains oneredo member. When you attempt to start the database, you receive the following errors:ORA-00313: open failed for members of log group 1 of thread 1ORA-00312: online log 1 thread 1: ‘D:\REDO01.LOG‘You discover that the online redo log file of the current redo group is corrupted.Which statement should you use to resolve this issue?（）A. ALTER DATABASE DROP LOGFILE GROUP 1;B. ALTER DATABASE CLEAR LOGFILE GROUP 1;C. ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D. ALTER DATABASE DROP LOGFILE MEMBER ‘D:\REDO01.LOG
Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）A、RECOVER LOGFILE BLOCK GROUP 2；B、ALTER DATABASE DROP LOGFILE GROUP 2；C、ALTER DATABASE CLEAR LOGFILE GROUP 2；D、ALTER DATABASE RECOVER LOGFILE GROUP 2；E、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）A、ALTER DATABASE DROP LOGFILE GROUP 1;B、ALTER DATABASE CLEAR LOGFILE GROUP 1;C、ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;D、ALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（） A、 You should perform a log switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery
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？（）A、The rebalancing of the disk group would be stopped.B、The rebalancing of the disk group would be completed as fast as possible.C、The command would result in an error because the value of POWER cannot be 0.D、The rebalancing of the disk group would be completed without affecting the disk group DG3.E、The command would result in an error because the disk groups cannot be manually rebalanced.
You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A、When a new log group is added， it would have one member in each disk group.B、When a new log group is added， it would have two members in each disk group.C、When a new tablespace is added， it would have one data file in each disk group.D、When a new log file is added， it would have one member spread across the disk groups.
You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）A、Group 2 is the active group.B、Group 2 is the current group.C、Database is in the MOUNT state.D、Group 2 has been already archived.
Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）A、 ALTER DATABASE DROP LOGFILE GROUP 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）A、 The redo log file should belong to an active group.B、 The redo log file should belong to an inactive group.C、 The redo log file should belong to the current group.D、 The redo log file can be dropped only if all the transactions are stopped.E、 Before a redo log file is dropped， it should be deleted from the operating system （OS）.
Which statement about recovering from the loss of a redo log group is true?（）A、If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B、If the lost redo log group is CURRENT, you must clear the log file.C、If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.D、If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
You have the following online redo log configuration： Group Member 1 ’/disk1/oradata/redo01a.log’ 2 ’/disk2/oradata/redo02a.log’ 3 ’/disk3/oradata/redo03a.log’ You decide to multiplex the online redo log groups for recovery of redo log files in case of any disaster. Which two statements will you NOT issue to multiplex the online redo log files？（）A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1；B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1；C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2；D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2；E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3；F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3；
Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A、 SQLALTER DATABASE DROP LOGFILE GROUP 1；B、 SQLALTER DATABASE CLEAR LOGFILE GROUP 1；C、 SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D、 SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）A、 The client RDBMS instance can access the file as a read-only file.B、 A new disk cannot be added to a disk group.C、 A disk in a disk group can be taken offline.D、 The client RDBMS instance cannot access the files in the disk group.
单选题Which statement about recovering from the loss of a redo log group is true？（）A If the lost redo log group is ACTIVE， you should first attempt to clear the log file.B If the lost redo log group is CURRENT， you must clear the log file.C If the lost redo log group is ACTIVE， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.D If the lost redo log group is CURRENT， you must restore，perform cancel-based incomplete recovery，and open the database using the RESETLOGS option.
单选题You are using the following command to clear the log file group： ALTER DATABASE CLEAR LOFFILE GROUP 2； In which case would the command be successful？（）AGroup 2 is the active group.BGroup 2 is the current group.CDatabase is in the MOUNT state.DGroup 2 has been already archived.
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?（）AYou should perform a log switchBYou should make a backup of the databaseCYou should switch the database to the NONARCHIVELOG modeDYou should shut down the database instance and perform a complete database recovery
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups, each of which contains one redo member. When you attempt to start the database, you receive the following errors: ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'D:/REDO01.LOG' You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue?（）AALTER DATABASE DROP LOGFILE GROUP 1;BALTER DATABASE CLEAR LOGFILE GROUP 1;CALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1;DALTER DATABASE DROP LOGFILE MEMBER 'D:/REDO01.LOG
单选题Because of hardware failure， you decided to drop a redo log member from the database. Which condition should be met to drop a redo log file？（）A The redo log file should belong to an active group.B The redo log file should belong to an inactive group.C The redo log file should belong to the current group.D The redo log file can be dropped only if all the transactions are stopped.E Before a redo log file is dropped， it should be deleted from the operating system （OS）.
单选题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.
单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1and DG2with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’ DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’ What would be the impact of this setting？（）A When a new log group is added， it would have one member in each disk group.B When a new log group is added， it would have two members in each disk group.C When a new tablespace is added， it would have one data file in each disk group.D When a new log file is added， it would have one member spread across the disk groups.
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups，each of which contains one redo member. When you attempt to start the database， you receive the following errors：（）A ALTER DATABASE DROP LOGFILE GROUP 1B ALTER DATABASE CLEAR LOGFILE GROUP 1C ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’
单选题Your database is in ARCHIVELOG mode. You have two online redo log groups each of which contains one redo member. When you attempt to start the database， you receive the following errors： ORA-00313： open failed for members of log group 1 of thread 1 ORA-00312： online log 1 thread 1： ’D:///REDO01.LOG’ You discover that the online redo log file of the current redo group is corrupted. Which statement should you use to resolve this issue？（）A SQLALTER DATABASE DROP LOGFILE GROUP 1；B SQLALTER DATABASE CLEAR LOGFILE GROUP 1；C SQLALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1；D SQLALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’；
单选题Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）ARECOVER LOGFILE BLOCK GROUP 2；BALTER DATABASE DROP LOGFILE GROUP 2；CALTER DATABASE CLEAR LOGFILE GROUP 2；DALTER DATABASE RECOVER LOGFILE GROUP 2；EALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file： ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3； Which action should you perform immediately after using this command？（）A You should perform a log switchB You should make a backup of the databaseC You should switch the database to the NONARCHIVELOG modeD You should shut down the database instance and perform a complete database recovery
单选题You work as a database administrator for Certkiller .com. Redo log files are not multiplexed in your database. Redo log blocks are corrupted in group 2， and archiving has stopped. All the redo logs are filled and database activity is halted. Database writer has written everything to disk. Which command would you execute to proceed further？（）ARECOVER LOFIEL BLOCK GROUP 2；BALTER DATABASE DROP LOGFILE GROUP 2；CALTER DATABASE CLEAR LOGFILE GROUP 2；DALTER DATABASE RECOVER LOGFILE GROUP 2；EALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 2；
单选题You issued the following command to mount the DATA disk group in restricted mode： ALTER DISKGROUP data MOUNT RESTRICT； What is the implication of this command？（）A The client RDBMS instance can access the file as a read-only file.B A new disk cannot be added to a disk group.C A disk in a disk group can be taken offline.D The client RDBMS instance cannot access the files in the disk group.