单选题Within a resource-plan definition, what differentiates a top-level plan from a subplan?（）A A subplan has the PLAN_SUB parameter value set to SUBB A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC There is no difference in the resource-plan definitionD A subplan always has the CPU_MTH parameter value set to RATIOE The string TOP_LEVEL is appended to the name of top-level resource plans

考题 Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.)You restart the instance.To what value will the MEMORY_MAX_TARGET parameter be set by default?() A.120MB.320MC.480MD.600M

查看答案

考题 Youhavecreatedaresourceplan，DAY.Youexecutethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEPARTMENTS’，CPU_P1=0）；END；Then，youissuethefollowingcode：SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE（PLAN=’DAY’，COMMENT=’DEPARTMENTSPLAN’，GROUP_OR_SUBPLAN=’DEVELOPERS’，CPU_P2=100）；END；Whatwillbetheimpactofexecutingtheabovecode？（）

查看答案

考题 YouareusingtheDatabaseResourceManagertomanagedatabaseresources.YoucreatedaresourceplandirectivefortheMANAGERSresourceconsumergroupundertheSALES_PLANbyusingthefollowingstatement：SQLEXECDBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE（PLAN=’SALES_PLAN’，GROUP_OR_SUBPLAN=’MANAGERS’，CPU_P1=100，CPU_P2=0，SWITCH_GROUP=’CLERKS’，SWITCH_TIME_IN_CALL=600）；Auser，SCOTT，whoisassignedtotheMANAGERSgroup，startsadatabasesessionandexecutesaqueryonthedatabase.Whatistheoutcomeifthequerytakesapproximately15minutestocomplete？（）

查看答案

考题 Within a resource－plan definition, what differentiates a top－level plan from a subplan?() A. A subplan has the PLAN_SUB parameter value set to SUBB. A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC. There is no difference in the resource-plan definitionD. A subplan always has the CPU_MTH parameter value set to RATIOE. The string TOP_LEVEL is appended to the name of top-level resource plans

查看答案

考题 You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A、 The EVENT parameter was not setB、 The SQL_TRACE parameter is set to FALSEC、 The Enterprise Manager Grid Control is not usedD、 The STATISTICS_LEVEL parameter is set to BASICE、 The TIMED_STATISTICS parameter is set to FALSE

查看答案

考题 A customer has just purchased an 8-core POWER 570 which has two dual port 1 Gbps Integrated Virtual Ethernet （IVE） adapters. The customer wants to implement queue pairs （QPs） to take advantage of parallel processing of network traffic to its client logical partitions. Assuming that the system is to utilize the IVEs in both CECs， which configuration will allow a logical partition to utilize the entire eight cores for network traffic processing？（）A、 Set Multiple Core Scaling （MCS） value of the port group to 8 and set multiple core parameter of the client Ethernet adapters to yes.B、 Set Multiple Core Scaling （MCS） value of the port group to 4 and set multiple core parameter of the client Ethernet adapters to yes.C、 Set Multiple Core Scaling （MCS） value of one of the physical port groups to 4 and set multiple core parameter of the client Ethernet adapters to yes.D、 Set Multiple Core Scaling （MCS） value of one of the physical port groups to 8 and set the multiple core parameter of the client Ethernet adapters to yes.

查看答案

考题 Which of these represent the main components of Database Resource Manager？（）A、 Resource consumer groupsB、 Resource plansC、 Resource-plan groupsD、 Resource-plan directivesE、 All of the above

查看答案

考题 Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A、 Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B、 Capture the plans from the previous version using STS and then load them into the stored outline.C、 Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D、 Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

查看答案

考题 You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A、The EVENT parameter was not set.B、The SQL_TRACE parameter is set to FALSEC、The Enterprise Manager Grid Control is not used.D、The STATISTICS_LEVEL parameter is set to BASICE、The TIMED_STATISTICS parameter is set to FALSE

查看答案

考题 Within a resource-plan definition, what differentiates a top-level plan from a subplan?（）A、A subplan has the PLAN_SUB parameter value set to SUBB、A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC、There is no difference in the resource-plan definitionD、A subplan always has the CPU_MTH parameter value set to RATIOE、The string TOP_LEVEL is appended to the name of top-level resource plans

