-
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
A . Use the Database Resource Manager.
B . Set the limits in the profiles used by users.
C . Modify the SESSIONS initialization parameter.
D . Set the warning threshold for the Current Logons Count metric.
-
The Database Resource Manager is automatically enabled in the maintenance window that runs the Automated Maintenance Task. What is the reason for this?()
A . to prevent the creation of an excessive number of scheduler job classes
B . to allow the Automated Maintenance Tasks to use system resources without any restriction
C . to allow resource sharing only among the Automated Maintenance Tasks in the maintenance window
D . to prevent the Automated Maintenance Tasks from consuming excessive amounts of system resource
-
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 directive
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()
A . This operation resets the SCN for the database.
B . This operation creates a new incarnation of the database.
C . This operation moves all the redo log files to a different location.
D . This operation deletes the old redo log files and creates new redo log files.
E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option? ()
A . This operation resets the SCN for the database.
B . This operation creates a new incarnation of the database.
C . This operation moves all the redo log files to a different location.
D . This operation deletes the old redo log files and creates new redo log files.
E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
-
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
-
You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()
A . renaming the control files
B . dropping a user in your database
C . enabling or disabling redo log archiving
D . dropping a tablespace in your database
E . re-creating the control files, after you lost all the control files in your database
-
After performing a clean shut down of the database instance for maintenance, you mount the database andthen execute a command to open the database:SQL> ALTER DATABASE OPEN; Which two statements are true()
A . The online redo log files and online data files are opened.
B . All the online data file headers are checked for consistency.
C . Instance recovery is performed before opening the database.
D . The path and existence of all the log file members are checked
-
In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct?()
A . The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B . The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C . The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D . If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.
E . If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
-
A web application is bound to the context named "/webapp" and the client uses the browser and makes a request to the resource http://server:port/webapp/ctxl/resource. Where do you place this resource inside the web application structure?()
A . in the subdirectory /WEB-INF/ctxl
B . in the subdirectory /META-INF/ctxl
C . in the subdirectory /ctxl in the root of the archive
D . in the subdirectory /ctxl/resource in the root of the archive
E . in the root of the archive
-
View the Exhibit and examine the resource consumption details for the current plan in use by the database instance.Which two statements are true based on the output?()https://assets.asklib.com/images/image2/2018080214062464323.png
A . An attempt to start a new session by the user belonging to DSS_QUERIES fails with an error
B . A user belonging to DSS_QUERIES can log in to a new session but the session will be queued
C . The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management .
D . The CPU_WAIT_TIME column indicates the total time that sessions in the consumer group waited for the CPU due to resource management, I/O waits, and latch or enqueue contentio
-
You are defining areas on your Oracle database. Which of the following profile areas can be used to control the resource usage for the other four?()
A . LOGICAL_READS_PER_SESSION
B . CONNECT_TIME
C . COMPOSITE_LIMIT
D . CPU_PER_SESSION
E . PRIVATE_SGA
-
The resource group configuration for a four node cluster is shown below:Which resource groups will be acquired by node N2 if it joins the cluster first?()
A . rgC、rgE
B . rgC、rgD
C . rgE、rgB、rgD
D . rgC、rgD、rgE
-
In your production database, you have multiple resource plan directives that refer to the customer group DB_GRP. Which two statements are correct? ()
A . The parallel degree limit for DB_GRP will be the minimum of all the incoming values.
B . The parallel degree limit for DB_GRP will be the maximum of all the incoming values.
C . The maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.
D . If a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would not execute if the active session pool for the new consumer group was full.
E . Is a session switched from the DB_GRP consumer group to another consumer group because it exceeded the prescribed switch time, then that session would execute even if the active session pool for the new consumer group was full.
-
The process of()schedule activity durations uses information on schedule activity scope of work, required resource types, estimated resource quantities, and resource calendars with resource availabilities.
A . estimating
B . defining
C . planning
D . sequencing
-
Which two statements are true concerning the Resource Manager plans for individual pluggabledatabases (PDB plans) in a multitenant container database (CDB)?()
A . If no PDB plan is enabled for a pluggable database, then all sessions for that PDB are treated to an equal degree of the resource share of that pdb.
B . In a PDB plan, subplans may be used with up to eight consumer groups.
C . If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups across all PDBs in the cdb.
D . If no PDB plan is enabled for a pluggable database, then the PDB share in the CDB plan is dynamically calculated.
E . If a PDB plan is enabled for a pluggable database, then resources are allocated to consumer groups based on the shares provided to the PDB in the CDB plan and the shares provided to the consumer groups in the PDB plan.
-
You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group?()
A . CPU_MTH
B . NEW_CPU_MTH
C . CPU_P1
D . CPU_P2
-
The process of()schedule activity durations uses information on schedule activityscope of work, required resource types, estimated resource quantities, and resource calendarswith resource availabilities.
A . estimating
B . defining
C . planning
D . sequencing
-
You want to monitor and control the resource usage by sessions. You want to be warned automatically when more than 100 sessions are opened with your database. What action would you take to achieve this?()
A . Use the Database Resource Manager.
B . Set the limits in the profiles used by users.
C . Modify the SESSIONS initialization parameter.
D . Set the warning threshold for the Current Logons Count metric.
-
You are using Oracle Database 10g. You performed an incomplete recovery of your database and opened the database with the RESETLOGS option. What is the effect of opening the database with the RESETLOGS option?()
A . This operation resets the SCN for the database.
B . This operation creates a new incarnation of the database.
C . This operation moves all the redo log files to a different location.
D . This operation deletes the old redo log files and creates new redo log files.
E . This operation updates all current datafiles and online redo logs and all subsequent archived redo logs with a new RESETLOGS SCN and time stamp.
-
Which three resources might be prioritized between competing pluggable databases when creating amultitenant container database plan (CDB plan) using Oracle Database Resource Manager?()
A . Maximum Undo per consumer group
B . Maximum Idle time
C . Parallel server limit
D . CPU
E . Exadata I/O
F . Local file system I/O
-
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
-
Automatic Consumer Group Switching is an important new feature of the Database Resource Manager. Which three plan directive parameters are used to control this feature?()
A . SWITCH_TIME
B . SWITCH_GROUP
C . MAX_SESS_POOL
D . SWITCH_ESTIMATE
-
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?()
<img src='https://img2.soutiyun.com/shangxueba/ask/17133001-17136000/17135247/2c9611256b04bdd5ba39c52e4e7dd450.png' />
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