V$LOG
V$LOGFILE
DBA_LOG_GROUPS
V$LOG_HISTORY
第1题:
In your database, online redo log files are multiplexed and one of the members in a group is lost due to media failure? How would you recover the lost redo log member?()
第2题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()
第3题:
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
第4题:
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?()
第5题:
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:()
第6题:
You are maintaining your OLTP database in Oracle10g. While observing the performance of the database, you find that the log switch occurs more than once for every 20 minutes, affecting the database performance. Which factor is responsible for frequent log switches?()
第7题:
You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue()
第8题:
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?()
第9题:
In your production database, you have observed that the database server performance degrades whenever there is a switch between the log groups. On further investigation, you find that the database is running in ARCHIVELOG mode and the archived log files are being written to the same disk that is used to store the redo log members. Which two actions would you take to improve the performance of the database server? ()
第10题:
Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery?()