单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）ASize of redo logs BNumber of datafiles CLOG_CHECKPOINT_INTERVAL DLOG_CHECKPOINT_TIMEOUT
单选题
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）
A
Size of redo logs
B
Number of datafiles
C
LOG_CHECKPOINT_INTERVAL
D
LOG_CHECKPOINT_TIMEOUT
参考解析
解析：
暂无解析
相关考题：
You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）A、Writes buffers to disk B、Writes current redo log number to datafile headers C、Writes redo log information to disk D、Reads information into memory for users
You can control instance recover performance by setting parameters to define targets for（）A、The size of the redo buffer in SGA. B、The instance that will perform recovery in Real Application Cluster database. C、The number of blocks to be read during instance recovery, or the time needed to complete instance recovery. D、The number of passes through the redo logs made by the recovery process to identify blocks needing recovery.
You work as a database administrator for Certkiller .com. Users in the Certkiller PROD database complain about the slow response when accessing the database. In the Active Session Waiting： Configuration page you find that the majority of the wait time is for the redo log buffer.Further investigation using the Run Queue graph and operating system tools reveals that the redo log files are on the same disks， and that the disk I/O for the redo log files is the reason for the performance degradation. Which two actions would you take to gain performance？（）A、Increase the size of redo log filesB、Increase the size of redo log bufferC、Increase the number of redo log filesD、Place the redo log files on a separate diskE、Decrease the number of redo log groups to twoF、Increate the number Log Writer （LGWR） process
Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）A、Data blocks have to be written more frequently by DBWR. B、Redo blocks have to be written more frequently by LGWR. C、You need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. D、You need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）A、Shared pool B、Control file C、SGA D、PGA
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 are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）A、 online redo log filesB、 alert log filesC、 control fileD、 datafiles associated with the SYSTEM tablespace
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.
Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）A、TARGET_REDO_BLKSB、FAST_START_IO_TARGETC、LOG_CHECKPOINT_TIMEOUTD、RECOVERY_ESTIMATED_IOSE、LOG_FILE_SIZE_REDO_BLKSF、LOG_CHECKPOINT_INTERVAL
You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）A、Database Datafiles B、Database Control Files C、Online redo logsD、Archived redo logs E、The database SPFILE F、None of the above, all these files are 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
You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）A、Size of redo logs B、Number of datafiles C、LOG_CHECKPOINT_INTERVAL D、LOG_CHECKPOINT_TIMEOUT
You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A、 The archived redo logs are stored in an operating system-dependent location.B、 The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C、 The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D、 The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
Your database performance has degraded due to frequent checkpointing. What would you do in this scenario？（）A、make redo log files smallerB、increase the size of the checkpoint fileC、make the changes as per the advice given by MTTR AdvisorD、make the changes as per the advice given by Checkpoint Advisor
If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）A、V_CONTROLFILE_RECORD_SECTION B、V_CONTROLFILE C、V$PARAMETER D、init.ora file
Which statement is true regarding checkpoints and recovery？（）A、A checkpoint defines the highest system change number （SCN）.B、All redo entries higher or at the SCN are known to be written to the data files.C、Only the redo records containing SCNs higher then the checkpoint need to be applied during recovery.D、The LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
单选题If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）AV_CONTROLFILE_RECORD_SECTION BV_CONTROLFILE CV$PARAMETER Dinit.ora file
多选题Which three initialization parameters are no longer needed when FAST_START_MTTR_TARGET is defined？（）ATARGET_REDO_BLKSBFAST_START_IO_TARGETCLOG_CHECKPOINT_TIMEOUTDRECOVERY_ESTIMATED_IOSELOG_FILE_SIZE_REDO_BLKSFLOG_CHECKPOINT_INTERVAL
单选题Which statement is true regarding checkpoints and recovery？（）AA checkpoint defines the highest system change number （SCN）.BAll redo entries higher or at the SCN are known to be written to the data files.COnly the redo records containing SCNs higher then the checkpoint need to be applied during recovery.DThe LOG_CHECKPOINT_INTERVAL initialization parameter specifies the amount of time between incremental checkpoints.
单选题You are adding redo logs to the Oracle database. Creating a new redo log adds information to which of the following Oracle resources? （）AShared pool BControl file CSGA DPGA
多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which twoactions resolve the issue（）ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.DDecrease the number of redo log members if there are more than one redo log members available in eachredo log group.
单选题You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）A online redo log filesB alert log filesC control fileD datafiles associated with the SYSTEM tablespace
单选题You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file autobackups. Which files are not backed up during the RMAN backup?（）ADatabase Datafiles BDatabase Control Files COnline redo logsDArchived redo logs EThe database SPFILE FNone of the above, all these files are backed up.
单选题You are analyzing the components of the redo log mechanisms in your Oracle database. Which of the following purposes does the CKPT process serve?（）AWrites buffers to disk BWrites current redo log number to datafile headers CWrites redo log information to disk DReads information into memory for users
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）A Oracle Enterprise ManagerB The V$LOG viewC The V$LOGFILE viewD The V$FLASHBACK_DATABASE_LOGS view
单选题You are attempting to increase the checkpoint interval on your database. Each of the following choices will affect the duration and/or frequency of checkpoints, except one. Which is it?（）ASize of redo logs BNumber of datafiles CLOG_CHECKPOINT_INTERVAL DLOG_CHECKPOINT_TIMEOUT
单选题You are working as a DBA on Oracle Database 9i. You plan to upgrade your 9i database to Oracle 10g. To be familiar with the new database technology， you decide to install Oracle Database 10g on your workstation at home. You create a general purpose database. After the installation， you make the following changes in your initialization parameter file：LOG_ARCHIVE_DEST_1=’LOCATION=USE_DB_RECOVERY_FILE_DEST’ DB_RECOVERY_FILE_DEST = ’LOCATION=d：/product/10.1.0/flash_recovery_area’ DB_RECOVERY_FILE_DEST_SIZE=10g Where are the archived redo logs stored for your database？（）A The archived redo logs are stored in an operating system-dependent location.B The archived redo logs are stored in the location specified by LOG_ARCHIVE_DEST_1.C The archived redo logs are stored in the location specified by DB_RECOVERY_FILE_DEST.D The archived redo logs are stored in the locations specified by both LOG_ARCHIVE_DEST_1 and DB_RECOVERY_FILE_DEST.
多选题You notice that the performance of the database has degraded because of frequent checkpoints. Which two actions resolve the issue（）ADisable automatic checkpoint tuning.BCheck the size of the redo log file size and increase the size if it is small.CSet the FAST_START_MTTR_TARGET parameter as per the advice given by the MTTR Advisor.DDecrease the number of redo log members if there are more than one redo log members available in each redo log group.