查看答案

考题 You work as a database administrator for Certkiller .com. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A、The advisory memory has been turned off.B、The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C、The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D、The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E、The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

查看答案

考题 You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（） A、 45.5B、 65C、 70D、 100

查看答案

考题 In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A、The STATISTICS_LEVEL initialization parameter is set to BASICB、The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C、The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD、The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE、The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

查看答案

考题 You have created a resource plan， DAY. You execute the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEPARTMENTS’， CPU_P1=0）； END； Then， you issue the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEVELOPERS’， CPU_P2=100）； END； What will be the impact of executing the above code？（） A、 The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.B、 The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.C、 The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.D、 The second code will not execute because one resource plan cannot be used by more than one subplan.

查看答案

考题 Which statement is true while creating subplans using Resource Manager？（）A、 The subplan must belong to the consumer group， SYS_GROUP.B、 The total CPU usage at any given level must be less than 100%.C、 The subplans can be used to restrict the degree of parallelism for a user.D、 You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

查看答案

考题单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A The EVENT parameter was not set.B The SQL_TRACE parameter is set to FALSEC The Enterprise Manager Grid Control is not used.D The STATISTICS_LEVEL parameter is set to BASICE The TIMED_STATISTICS parameter is set to FALSE

查看答案

考题单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70% respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， but no alerts have been generated. What could be the reason for this？（）A The EVENT parameter was not setB The SQL_TRACE parameter is set to FALSEC The Enterprise Manager Grid Control is not usedD The STATISTICS_LEVEL parameter is set to BASICE The TIMED_STATISTICS parameter is set to FALSE

查看答案

考题单选题Examine the exhibit to view the parameters set in your parameter file. (Click the Exhibit(s) button.) You restart the instance. To what value will the MEMORY_MAX_TARGET parameter be set by default?（）A 120MB 320MC 480MD 600M

查看答案

考题单选题You have created a resource plan， DAY. You execute the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEPARTMENTS’， CPU_P1=0）； END； Then， you issue the following code： SQL BEGIN DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE （ PLAN = ’DAY’， COMMENT = ’DEPARTMENTS PLAN’， GROUP_OR_SUBPLAN = ’DEVELOPERS’， CPU_P2=100）； END； What will be the impact of executing the above code？（）A The DEVELOPERS and DEPARTMENTS subplans will be allocated CPU equally.B The DEVELOPERS subplan will be allocated 100 percent CPU if there are no resources allocated to the DEPARTMENTS subplan.C The DEPARTMENT subplan will be allocated 100 percent CPU if there are no resources allocated to the DEVELOPERS subplan.D The second code will not execute because one resource plan cannot be used by more than one subplan.

查看答案

考题单选题You work as a database administrator for Supportcenter.cn. Users complain that their query is taking a long time to complete. You suspect the database buffer cache size to be the reason， and you define an alert to be generated when the buffer cache hit metric goes below 85%. When you observe the dynamic performance views， you find that the buffer cache hit ratio is 81% but no alerts are being generated. What could be the reason for this problem？（）A The advisory memory has been turned off.B The DB_CACHE_ADVICE parameter has been set to OFF in the parameter file.C The STATISTICS_LEVEL parameter has been set to BASIC in the parameter file.D The TIMED_STATISTICS parameter has been set to FALSE in the parameter file.E The STATISTICS_LEVEL parameter has been set to TYPICAL in the parameter file.

查看答案

考题单选题Which statement is true while creating subplans using Resource Manager？（）A The subplan must belong to the consumer group， SYS_GROUP.B The total CPU usage at any given level must be less than 100%.C The subplans can be used to restrict the degree of parallelism for a user.D You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.

查看答案

考题单选题Within a resource-plan definition， what differentiates a top-level plan from a subplan？（）A A subplan has the PLAN_SUB parameter value set to SUBB A top-level plan has the GROUP_OR_PLAN parameter set to the name of the subplan in the resource-plan definitionC There is no difference in the resource-plan definitionD A subplan always has the CPU_MTH parameter value set to RATIOE The string TOP_LEVEL is appended to the name of top-level resource plans

