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?()
第1题:
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?()
第2题:
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?()
第3题:
You execute the following block of code: SQL>BEGIN 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?()
第4题:
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?()
第5题:
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? ()
第6题:
Which statement is true while creating subplans using Resource Manager?()
第7题:
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? ()
第8题:
assign users to consumer groups
set the resource plan for the instance
configure a simple resource plan and specify plan directives
configure a complex resource plan and specify plan directives
第9题:
The Resource Manager plan does not affect the user.
There must be a plan directive in any of the plans of the group to control the resources.
The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.
The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.
The members of this group can change their group without the database administrator’s intervention.
第10题:
RATIO
EMPHASIS
ACTIVE_SESS_POOL_MTH
RESOURCE_DEGREE_LIMIT_ABSOLUTE
第11题:
V$SYSSTAT
V$SESSSTAT
V$RSRC_PLAN
V$RSRC_CONSUMER_GROUP
第12题:
CPU usage
degree of parallelism
number of open cursors
number of sorts performed
idle time for blocking sessions
number of disk I/O operations performed
number of memory I/O operations performed
第13题:
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)
第14题:
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: SQL>EXEC 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?()
第15题:
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: SQL>EXEC 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?()
第16题:
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?()
第17题:
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?()
第18题:
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?()
第19题:
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.
第20题:
The user must have been granted the DBA role.
The user must have been granted the switch privilege as a part of a role.
The user must have been granted the Resource Manager administrator privilege.
The user must have been granted the switch privilege by using the DBMS_RESOURCE_MANAGER_PRIVS package.
第21题:
The subplan must belong to the consumer group, SYS_GROUP.
The total CPU usage at any given level must be less than 100%.
The subplans can be used to restrict the degree of parallelism for a user.
You can use a resource plan instead of a consumer group to implement a priority ranking within the plan.
第22题:
The batch operation started by the user, SCOTT, terminates with an error.
The batch operation started by the user, SCOTT, hangs and you are required to increase the undo pool resource plan directive.
The batch operation started by the user, SCOTT, runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
The user, BLAKE, cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
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.
第23题:
A window must have been created with the WEEKEND_PLAN resource plan.
A program must have been created with the WEEKEND_PLAN resource plan.
A job class must have been created with the WEEKEND_PLAN resource plan.
A window group must have been created with the WEEKEND_PLAN resource plan.