单选题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
参考解析
解析：
暂无解析
相关考题：
Your company has a main office and two branch offices that are connected by WAN links. The main office runs the DNS Server service on three domain controllers. The zone for your domain is configured as an Active Directory-integrated zone. Each branch office has a single member server that hosts a secondary zone for the domain. The DNS servers in the branch offices use the main office DNS server as the DNS Master server for the zone. You need to minimize DNS zone transfer traffic over the WAN links.What should you do？（）A. Decrease the Retry Interval setting in the Start of Authority (SOA) record for the zone.B. Decrease the Refresh Interval setting in the Start of Authority (SOA) record for the zone.C. Increase the Refresh Interval setting in the Start of Authority (SOA) record for the zone.D. Disable the netmask ordering option in the properties of the DNS Master server for the zone.
Examinethevaluesforthefollowinginitializationparameters:FAST_START_MTTR_TARGET=0LOG_CHECKPOINT_INTERVAL=0Whichtwowillbetheimplicationsofthesevaluesinyourdatabase() A.TheSGAadvisorwillbedisabled.B.TheMTTRadvisorwillbedisabled.C.Automaticcheckpointtuningwillbedisabled.D.Checkpointinformationwillnotbewrittentothealertlogfile.
Youneedtoensurethatthedatabaseusersshouldbeabletousethevariousflashbackqueryfeaturesinordertogobackintimebyfourhours.Whatwouldyoudotoachievethis?() A.setSQL_TRACE=TrueB.setUNDO_RETENTION=14400C.setFAST_START_MTTR_TARGET=240D.setLOG_CHECKPOINT_INTERVAL=240E.setDB_FLASHBACK_RETENTION_TARGET=14400F.settheRETENTIONGUARANTEEclausefortheundotablespace
WhichthreeinitializationparametersarenolongerneededwhenFAST_START_MTTR_TARGETisdefined?() A.TARGET_REDO_BLKSB.FAST_START_IO_TARGETC.LOG_CHECKPOINT_TIMEOUTD.RECOVERY_ESTIMATED_IOSE.LOG_FILE_SIZE_REDO_BLKSF.LOG_CHECKPOINT_INTERVAL
Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）A、The MTTR advisor will be disabled.B、Automatic checkpoint tuning will be enabled.C、The value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.D、The time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.
Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）A、 increase the number of checkpoint processesB、 define the POWER option while adding or removing the disksC、 increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESD、 increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVESE、 increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal
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.
Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）A、The SGA advisor will be disabled.B、The MTTR advisor will be disabled.C、Automatic checkpoint tuning will be disabled.D、Checkpoint information will not be written to the alert log file.
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
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
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.
You are designing a site topology to meet the business and technical requirements. What should you do?（）A、Increase the replication interval between sites.B、Use SMTP as the transport protocol for replication.C、Create site links to represent the physical topology. D、Disable the Knowledge Consistency Checker (KCC) and manually configure site replication.
Your company has two domain controllers that are configured as internal DNS servers. All zones on the DNS servers are Active Directory-integrated zones. The zones allow all dynamic updates. You discover that the contoso.com zone has multiple entries for the host names of computers that do not exist. You need to configure the contoso.com zone to automatically remove expired records. What should you do（）A、Enable only secure updates on the contoso.com zone.B、Enable scavenging and configure the refresh interval on the contoso.com zone.C、From the Start of Authority tab， decrease the default refresh interval on the contoso.com zone.D、From the Start of Authority tab， increase the default expiration interval on the contoso.com zone.
Your company has two domain controllers that are configured as internal DNS servers. All zones on The safer , easier way to help you pass any IT exams. 6 / 90 the DNS servers are Active Directory-integrated zones. The zones allow all dynamic updates. You discover that the contoso.com zone has multiple entries for the host names of computers that do not exist. You need to configure the contoso.com zone to automatically remove expired records. What should you do（） A、Enable only secure updates on the contoso.com zone.B、Enable scavenging and configure the refresh interval on the contoso.com zone.C、From the Start of Authority tab， decrease the default refresh interval on the contoso.com zone.D、From the Start of Authority tab， increase the default expiration interval on the contoso.com zone.
Your company has a main office and two branch offices that are connected by WAN links. The main office runs the DNS service on three domain controllers. The zone for your domain is configured as an Active Directory-integrated zone. Each branch office has a single member server that hosts a secondary zone for the domain. The DNS servers in the branch offices use the main office DNS server as the DNS Master server for the zone. You need to minimize DNS zone transfer traffic over the WAN links. What should you do？（）A、Decrease the Retry Interval setting in the Start of Authority （SOA） record for the zoneB、Decrease the Refresh Interval setting in the Start of Authority （SOA） record for the zoneC、Increase the Refresh Interval setting in the Start of Authority （SOA） record for the zoneD、Disable the netmask ordering option in the properties of the DNS master server for the zone.
单选题A quite simple method of improving a berth’s capacity is（）.Ato increase the arrival／start of operations intervalBto increase the finishing of operations／leaving berth intervalCto decrease both the arrival／start of operations interval and the finishing of operations／leaving berth intervalDto decrease working shifts
单选题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
单选题Your company has a main office and a branch office. The company network has two WINS servers.You have an application that requires NetBIOS name resolution.The WINS servers are configured as shown in the following table. Location Server name IP address Main office DC1 10.1.0.23 Branch office DC2 10.6.0.254 You discover that the WINS addresses on all client computers in both offices are configured in the following order of use: 10.1.0.23 10.6.0.254 You reconfigure the WINS addresses on all client computers in the branch office in the following order of use: 10.6.0.254 10.1.0.23 After the reconfiguration, users in the branch office are unable to connect to the servers that are located in the main office.You need to restore name resolution in the branch office. What should you do?（）AConfigure the burst handling option on DC2.BConfigure DC1 and DC2 as WINS push/pull replication partners.CIn the WINS server properties on DC1, increase the Renew interval setting to 1 day.DIn the WINS server properties on DC2, increase the Renew interval setting to 1 day.
多选题Examine the values for the following initialization parameters： FAST_START_MTTR_TARGET = 0LOG_CHECKPOINT_INTERVAL = 0 Which two will be the implications of these values in your database（）AThe SGA advisor will be disabled.BThe MTTR advisor will be disabled.CAutomatic checkpoint tuning will be disabled.DCheckpoint information will not be written to the alert log file.
多选题Which two statements are true about setting the FAST_START_MTTR_TARGET initialization parameter to anonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.DThe time taken to recover the instance after the crash is always exactly the same as the value given for theinitialization parameter.
单选题Your company has a main office and a branch office. The company network has two WINS servers.You have an application that requires NetBIOS name resolution.The WINS servers are configured as shown in the following table. Location Server name IP address Main office DC1 10.1.0.23 Branch office DC2 10.6.0.254 You discover that the WINS addresses on all client computers in both offices are configured in the following order of use: 10.1.0.23 10.6.0.254 You reconfigure the WINS addresses on all client computers in the branch office in the following order of use: 10.6.0.254 10.1.0.23 After the reconfiguration, users in the branch office are unable to connect to the servers that are located in the main office.You need to restore name resolution in the branch office. What should you do?（）AConfigure the burst handling option on DC2.BConfigure DC1 and DC2 as WINS push/pull replication partners.CIn the WINS server properties on DC1, increase the Renew interval setting to 1 day.DIn the WINS server properties on DC2, increase the Renew interval setting to 1 day.
单选题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 need to ensure that the database users should be able to use the various flashback query features in order to go back in time by four hours. What would you do to achieve this?（）Aset SQL_TRACE=TrueBset UNDO_RETENTION=14400Cset FAST_START_MTTR_TARGET=240Dset LOG_CHECKPOINT_INTERVAL=240Eset DB_FLASHBACK_RETENTION_TARGET=14400Fset the RETENTION GUARANTEE clause for the undo tablespace
单选题Why can setting too low a value for the FAST_START_MTTR_TARGET parameter reduce your overall database performance？（）AData blocks have to be written more frequently by DBWR. BRedo blocks have to be written more frequently by LGWR. CYou need to substantially increase the size of your database buffer cache to hold the additional checkpoint records. DYou need to substantially increase the size of your redo buffer cache to hold the additional checkpoint records.
多选题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 two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero value（）AThe MTTR advisor will be disabled.BAutomatic checkpoint tuning will be enabled.CThe value for the LOG_CHECKPOINT_INTERVAL initialization parameter will be override the value forFAST_START_MTTR_TARGET.DThe time taken to recover the instance after the crash is always exactly the same as the value given forthe FAST_START_MTTR_TARGET initialization parameter.
单选题You are developing a Windows Azure application in which a web role and worker role will communicate by using a Windows Azure Queue. You need to recommend an approach for ensuring that the worker role does not attempt to process any message more than three times. What should you recommend？（）A Appropriately handle poison messages.B Decrease the visibility timeout for messages.C Reduce the time-to-live interval for messages in the queue.D Increase the number of worker role instances reading messages from the queue.
单选题You are designing a site topology to meet the business and technical requirements. What should you do？（）A Increase the replication interval between sites，B Use SMTP as the transport protocol for replication.C Create site links to represent the physical topology.D Disable the Knowledge Consistency Checker （KCC） and manually configure site replication.