If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
If the lost redo log group is CURRENT, you must clear the log file.
If the lost redo log group is ACTIVE, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
If the lost redo log group is CURRENT, you must restore, perform cancel-based incomplete recovery, and open the database using the RESETLOGS option.
第1题:
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: SQL>ALTER DATABASE OPEN RESETLOGS; Which of the following options is true about using the RESETLOGS option?()
第2题:
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?()
第3题:
The loss of which two types of files may require a recovery with the RESETLOGS option?()
第4题:
Your database is having two control files, three redo log file groups with two members in each group. Failure of which file would cause an instance to shut down?()
第5题:
Which statement about recovering from the loss of a redo log group is true?()
第6题:
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?()
第7题:
The archived redo log files will be overwritten.
The archived redo log files are deleted automatically.
The archived redo log files should be moved to some other location.
The archived redo log files are still maintained because the file names are unique.
第8题:
Increase the size of redo log files
Increase the size of redo log buffer
Increase the number of redo log files
Place the redo log files on a separate disk
Decrease the number of redo log groups to two
Increate the number Log Writer (LGWR) process
第9题:
control files
password file
archived log files
system-critical data files for which all the redo entries are present
non-system-critical data files for which all the redo entries are present
第10题:
The log sequence is reset to 0.
All the online redo logs are deleted.
All the archived redo logs from a previous incarnation become useless.
The full database backup taken from a previous incarnation can be used in future.
Only the control file and online redo log files are updated with a new RESETLOGS SCN and time stamp.
第11题:
SMON would automatically restore the lost file.
You would need to restore the whole database from the last backup.
You would need to restore the file from the last full database backup.
You would need to use flashback technology to restore the lost redo log member.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
You would need to restore the missing log file by copying one of the remaining files from the same group.
第12题:
loss of one of the tablespaces
loss of a system data file
loss of one of the control files
loss of a tempfile
loss of the only member of an unarchived redo log group
loss of a member from each redo log group
第13题:
Which two operations require undo data?()
第14题:
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?()
第15题:
In which of the following scenarios is a tablespace recovery required?()
第16题:
Which statement is true about FLUSH LOGS command?()
第17题:
In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()
第18题:
Transactions are rolled back using redo log files.
Transactions are rolled forward using redo log files.
Transactions are rolled back using redo log files and archived log files.
Transactions are rolled forward using redo log files and rolled back using redo log files.
第19题:
when all the online redo log groups are multiplexed and one of the members of a group is missing
when all the online redo log groups are not multiplexed and one log group is missing
when all the control files are missing
when some important tables are deleted from the database and purged from the Recycle Bin
第20题:
The redo log file should belong to an active group.
The redo log file should belong to an inactive group.
The redo log file should belong to the current group.
The redo log file can be dropped only if all the transactions are stopped.
Before a redo log file is dropped, it should be deleted from the operating system (OS).
第21题:
It requires the RELOAD, FILE, and DROP privileges
It closes and reopens all log files
It closes and sends binary log files to slave servers
It flushes dirty pages in the buffer pool to the REDO logs
第22题:
Inactive and current redo log files are required to accomplish recovery.
Online and archived redo log files are required to accomplish instance recovery.
All redo log entries after the last checkpoint are applied from redo log files to data files.
All redo log entries recorded in the current redo log file until the checkpoint position are applied to data files
第23题:
Inactive and current redo log files are required to accomplish recovery.
Online and archived redo log files are required to accomplish instance recovery.
All redo log entries after the last checkpoint are applied from redo log files to data files.
All redo log entries recorded in the current redo log file until the checkpoint position are applied to datafiles.
第24题:
If the lost redo log group is ACTIVE, you should first attempt to clear the log file.
If the lost redo log group is CURRENT, you must clear the log file.
If the lost redo log group is ACTIVE, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.
If the lost redo log group is CURRENT, you must restore,perform cancel-based incomplete recovery,and open the database using the RESETLOGS option.