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

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


参考答案

参考解析
解析: 暂无解析
更多 “多选题In your production database, you have multiple resource plan directives that refer to the consumer group DB_GRP. Which two statements are correct?()AThe parallel degree limit for DB_GRP will be the minimum of all the incoming values.BThe parallel degree limit for DB_GRP will be the maximum of all the incoming values.CThe maximum estimated execution time for DB_GRP would be the most nonrestrictive of all incoming values.DIf 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.EIf 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.” 相关考题
考题 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 are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups.Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database

考题 A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database.  Which of the following statements best describes the need for custom resource monitor?()  A、 Multiple application servers must be in a single resource group.B、 Multiple application servers per resource group may be monitored.C、 Multiple resource groups must each contain a single application server.D、 Multiple application servers in a cluster cannot use process monitoring.

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

考题 Your production database is running in the ARCHIVELOG mode and the ARCn process is functional. You have two online redo log groups. Which three background processes would be involved when a log switch happens? ()A、archivalB、log writerC、database writerD、system monitorE、process monitorF、change tracking writer

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

考题 Using Oracle Scheduler you have scheduled two jobs, JOB_A and 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 windows 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?()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 work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()A、You must have started the database instance in restricted mode.B、You must have started the database instance inNORMALmode.C、You must have started the database instance with server parameter file.D、You must have started the database instance but must not have mounted.E、You must have started the database instance but must not have opened.

考题 You administer a SQL Server 2008 instance. You plan to deploy a new database to the instance. The database will be subject to frequent inserts and updates. The database will have multiple schemas. One of the schemas will contain a large amount of read-only reference data. You need to design the physical database structure for optimal backup performance. What should you do?() A、Create the database by using a single data file and a single log file.B、Create the database by using a single data file and multiple log files.C、Create the database by using a single log file and multiple filegroups.D、Create the database by using a single log file and a filegroup that has multiple data files.

考题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default trace is contained in the subdirectory.You have to backup the subdirectory.  Which SQL Server database engine subdirectory should be backed up?()A、DATAB、INSTALL C、LOG D、BINN

考题 单选题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 are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and youwant them to be included in backups.Identify two options for completing this task. ()(Choose two.)AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database

考题 单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.  How would you accomplish this task?()A  Set metric thresholdB  Implement Database Resource ManagerC  Enable resumable timeout for user sessionsD  Add directives to Automatic Database Diagnostic Monitor (ADDM)

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

考题 单选题You work as a database administrator for Supportcenter.cn. In your production database, the size of Database Buffer Cache needs to be increased immediately for the current as well as future instances of the database. The Oracle instance has been configured to accommodate any changes in the size of the memory structures. At this is production database, you want to accomplish this task with no impact on the user’s connections. Which activity must you have completed before accomplishing this task?()A You must have started the database instance in restricted mode.B You must have started the database instance inNORMALmode.C You must have started the database instance with server parameter file.D You must have started the database instance but must not have mounted.E You must have started the database instance but must not have opened.

考题 单选题A cluster administrator decides ti implement application monitoring in order to monitor both a web application and its supporting database. The plan is to use a single resource group prod_rg and to configure one monitor method for the web app and one monitor method for the database.  Which of the following statements best describes the need for custom resource monitor?()A  Multiple application servers must be in a single resource group.B  Multiple application servers per resource group may be monitored.C  Multiple resource groups must each contain a single application server.D  Multiple application servers in a cluster cannot use process monitoring.

考题 单选题Using Oracle Scheduler you have scheduled two jobs, JOB_A and 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 windows group must have been created with the WEEKEND_PLAN resource 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

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

考题 单选题You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?()A use the external table populationB use the Oracle Data Pump export and import utilityC use the conventional path data load of SQL*Loader utilityD use the direct path data load of Oracle export and import utility

考题 单选题You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?()A Set metric thresholdB Implement Database Resource ManagerC Enable resumable timeout for user sessionsD Add directives to Automatic Database Diagnostic Monitor (ADDM)

考题 单选题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 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? ()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

考题 单选题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?()A The Resource Manager plan does not affect the user.B There must be a plan directive in any of the plans of the group to control the resources.C The members of the group DEFAULT_CONSUMER_GROUP always have resource restrictions.D The members of DEFAULT_CONSUMER_GROUP are restrained from accessing the system tables.E The members of this group can change their group without the database administrator’s intervention.

考题 多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database