单选题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()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

单选题
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


参考解析

解析: 暂无解析

相关考题:

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

The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring 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 data files

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

You are in the middle of a transaction and very crucial data has been modified. Because of a hardware failure, the instance has shut down before synchronizing all the database files. Which two statements are true?()A、On startup, SMON coordinates instance recovery.B、On startup, CKPT coordinates instance recovery.C、On startup, use RMAN to perform instance recovery.D、Uncommitted changes will be rolled back after the database is opened.E、On startup, perform media recovery and then instance recovery.F、On startup, all the files will be synchronized and you get both committed and uncommitted data.

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

Which two statements are true regarding the database in ARCHIVELOG mode?()A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A、 The log sequence is reset to 0.B、 All the online redo logs are deleted.C、 All the archived redo logs from a previous incarnation become useless.D、 The full database backup taken from a previous incarnation can be used in future.E、 Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

You have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database?()A、The database would open normally.B、The database would not open, and it would stop at mount stage.C、The database would open after automatically performing instance recovery.D、The database would not open, and you have to perform database recovery to open it.

After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL ALTER DATABASE OPEN; Which two statements are true()A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked

You performed an incomplete recovery and opened the database with the RESETLOGS option. The LOG_ARCHIVE_FORMAT parameter is set to ’ora_%t_%s_%r.log’.  Which statement regarding the archived redo log files, created in an earlier incarnation of the database,is true?()A、 The archived redo log files will be overwritten.B、 The archived redo log files are deleted automatically.C、 The archived redo log files should be moved to some other location.D、 The archived redo log files are still maintained because the file names are unique.

After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL ALTER DATABASE OPEN;  Which two statements are true()A、The online redo log files and online data files are opened.B、All the online data file headers are checked for consistency.C、Instance recovery is performed before opening the database.D、The path and existence of all the log file members are checked

The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()A、until SCNB、until timeC、until cancelD、using backup control file

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.

You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A、 The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B、 Before the instance starts, you receive an error about the missing redo log files of a group.C、 The instance starts and the database opens with an error message written to the alert log file.D、 The instance starts and the database opens because two redo log groups still exist.E、 The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

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’;

单选题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.

单选题You are working on the PROD database, which is in NOARCHIVELOG mode. You lost the active online redo log group due to a media failure. How should you recover your database?()A Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, open the database with the RESETLOGS option after performing a cancel-based recovery.B Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, drop the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.C Restore the database from a whole consistent backup and start the database in MOUNT mode. Then, clear the lost redo log group and open the database with the RESETLOGS option after performing a cancel-based recovery.D Do nothing. You do not need to recover the database in this case; an instance recovery will be performed by the SMON process on startup.

单选题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.

多选题After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL ALTER DATABASE OPEN; Which two statements are true()AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked

单选题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

单选题You have recovered your Oracle Database 10g by using the control file backup because all copies of the current control file have been lost due to a media failure. You open your database by using the following statement:       SQLALTER DATABASE OPEN RESETLOGS;   Which of the following options is true about using the RESETLOGS option?()A The log sequence is reset to 0.B All the online redo logs are deleted.C All the archived redo logs from a previous incarnation become useless.D The full database backup taken from a previous incarnation can be used in future.E Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.

单选题The database is being restored from a closed backup. The data files, control files, password file, and parameter file are available, but the online redo logs are not. Because the online redo logs are not available, you must simulate recovery and alter the database open with the reset logs option so the online redo logs are created while the database opens. Which type of recover is used in this situation?()Auntil SCNBuntil timeCuntil cancelDusing backup control file

单选题The instance abnormally terminates because of a power outage.  Which statement is true about redo log filesduring 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 data files

单选题You are working on a database, where you have three redo log groups. When the database is down for a backup, an operating system (OS) user deletes all the redo log files in a group. What will happen when you open your database?()A The instance starts, the database is mounted, but efforts to open the database fail, and an error about the missing redo log group is displayed.B Before the instance starts, you receive an error about the missing redo log files of a group.C The instance starts and the database opens with an error message written to the alert log file.D The instance starts and the database opens because two redo log groups still exist.E The instance starts and the database opens, but every attempt to write to redo log files fails with an error.

单选题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 have to shut down the database instance with the ABORT option because of a hardware failure. Which statement is true about the subsequent opening of the database?()AThe database would open normally.BThe database would not open, and it would stop at mount stage.CThe database would open after automatically performing instance recovery.DThe database would not open, and you have to perform database recovery to open it.

单选题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()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

多选题After performing a clean shut down of the database instance for maintenance, you mount thedatabase and then execute a command to open the database: SQL ALTER DATABASE OPEN;  Which two statements are true()AThe online redo log files and online data files are opened.BAll the online data file headers are checked for consistency.CInstance recovery is performed before opening the database.DThe path and existence of all the log file members are checked