查看答案

考题单选题You want to enable automatic PGA memory management in your database. Which setting is required to achieve this？（）A Set MEMORY_TARGET to zeroB Set the STATISTICS_LEVEL parameter to BASICC Set the WORKAREA_SIZE_POLICY parameter to MANUALD Set the PGA_AGGREGATE_TARGET parameter to nonzero value

查看答案

考题单选题In your running instance， some of the initialization parameters are set as shown below： SGA_MAX_SIZE = 14GB DB_CACHE_SIZE = 1GB SHARED_POOL_SIZE = 3GB STATISTICS_LEVEL = BASIC PGA_AGGREGATE_TARGET = 0 You plan to enable Automatic Shared Memory Management but you are not able to set SGA_TARGET to a nonzero value. What could be the reason？（）A The STATISTICS_LEVEL initialization parameter is set to BASICB The PGA_AGGREGATE_TARGET initialization parameter is set to zero.C The SGA_MAX_SIZE initialization parameter is set to less than 20 GBD The DB_CACHE_SIZE initialization parameter is set to less than 5 GBE The SHARED_POOL_SIZE initialization parameter is set to a nonzero value.

查看答案

考题单选题You recently created a complex resource plan named DB_PLAN that has two subplans named OLTP_PLAN and DSS_PLAN. The OLTP_PLAN and DSS_PLAN subplans are allotted 70 percent and 30 percent of the total CPU resources， respectively. The OLTP_PLAN subplan allocates 35 percent of the available CPU resources to a resource consumer group named ACCT_CLERKS. According to the OLTP_PLAN subplan， the remaining 65 percent of the available CPU resources is allocated to a second resource consumer group named MKT_CLERKS. The CPU resources available to the DSS_PLAN subplan are divided into two resource consumer groups named MKT_MANAGERS and FIN_MANAGERS. The MKT_MANAGERS group receives 65 percent of the available CPU resources， and the FIN_MANAGERS group receives 35 percent of the available CPU resources. What percentage of actual CPU resources will the resource consumer group， MKT_CLERKS， receive， if the DSS_PLAN subplan does NOT consume any CPU resources？（）A 45.5B 65C 70D 100

查看答案

考题单选题Your system has been upgraded from Oracle Database 10g to Oracle Database 11g. You imported SQL Tuning Sets （STS） from the previous version. After changing the OPTIMIZER_FEATURE_ENABLE parameter to 10.2.0.4 and running the SQL Performance Analyzer， you observed performance regression for a few SQL statements. What would you do with these SQL statements？（）A Set OPTIMIZER_USE_PLAN_BASELINES to FALSE to prevent the use of regressed plans.B Capture the plans from the previous version using STS and then load them into the stored outline.C Capture the plans from the previous version using STS and then load them into SQL Management Base （SMB）D Set OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES to FALSE to prevent the plans from being loaded to the SQL plan baseline.

查看答案

考题单选题A customer has just purchased an 8-core POWER 570 which has two dual port 1 Gbps Integrated Virtual Ethernet （IVE） adapters. The customer wants to implement queue pairs （QPs） to take advantage of parallel processing of network traffic to its client logical partitions. Assuming that the system is to utilize the IVEs in both CECs， which configuration will allow a logical partition to utilize the entire eight cores for network traffic processing？（）A Set Multiple Core Scaling （MCS） value of the port group to 8 and set multiple core parameter of the client Ethernet adapters to yes.B Set Multiple Core Scaling （MCS） value of the port group to 4 and set multiple core parameter of the client Ethernet adapters to yes.C Set Multiple Core Scaling （MCS） value of one of the physical port groups to 4 and set multiple core parameter of the client Ethernet adapters to yes.D Set Multiple Core Scaling （MCS） value of one of the physical port groups to 8 and set the multiple core parameter of the client Ethernet adapters to yes.

查看答案

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

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