网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
多选题
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


参考答案

参考解析
解析: 暂无解析
更多 “多选题For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources” 相关考题
考题 For which two situations would you use functionality provided by the Resource Manager?() A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to jobs to manage access to system resourcesE. creating alerts to perform notification when tablespaces are low on available space resources

考题 For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.) A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning priorities to jobs to manage access to system resourcesE. creating alerts to perform notification when tablespaces are low on available space resources

考题 You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? ()(Choose two.) A. issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB. issuing the ALTER SESSION ENABLE RESUMABLE; statementC. modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD. issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

考题 In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time.How would you accomplish this?() A. Setting a metric thresholdB. Implementing Database Resource ManagerC. Enabling resumable timeout for user sessionsD. Decreasing the value of the IDLE_TIME resource limit in the default profile

考题 In which two situations should you run the command sync group?() (Choose two.)A、when you enable Unified FailoverB、when you create an ActiveN groupC、when you synchronize the sticky tableD、when you require synchronization of the 3G Cache objects

考题 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_MTHB、 NEW_CPU_MTHC、 CPU_P1D、 CPU_P2

考题 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 classesB、Implement Scheduler windowsC、Implement the mapping rule for the consumer groupsD、Set the SWITCH_TIME resource plan directive for both the resource plans

考题 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.

考题 For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)A、setting idle timeout limits on resource plansB、saving storage space by using compressed backup setsC、creating jobs that will run automatically at a scheduled timeD、assigning priorities to jobs to manage access to system resourcesE、creating alerts to perform notification when tablespaces are low on available space resources

考题 For which two situations would you use functionality provided by the Resource Manager?()A、setting idle timeout limits on resource plansB、saving storage space by using compressed backup setsC、creating jobs that will run automatically at a scheduled timeD、assigning priorities to jobs to manage access to system resourcesE、creating alerts to perform notification when tablespaces are low on available space resources

考题 You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? ()(Choose two.)A、issuing the ALTER SYSTEM ENABLE RESUMABLE; statementB、issuing the ALTER SESSION ENABLE RESUMABLE; statementC、modifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueD、issuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

考题 You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? ()(Choose two.)A、Backup compression should be enabledB、Parallelism for the channel should be set to 2C、All the files must be backed up as backup setsD、The backup may be stored either on disk or on media with media manager

考题 You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)A、To store the backup information of multiple databaseB、To restrict the amount of space that is used by the backupsC、To maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.D、To list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

考题 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 windowsC、Implement the mapping rule for the consumer groups D、Set the SWITCH_TIME resource plan directive for both the resource plans

考题 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

考题 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

考题 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 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.

考题 多选题In which two situations should you run the command sync group?() (Choose two.)Awhen you enable Unified FailoverBwhen you create an ActiveN groupCwhen you synchronize the sticky tableDwhen you require synchronization of the 3G Cache objects

考题 多选题You are using Recovery Manager (RMAN) to perform backups. In which three situations would you perform a compressed backup?()AYou are backing up to tape and your tape device performs its own compression.BYou are making image copies, and you have not enabled tablespace compression.CYou are using disk-based backups and disk space in your Flash Recovery Area, or other disk-based backup destinations are limited.DYou are performing your backups to some device over a network where reduced network bandwidth is more important than CPU usage.EYou are using some archival backup media, such as CD or DVD, where reducing backup sizes saves media costs and archival storage.

考题 多选题For which two situations would you use functionality provided by the Resource Manager? ()(Choose two.)Asetting idle timeout limits on resource plansBsaving storage space by using compressed backup setsCcreating jobs that will run automatically at a scheduled timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources

考题 多选题Which three statements are true about windows? ()(Choose three.)AOnly one window can be open at any given timeBConsumer groups are associated with windowsCWindows work with job classes to control resource allocationDThe database service name must be provided during windows creationEWindows can automatically start job or change resource allocation among jobs for various time periods.

考题 单选题In your database, you want to ensure that idle sessions that are blocking active are automatically terminated after a specified period of time. How would you accomplish this?()A Setting a metric thresholdB Implementing Database Resource ManagerC Enabling resumable timeout for user sessionsD Decreasing the value of the IDLE_TIME resource limit in the default profile

考题 多选题You are using the control file to maintain information about the database backups that are being performed by Recovery Manager (RMAN).Identify two scenarios is which you must have a recovery catalog. ()(Choose two.)ATo store the backup information of multiple databaseBTo restrict the amount of space that is used by the backupsCTo maintain a backup for a certain time is set by the CONTROL_FILE_RECORD_KEEP_TIME parameter.DTo list the data files that were in a target database at a given time by using the AT option of REPORT SCHEMA command.

考题 多选题You want to enable resumable space allocation at the instance level.Which two actions would enable resumable space allocation at the instance level? ()(Choose two.)Aissuing the ALTER SYSTEM ENABLE RESUMABLE; statementBissuing the ALTER SESSION ENABLE RESUMABLE; statementCmodifying the RESUMABLE_TIMEOUT initialization parameter to a nonzero valueDissuing the ALTER SYSTEM SET RESUMABLE_TIMEOUT=; statement

考题 多选题You want to take a complete database backup using RMAN. The backup should consist only the used blocks from your database. Which two statements are true about this backup operation? ()(Choose two.)ABackup compression should be enabledBParallelism for the channel should be set to 2CAll the files must be backed up as backup setsDThe backup may be stored either on disk or on media with media manager

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

考题 多选题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 timeDassigning priorities to jobs to manage access to system resourcesEcreating alerts to perform notification when tablespaces are low on available space resources