【单选题】A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log?()
C.
Perform recovery on the database.
D.
Restore the alert log from the last backup.
【单选题】When you are performing media recover, and an archived log is lost or corrupt, which type of recover must you perform?()
D.
Recover using backup control file.
【单选题】The configuration of the online redo log files is as follows: Based on this configuration, which statement is true?()
A.
The LGWR process concurrently writes the redo log entries to both the members of a group.
B.
When a member of a group becomes corrupt, the database crashes.
C.
The sizes of the redo01a.log and redo01b.log online redo log members of group Group1 can be different.
D.
When redo02a.log and redo02b.log files become corrupt, then the database operations will proceed as normal.
【简答题】After he had worked as a doctor for some years, he decided to focus his study on children's diseases.
【单选题】This is the online redo log files and the control file configurations: Based on these configurations, which statement is true?()
A.
Both the control files and the online redo log files are configured properly.
B.
The control files are configured properly, but the online redo log files are not configured properly.
C.
The online redo log files are configured properly, but the control files are not configured properly.
D.
Neither the control files nor the online redo log files are configured properly.
【单选题】Redo log files are multiplexed in your database. The disk in which you have one of the redo log members is highly fragmented. In the process of defragmentation you lose the redo log member, which is n...
A.
SMON would automatically restore the lost file.
B.
You would need to restore the whole database from the last backup.
C.
You would need to restore the file from the last full database backup.
D.
You would need to use flashback technology to restore the lost redo log member.
E.
You would need to use Recovery Manager (RMAN) to restore the lost redo log member.
F.
You would need to restore the missing log file by copying one of the remaining files from the same group.