You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan?()A、assign users to consumer groupsB、set the resource plan for the instanceC、configure a simple resource plan and specify plan directivesD、configure a complex resource plan and specify plan directives

You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users.   Which step must be performed before you can start using the resource plan?()

  • A、assign users to consumer groups
  • B、set the resource plan for the instance
  • C、configure a simple resource plan and specify plan directives
  • D、configure a complex resource plan and specify plan directives

相关考题:

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN).Which two are the prerequisites to perform this operation?() A. You must configure block change tracking fileB. You must have first level 1 backups for RMAN to restore blocksC. You must ensure that the SALES database is mounted or openD. You must have full or level 0 backups for RMAN to restore blocksE. You must take the tools01.dbf data file offline before you start a block media recovery

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 creationB. The procedure must be executed before creating the resources plan directiveC. The SYS_GROUP resource consumer group is not included in the resource plan directiveD. The OTHER_GROUPS resources consumer group is not included in the resource plan directive

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$SYSSTATB、 V$SESSSTATC、 V$RSRC_PLAND、 V$RSRC_CONSUMER_GROUP

Using Oracle Scheduler you have scheduled two jobs, JOB_Aand JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()A、 A window must have been created with the WEEKEND_PLAN resource plan.B、 A program must have been created with the WEEKEND_PLAN resource plan.C、 A job class must have been created with the WEEKEND_PLAN resource plan.D、 A window group must have been created with the WEEKEND_PLAN resource plan.

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:       SQLALTER 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.

You need to perform a block media recovery on the tools01.dbf data file in the SALES database by using Recovery Manager (RMAN). Which two are the prerequisites to perform this operation? ()(Choose two)A、You must configure block change tracking fileB、You must have first level 1 backups for RMAN to restore blocksC、You must ensure that the SALES database is mounted or openD、You must have full or level 0 backups for RMAN to restore blocksE、You must take the tools01.dbf data file offline before you start a block media recovery

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

You are using the Database Resource Manager to manage database resources. You created a resource plan directive for the MANAGERS resource consumer group under the SALES_PLAN by using the following statement:   SQLEXEC DBMS_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);   A user, SCOTT, who is assigned to the MANAGERS group, starts a database session and executes a query on the database. What is the outcome if the query takes approximately 15 minutes to complete?()  A、 The query starts under the CLERKS group and the user, SCOTT, switches back to the MANAGERS group after the query completes.B、 The query starts under the MANAGERS group but terminates with an error when the execution time exceeds 10 minutes.C、 The query starts under the MANAGERS group and switches automatically to the CLERKS group when the execution time exceeds 10 minutes. The query does not switch back to the MANAGERS group after the query completes.D、 The query starts under the MANAGERS group, the user SCOTT switches automatically to the CLERKS group when the execution time exceeds 10 minutes, and then switches back to the MANAGERS group after the query completes.

You execute the following block of code:   SQLBEGIN   DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN   ( SIMPLE_PLAN = ’DEPARTMENTS’,   CONSUMER_GROUP1 = ’PAYROLLL’,   GROUP1_CPU = 50,   CONSUMER_GROUP2 = ’SALES’,   GROUP2_CPU = 25,   CONSUMER_GROUP3 = ’MARKETING’,   GROUP3_CPU = 25);   END;   SQL/   What is a prerequisite for using the simple resource plan created by executing the above code?()A、 You must assign users to consumer groups.B、 You must grant the switch privilege to the users.C、 You must create a resource plan directive.D、 You must specify the complex resource plan.

