多选题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

多选题
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 buffer

B

increase the number of redo log groups

C

increase the number of log writer processes

D

increase the number of ARCn processes

E

change the appropriate LOG_ARCHIVE_DEST_n parameter to place the archived log files in a separate location


参考解析

解析: 暂无解析

相关考题:

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each.One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;Which action should you perform immediately after using this command?()A. You should perform a log switchB. You should make a backup of the databaseC. You should switch the database to the NONARCHIVELOG modeD. You should shut down the database instance and perform a complete database recovery

You find today’s performance of your production database to be the best ever. Therefore, you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this?()A、create baseline metrics for today’s performanceB、write the current database metrics to a database table and create a trigger to compare with future database statisticsC、write the current database metrics to a flat file and create an operating script to compare with future database statisticsD、write the current database metrics to a database table and create a procedure to compare with future database statisticsE、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. One of the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:   ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3;   Which action should you perform immediately after using this command?()  A、 You should perform a log switchB、 You should make a backup of the databaseC、 You should switch the database to the NONARCHIVELOG modeD、 You should shut down the database instance and perform a complete database recovery

While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch? ()(Choose two.)A、An entry is created in the alert log file and the database instance continues to function normallyB、The log switch hangs occur for transactions until free space is available in the flash recovery areaC、The Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery areaD、The database instance status is implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

You want to use the automatic management of backup and recovery operations features for your database.Which configuration must you set?()A、Enable the flash recovery area and specify it as the archived redo log destination.B、Disable the flash recovery area and start the database instance in ARCHIVELOG mode.C、Enable the flash recovery area but do not specify it as the archived redo log destination.D、Disable the flash recovery area and start the database instance in NOARCHIVELOG mode

Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer

Which two statements are true regarding the database in ARCHIVELOG mode?()A、You have to shut down the database to perform the backups.B、Archiving information is written to the data files and redo log files.C、You can perform complete database backups without closing the database.D、Online redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.E、All the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

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

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’

You work as a database administrator for Supportcenter.cn. You received the following error while working on your database: ORA-01555: snapshot too old ,In which situation would you receive such an error?()A、You performed rollback after commit.B、If a log switch occurs in your database.C、Thearchiverfails to generate an archived log file.D、Instance recovery fails to find one of the redo log files.E、A long-running query is unable to get read-consistent image.F、If you perform manual undo management operations in auto mode.

You configured the Flash Recovery Area (FRA) for your database. The database instance is runningin ARCHIVELOG mode. The default location for the archived redo log files is the Flash Recovery Area.  Which two files are removed automaticallyif the space is required in the FRA as per the retention policy()A、flashback log filesB、backups that have become obsoleteC、copies of the data files and control filesD、archived redo log files that have multiple copies in a different archive location and not backed up

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

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

You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?() A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.

You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal?()  A、You should recreate the indexes. B、You should compress the log file backups C、You should make the Dworks database use the Full recovery mode D、You should make the Dworks database use the Simple recovery mode.

多选题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

多选题While Monitoring the space usage in your database that is in ARCHIVELOG mode you observed that the flash recovery area does not have enough free space to accommodate any more files and you do not have necessary permissions to add more space to it. Identify the two events that can occur in the event of a log switch?()AAn entry is created in the alert log file and the database instance continues to function normallyBThe log switch hangs occur for transactions until free space is available in the flash recovery areaCThe Oracle database server deletes a file that is on the obsolete file list to make free space in the flash recovery area OracleDThe database instance statusis implicitly changed to RESTRICTED mode and file creations to the flash recovery area are prevented

单选题The database is running in the ARCHIVELOG mode. It has three redo log groups with one member each. Oneof the redo log groups has become corrupted. You have issued the following command during the recovery of a damaged redo log file:ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 3; Which action should you perform immediately after using this command?()AYou should perform a log switchBYou should make a backup of the databaseCYou should switch the database to the NONARCHIVELOG modeDYou should shut down the database instance and perform a complete database recovery

单选题You work as a database administrator for Certkiller .com. You received the following error while working on your database: ORA-01555: snapshot too old  In which situation would you receive such an error?()AYou performed rollback after commit.BIf a log switch occurs in your database.CThearchiverfails to generate an archived log file.DInstance recovery fails to find one of the redo log files.EA long-running query is unable to get read-consistent image.FIf you perform manual undo management operations in auto mode.

多选题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.

多选题Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()AarchivalBlog writerCdatabase writerDsystem monitorEprocess monitorFchange tracking writer

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

多选题Which two statements are true regarding the database in ARCHIVELOG mode?()AYou have to shut down the database to perform the backups.BArchiving information is written to the data files and redo log files.CYou can perform complete database backups without closing the database.DOnline redo log files have to be multiplexed before putting the database in ARCHIVELOG mode.EAll the previous database backups become invalid after you configure the database to ARCHIVELOG mode.

单选题You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which is named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks database. You log ship the Dworks database through a WAN link. A scheduled job rebuilds the indexes of the Dworks database. You find that the size of the log backups for log shipping has been enlarged by the job. Now you have to reduce the size of the log backup.  So what action should you perform to achieve this goal?()AYou should recreate the indexes. BYou should compress the log file backups CYou should make the Dworks database use the Full recovery mode DYou should make the Dworks database use the Simple recovery mode.