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

考题 Which statements about the MEMORY_TARGET initialization parameter are true？（） A、 MEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zeroB、 MEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setC、 MEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.D、 MEMORY_TARGET is static and cannot be modified without shutting down the instance

查看答案

考题 Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）A、The foo initialization parameter CANNOT be set programmatically.B、Compilation fails because getInitParameter returns type Object.C、The foo initialization parameter is NOT a servlet initialization parameter.D、Compilation fails because ServletContext does NOT have a getInitParameter method.E、The foo parameter must be defined within the element of the deployment descriptor.

查看答案

考题 You are maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A、 Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B、 Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C、 Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D、 Increase the value of the SGA_TARGET initialization parameter.

查看答案

考题 Which two statements are true regarding the SGA_TARGET initialization parameter（）A、It can be increased up to the value of the SGA_MAX_SIZE parameter.B、Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.C、Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.D、Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

查看答案

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

查看答案

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

查看答案

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

查看答案

考题 An RMAN backup job fails， displaying the following error： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）A、take the backup of the flash recovery area less frequentlyB、increase the value of the UNDO_RETENTION initialization parameterC、change the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTOD、change the backup retention policy to retain the backups for a smaller period of time E、increase the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterF、increase the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

查看答案

考题 What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）A、MTTR Advisor would be disabled.B、Redo Log Advisor would be disabled.C、Automatic tuning of checkpoint would be disabled.D、Checkpoint information would not be written to the alert log file.

查看答案

考题 You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？（）A、 Modifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.B、 Modifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.C、 Increasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.D、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.E、 Increasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.F、 Decreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

查看答案

考题 Which two statements are true about setting the FAST_START_MTTR_TARGET initializationparameter to a nonzero 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 forthe FAST_START_MTTR_TARGET initialization parameter.

查看答案

考题多选题An RMAN backup job fails， displaying the following error： ORA/x7f19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in future？（）Atake the backup of the flash recovery area less frequentlyBincrease the value of the UNDO_RETENTION initialization parameterCchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTODchange the backup retention policy to retain the backups for a smaller period of timeEincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterFincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

查看答案

考题多选题An RMAN backup job fails， displaying the following error： ORA-19809： limit exceeded for recovery files Your analysis shows that the Flash Recovery area is full. Which two actions could you take to resolve the error and avoid this error in the future？（）Atake the backup of the flash recovery area less frequentlyBincrease the value of the UNDO_RETENTION initialization parameterCchange the value of the WORKAREA_SIZE_POLICY initialization parameter to AUTODchange the backup retention policy to retain the backups for a smaller period of timeEincrease the value of the DB_RECOVERY_FILE_DEST_SIZE initialization parameterFincrease the value of the CONTROL_FILE_RECORD_KEEP_TIME initialization parameter

查看答案

考题多选题Which statements about the MEMORY_TARGET initialization parameter are true？（）AMEMORY_TARGET can be increased up to the value of MEMORY_MAX_TARGET， if MEMORY_MAX_TARGET is set to a value greater than zeroBMEMORY_MAX_TARGET defaults to a value of zero if MEMORY_TARGET is not setCMEMORY_TARGET represents the total amount of memory that can be allocated to SGA and PGA memory structures.DMEMORY_TARGET is static and cannot be modified without shutting down the instance

查看答案

考题多选题Which two statements are true regarding the SGA_TARGET initialization parameter（）AIt can be increased up to the value of the SGA_MAX_SIZE parameter.BIncreasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.CReducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.DIncreasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

查看答案

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

查看答案

考题单选题What is the implication of setting the initialization parameter FAST_START_MTTR_TARGET to 0 in your database？（）A MTTR Advisor would be disabled.B Redo Log Advisor would be disabled.C Automatic tuning of checkpoint would be disabled.D Checkpoint information would not be written to the alert log file.

查看答案

考题多选题You are configuring the PROD database to use an internal tuning algorithm to monitor the performance of the workload. To achieve this configuration， you specify the following parameter settings in the SPFILE:// SGA_TARGET = 512M SHARED_POOL_SIZE = 256M Which two statements are true when modifying the SHARED_POOL_SIZE initialization parameter in the SPFILE？（）AModifying the SHARED_POOL_SIZE initialization parameter cannot be accomplished if the SGA_TARGET initialization parameter is set to a non-zero value.BModifying the value of the SHARED_POOL_SIZE initialization parameter to zero is not allowed if the SGA_TARGET initialization parameter is set to a nonzero value.CIncreasing the value of the SHARED_POOL_SIZE initialization parameter does not increase the shared pool component size. It sets the lower limit for the size of this component.DDecreasing the value of the SHARED_POOL_SIZE initialization parameter does not reduce the size of the shared pool component immediately. It sets the lower limit for the size of this component.EIncreasing the value of the SHARED_POOL_SIZE initialization parameter immediately increases the shared pool component to the desired size by reallocating the additional memory from the auto-tuned memory components.FDecreasing the value of the SHARED_POOL_SIZE initialization parameter immediately shrinks the shared pool component to the desired size while reallocating the released memory to the memory components that are not auto-tuned.

查看答案

考题多选题Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）AThe foo initialization parameter CANNOT be set programmatically.BCompilation fails because getInitParameter returns type Object.CThe foo initialization parameter is NOT a servlet initialization parameter.DCompilation fails because ServletContext does NOT have a getInitParameter method.EThe foo parameter must be defined within the element of the deployment descriptor.

查看答案

考题单选题You have included the following parameter settings in your SPFILE:// SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）A The SGA_TARGET initialization parameter cannot be set to a value greater than 8GB The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2GC The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2GD The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M E The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M

查看答案

考题多选题Given： String value = getServletContext（）.getInitParameter（"foo"）； in an HttpServlet and a web applicationdeployment descriptor that contains： foo frodo Which two are true？（）AThe foo initialization parameter CANNOT be set programmatically.BCompilation fails because getInitParameter returns type Object.CThe foo initialization parameter is NOT a servlet initialization parameter.DCompilation fails because ServletContext does NOT have a getInitParameter method.EThe foo parameter must be defined within the element of the deployment descriptor.

查看答案

考题多选题Given: Which two statements are true about the result if the default locale is Locale.US?（）AThe value of b is 2.BThe value of a is 3.14.CThe value of b is 2.00.DThe value of a is 3.141.EThe value of a is 3.1415.FThe value of a is 3.1416.GThe value of b is 2.0000.

查看答案

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

查看答案

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

查看答案

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

查看答案

考题多选题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 maintaining an OLTP database in Oracle10g. You have configured the Flash Recovery Area in your database. The Flash Recovery Area is full because you have set the retention policy to NONE. What will you do to resolve the problem？（）A Increase the value of the FAST_START_MTTR_TARGET initialization parameter.B Increase the value of the DB_RECOVERY_FILE_DEST_SIZE parameter.C Increase the value of the PGA_AGGREGATE_TARGET initialization parameter.D Increase the value of the SGA_TARGET initialization parameter.

查看答案

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

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