You updated the resource plan directive for the resource consumer group, DSS_USERS. The resource plan directive is assigned to the DSS_PLAN by using the following statement:   SQLEXEC DBMS_RESOURCE_MANAGER.UPDATE_PLAN_DIRECTIVE  (PLAN = ’DSS_PLAN’,   GROUP_OR_SUBPLAN = ’DSS_USERS’,   NEW_CPU_P1 = 80,   NEW_SWITCH_GROUP = ’CANCEL_SQL’,   NEW_SWITCH_ESTIMATE = TRUE,   NEW_SWITCH_TIME = 600); A user connects to the database and starts an operation. What is the outcome if Oracle estimates that the execution time for this operation will exceed 600 seconds?()  A、 The session is killed before starting the operation.B、 The session generates an error before starting the operation.C、 The session switches to the CANCEL_SQL resource consumer group before starting the operation.D、 The session hangs before starting the operation.

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、 RATIOB、 EMPHASISC、 ACTIVE_SESS_POOL_MTHD、 RESOURCE_DEGREE_LIMIT_ABSOLUTE

Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()A、 The user must have been granted the DBA role.B、 The user must have been granted the switch privilege as a part of a role.C、 The user must have been granted the Resource Manager administrator privilege.D、 The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

You work as a database administrator at Certkiller .com. In your production database, you observe that users’ transactions are consuming a lot of resource 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 usageB、 degree of parallelismC、 number of open cursorsD、 number of sorts performedE、 idle time for blocking sessionsF、 number of disk I/O operations performedG、 number of memory I/O operations performed

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 set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users, SCOTT and BLAKE, belong to the DSS_USERS resource group. The user, SCOTT, initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive?()A、 The batch operation started by the user, SCOTT, terminates with an error.B、 The batch operation started by the user, SCOTT, hangs and you are required to increase the undo pool resource plan directive.C、 The batch operation started by the user, SCOTT, runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.D、 The user, BLAKE, cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user, SCOTT, terminates with an error.

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 usageB、degree of parallelismC、number of open cursorsD、number of sorts performedE、idle time for blocking sessionsF、number of disk I/O operations performedG、number of memory I/O operations performed

单选题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:       SQLALTER 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.

单选题You have created a resource plan, DB_PLAN, using DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN and you want to impose a restriction on utilization of resources by the database users. Which step must be performed before you can start using the resource plan?()A assign users to consumer groupsB set the resource plan for the instanceC configure a simple resource plan and specify plan directivesD configure a complex resource plan and specify plan directives

单选题Manually, you set the consumer group of all of the newly created users to MYDB_GRP. You want the users to be able to change their consumer groups as per the application requirement. What was the first step that was needed in the process to achieve this objective?()AThe user must have been granted the DBA role.BThe user must have been granted the switch privilege as a part of a role.CThe user must have been granted the Resource Manager administrator privilege.DThe user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.

单选题You are using Resource Manager to manage system resources. While creating a new database user, you observe that the user is a member of DEFAULT_CONSUMER_GROUP by default. What would be the implications of this?()AThe Resource Manager plan does not affect the user.BThere must be a plan directive in any of the plans of the group to control the resources.CThe members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.DThe members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.EThe members of this group can change their group without the database administrator’s intervention.

单选题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 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 RATIOB EMPHASISC ACTIVE_SESS_POOL_MTHD RESOURCE_DEGREE_LIMIT_ABSOLUTE

多选题You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users, SCOTT and BLAKE, belong to the DSS_USERS resource group. The user, SCOTT, initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive?()AThe batch operation started by the user, SCOTT, terminates with an error.BThe batch operation started by the user, SCOTT, hangs and you are required to increase the undo pool resource plan directive.CThe batch operation started by the user, SCOTT, runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.DThe user, BLAKE, cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.EThe user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user, SCOTT, terminates with an error.

单选题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$SYSSTATB V$SESSSTATC V$RSRC_PLAND V$RSRC_CONSUMER_GROUP

单选题Using Oracle Scheduler you have scheduled two jobs, JOB_Aand JOB_B, to run at 9:00 p.m. every Friday. You want both the jobs to use a single resource plan, WEEKEND_PLAN. Which task must have already been performed to enable you to achieve this objective?()A A window must have been created with the WEEKEND_PLAN resource plan.B A program must have been created with the WEEKEND_PLAN resource plan.C A job class must have been created with the WEEKEND_PLAN resource plan.D A window group must have been created with the WEEKEND_PLAN resource plan.

多选题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?()ACPU usageBdegree of parallelismCnumber of open cursorsDnumber of sorts performedEidle time for blocking sessionsFnumber of disk I/O operations performedGnumber of memory I/O operations performed