网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members?()
A

 V$LOG

B

 V$LOGFILE

C

 DBA_LOG_GROUPS

D

 V$LOG_HISTORY


参考答案

参考解析
解析: 暂无解析
更多 “单选题The performance of your database is affected by the presence of two log members in each online redo log group and the placement of redo log members of a group on the same disk. You decide to place the redo log members of a group on separate disks. Which view will you query to find the name and location of all the online redo log members?()A  V$LOGB  V$LOGFILEC  DBA_LOG_GROUPSD  V$LOG_HISTORY” 相关考题
考题 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

考题 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

考题 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?()A、 import the database from the last exportB、 restore all the members in the group from the last backupC、 drop the lost member from the database and then add a new member to the groupD、 restore all the database files from the backup and then perform a complete recoveryE、 restore all the database files from the backup and then perform an incomplete recovery

考题 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?()  A、the value of the UNDO_RETENTION initialization parameterB、the value of the optimal redo log file size provided by the Redo Logfile Size AdvisorC、the online redo log files sizeD、the number of redo log members in a group

考题 You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue()A、Disable automatic checkpoint tuning.B、Check the size of the redo log file size and increase the size if it is small.C、Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor. D、Decrease the number of redo log members if there are more than one redo log members available in each redo log group.

考题 You notice that the performance of the database has degraded because of frequent checkpoints.  Which twoactions resolve the issue()A、Disable automatic checkpoint tuning.B、Check the size of the redo log file size and increase the size if it is small.C、Set the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.D、Decrease the number of redo log members if there are more than one redo log members available in eachredo log group.

考题 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:()A、 ALTER DATABASE DROP LOGFILE GROUP 1B、 ALTER DATABASE CLEAR LOGFILE GROUP 1C、 ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1D、 ALTER DATABASE DROP LOGFILE MEMBER ’D:///REDO01.LOG’

考题 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? ()A、increase the size of the redo log bufferB、increase the number of redo log groupsC、increase the number of log writer processesD、increase the number of ARCn processesE、change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

考题 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?()A、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo01b.log’ TO GROUP 1;B、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo01b.log’ TO GROUP 1;C、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo02b.log’ TO GROUP 2;D、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo02b.log’ TO GROUP 2;E、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk1/oradata/redo3b.log’ TO GROUP 3;F、 ALTER DATABASE ADD LOGFILE MEMBER ’/disk2/oradata/redo3b.log’ TO GROUP3;

考题 Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel/x7fbased recovery?()A、You find that one of the redo log members in each redo log group is lost.B、You find that a data file that belongs to the USERS tablespace is damaged.C、You find that a data file that belongs to the SYSTEM tablespace is damaged.D、You find that the current redo log group is damaged and is not available for recovery.E、You realized while performing a recovery that an archived redo log file needed for recovery is lost.

考题 Your database is in NOARCHIVELOG mode. The database has three online redo log groups, and each group contains three online redo log members. The online redo log members are stored across three hard disks, E, F, and G, respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database?()A、 The database will operate normally without generating any redo.B、 The database will hang, and you must shut down and restart the instance.C、 The database will crash, and you must recover the database from the point of failure.D、 The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

考题 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?()A、any control fileB、any archive log fileC、one of the redo log membersD、loss of the initialization parameter fileE、any data file belonging to the default permanent tablespac

考题 In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()A、 when all the online redo log groups are multiplexed and one of the members of a group is missingB、 when all the online redo log groups are not multiplexed and one log group is missingC、 when all the control files are missingD、 when some important tables are deleted from the database and purged from the Recycle Bin

考题 The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?() A、 The database will hang.B、 The database will be crashed.C、 The database will be shut down.D、 The LGWR process writes redo log entries to the other redo log member of the Group2 group

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

考题 多选题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? ()Aincrease the size of the redo log bufferBincrease the number of redo log groupsCincrease the number of log writer processesDincrease the number of ARCn processesEchange the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location

考题 单选题The online redo log group configuration for your database is as follows: What will happen if the online redo log file ’ora02/oradata/redo02b.log’is corrupted while working on the database?()A  The database will hang.B  The database will be crashed.C  The database will be shut down.D  The LGWR process writes redo log entries to the other redo log member of the Group2 group

考题 单选题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 not a member of the current group. How would you recover from the loss of the redo log member?()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.

考题 单选题Your database is in NOARCHIVELOG mode. The database has three online redo log groups, and each group contains three online redo log members. The online redo log members are stored across three hard disks, E, F, and G, respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database?()A  The database will operate normally without generating any redo.B  The database will hang, and you must shut down and restart the instance.C  The database will crash, and you must recover the database from the point of failure.D  The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

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

考题 单选题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?()A any control fileB any archive log fileC one of the redo log membersD loss of the initialization parameter fileE any data file belonging to the default permanent tablespac

考题 多选题Your database is functioning in ARCHIVELOG mode. In which two situations would you perform a cancel-based recovery? ()AYou find that one of the redo log members in each redo log group is lost.BYou find that a data file that belongs to the USERS tablespace is damaged.CYou find that a data file that belongs to the SYSTEM tablespace is damaged.DYou find that the current redo log group is damaged and is not available for recovery.EYou realized while performing a recovery that an archived redo log file needed for recovery is lost.

考题 单选题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?()A import the database from the last exportB restore all the members in the group from the last backupC drop the lost member from the database, and then add a new member to the groupD restore all the database files from the backup, and then perform a complete recovery E restore all the database files from the backup, and then perform an incomplete recovery

考题 单选题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’;

考题 单选题In which scenario is a Database Administrator NOT required to perform an incomplete recovery?()A  when all the online redo log groups are multiplexed and one of the members of a group is missingB  when all the online redo log groups are not multiplexed and one log group is missingC  when all the control files are missingD  when some important tables are deleted from the database and purged from the Recycle Bin

考题 单选题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?()A the value of the UNDO_RETENTION initialization parameterB the value of the optimal redo log file size provided by the Redo Logfile Size AdvisorC the online redo log files sizeD the number of redo log members in a group

考题 单选题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?()A  import the database from the last exportB  restore all the members in the group from the last backupC  drop the lost member from the database and then add a new member to the groupD  restore all the database files from the backup and then perform a complete recoveryE  restore all the database files from the backup and then perform an incomplete recovery