current redo log and inactive redo log
checkpoint position to end of redo log
beginning of redo log to end of redo log
all redo logs before the point of last commit
beginning of redo log to checkpoint position
第1题:
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()
第2题:
Because of a power outage, instance failure has occurred. From what point in the redo log does recovery begin and where does it end?()
第3题:
A.TARGET_REDO_BLKS
B.FAST_START_IO_TARGET
C.LOG_CHECKPOINT_TIMEOUT
D.RECOVERY_ESTIMATED_IOS
E.LOG_FILE_SIZE_REDO_BLKS
F.LOG_CHECKPOINT_INTERVAL
第4题:
A redo log file is corrupted while the database is open; as a consequence, database operations are stopped because archiving cannot continue. What would you do to solve the problem?()
第5题:
A database is running In ARCHIVBXXMS mode. It has two online redo log groups and each group has one member. A LGWR Input/output (I/O) fells due to permanent media failure that has resulted In the loss of redo log file and the LWGR terminates causing the instance to crash. The steps to recover from the loss of a current redo log group member in the random order are as follow. 1) Restore the corrupted redo log group. 2) Restore from a whole database backup. 3) Perform incomplete recovery. 4) Relocate by renaming the member of the damaged online redo log group to a new location. 5) Open the database with the RESETLOGS option. 6) Restart the database instance. 7) Issue a checkpoint and clear the log. Identify the option with the correct sequential steps to accomplish the task efficiently().
第6题:
You configured the Flash Recovery Area for your database. The database instance has been started inARCHIVELOG mode and the LOG_ARCHIVE_DEST_1 parameter is not set. What will be the implications onthe archiving and the location of archive redo log files()
第7题:
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?()
第8题:
The instance abnormally terminates because of a power outage. Which statement is true about redo log filesduring instance recovery()
第9题:
Which statement about recovering from the loss of a redo log group is true?()
第10题:
The instance abnormally terminates because of a power outage. Which statement is true about redolog files during instance recovery()