多选题For which two situations would you use functionality provided by the Resource Manager？（）Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDas

第1题：

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

第2题：

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.

第3题：

For which two situations would you use functionality provided by the Resource Manager?（）

• A、setting idle timeout limits on resource plans
• B、saving storage space by using compressed backup sets
• C、creating jobs that will run automatically at a scheduled time
• D、assigning priorities to jobs to manage access to system resources
• E、creating alerts to perform notification when tablespaces are low on available space resources

第4题：

You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are  notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks.  Which two actions could you take to prevent this locking problem in the future（）

• A、Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
• B、Use Database Resource Manager to automatically log out sessions that block others and are idle.
• C、Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
• D、Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction

第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？ （）

• 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

第6题：

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

第7题：

You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?（）

• A、You are backing up to tape and your tape device performs its own compression.
• B、You are making image copies, and you have not enabled tablespace compression.
• C、You are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.
• D、You are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.
• E、You are using some archival backup media, such as CD or DVD, where reducing backup sizes saves  media costs and archival storage.

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this?（）

• A、Implement job classes
• B、Implement Scheduler windows
• C、Implement the mapping rule for the consumer groups
• D、Set the SWITCH_TIME resource plan directive for both the resource plans

第14题：

For which two situations would you use functionality provided by the Resource Manager? （）(Choose two.)

• A、setting idle timeout limits on resource plans
• B、saving storage space by using compressed backup sets
• C、creating jobs that will run automatically at a scheduled time
• D、assigning priorities to jobs to manage access to system resources
• E、creating alerts to perform notification when tablespaces are low on available space resources

第15题：

You work as a database administrator for Certkiller .com. You want to configure database backups to be run automatically.  Which tool or utility would you use to achieve this？ （）

• A、The DBMS_JOB package
• B、The BACKUP_JOB package
• C、The DBMS_BACKUP_RESTORE package
• D、The calendar tool in the Operating System （OS）
• E、The backup scheduler in Enterprise Manager （EM）
• F、The DBMS_BACKUP_SCHEDULER packager inline mode

第16题：

You create two resource plans, one for data warehouse loading jobs at night and the other for application jobs at day time. You want the resource plans to activate automatically so that the resource allocation is optimum as desired by the activity.How would you achieve this? （）

• A、Implement job classes 
• B、Implement Scheduler windows
• C、Implement the mapping rule for the consumer groups 
• D、Set the SWITCH_TIME resource plan directive for both the resource plans

第17题：

A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger，which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression？（）

• A、 backup database all
• B、 backup compressed database
• C、 backup as compressed backupset database
• D、 backup as compressed backup database plus archivelog all
• E、 backup as compressed backupset database plus compress archivelog all

第18题：

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.

第19题：

第20题：

第21题：

第22题：

第23题：

第24题：