1z0-043
单选题The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the
题目
The statement will deactivate DAY_PLAN.
The statement will activate DAY_PLAN as the top plan.
The statement will activate MANAGERS_PLAN as the top plan.
The statement will return an error because MANAGERS_PLAN is not the top plan.
相似问题和答案
第1题：
A. Setting a metric threshold
B. Implementing Database Resource Manager
C. Enabling resumable timeout for user sessions
D. Decreasing the value of the IDLE_TIME resource limit in the default profile
第2题：
The Database Resource Manager is not currently active in your database that is up and running. You created a resource plan named DAY_PLAN that contains two sub-plans named MANAGERS_PLAN and CLERKS_PLAN. You decided to activate DAY_PLAN by executing the following statement： SQL>ALTER SYSTEM SET RESOURCE_MANAGER_PLAN = ’managers_plan’； What will be the outcome of this statement？（）
- A、 The statement will deactivate DAY_PLAN.
- B、 The statement will activate DAY_PLAN as the top plan.
- C、 The statement will activate MANAGERS_PLAN as the top plan.
- D、 The statement will return an error because MANAGERS_PLAN is not the top plan.
正确答案:C
第3题：
View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）
A. The pending area is automatically submitted after the plan creation
B. The procedure must be executed before creating the resources plan directive
C. The SYS_GROUP resource consumer group is not included in the resource plan directive
D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive
第4题：
In your production database， you observe that users’ transactions are consuming a lot of resources and you plan to impose resource restrictions by using Resource Manager. For which three resources can you enable usage restrictions by using Resource Manager？（）
- A、CPU usage
- B、degree of parallelism
- C、number of open cursors
- D、number of sorts performed
- E、idle time for blocking sessions
- F、number of disk I/O operations performed
- G、number of memory I/O operations performed
正确答案:A,B,E
第5题：
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（）
- A、 Advisor Central
- B、 Global Attributes
- C、 Resource Monitors
- D、 Memory Parameters
- E、 Database Usage Statistics
- F、 All Initialization Parameters
- G、 Automatic Workload Repository
正确答案:A,C
第6题：
You recently activated a resource plan named OLTP_PLAN in your database. Several users are concurrently running long transactions. You decide to monitor the resource manager to determine if the resource allocation formulated in the OLTP_PLAN is sufficient for peak database hours. Which dynamic performance view should you use to display the CPU time consumed by all the sessions within the resource groups？（）
- A、 V$SYSSTAT
- B、 V$SESSSTAT
- C、 V$RSRC_PLAN
- D、 V$RSRC_CONSUMER_GROUP
正确答案:D
第7题：
Which of these represent the main components of Database Resource Manager？（）
- A、 Resource consumer groups
- B、 Resource plans
- C、 Resource-plan groups
- D、 Resource-plan directives
- E、 All of the above
正确答案:A,B,D
第8题：
A.RATIO
B.EMPHASIS
C.ACTIVE_SESS_POOL_MTH
D.RESOURCE_DEGREE_LIMIT_ABSOLUTE
第9题：
You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）
- A、 RATIO
- B、 EMPHASIS
- C、 ACTIVE_SESS_POOL_MTH
- D、 RESOURCE_DEGREE_LIMIT_ABSOLUTE
正确答案:B
第10题：
You need to recommend a document management solution that supports the company's planned changes. What should you include in the recommendation？（）
- A、Active Directory Rights Management Services（AD RMS）and File Server Resource Manager （FSRM）
- B、Active Directory Rights Management Services（AD RMS）and Microsoft SharePoint Foundation 2010
- C、Authorization Manager and Microsoft SharePoint Foundation 2010
- D、File Server Resource Manager （FSRM） and Share and Storage Management
正确答案:B