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

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


参考答案

参考解析
解析: 暂无解析
更多 “单选题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.” 相关考题
考题 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

考题 YouarecreatingthesimpleresourceplanusingtheDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLANprocedure.Whichresourceallocationpolicywillbeusedfortheresourceplan?() A.RATIOB.EMPHASISC.ACTIVE_SESS_POOL_MTHD.RESOURCE_DEGREE_LIMIT_ABSOLUTE

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

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

考题 Which of these represent the main components of Database Resource Manager?()A、 Resource consumer groupsB、 Resource plansC、 Resource-plan groupsD、 Resource-plan directivesE、 All of the above

考题 You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area (SGA) are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.  Which two links should you click to go to the Memory Advisor page?() A、 Advisor CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository

考题 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、 RATIOB、 EMPHASISC、 ACTIVE_SESS_POOL_MTHD、 RESOURCE_DEGREE_LIMIT_ABSOLUTE

考题 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 need to recommend a document management solution that supports the company's planned changes.   What should you include in the recommendation?()A、Active Directory Rights Management Services(AD RMS)and File Server Resource Manager (FSRM)B、Active Directory Rights Management Services(AD RMS)and Microsoft SharePoint Foundation 2010C、Authorization Manager and Microsoft SharePoint Foundation 2010D、File Server Resource Manager (FSRM) and Share and Storage Management

考题 You need to recommend a file recovery solution that meets the company's technical requirements. What should you include in the recommendation?()A、Distributed File System (DFS) ReplicationB、File Server Resource Manager (FSRM) active file screensC、shadow copiesD、Windows Storage Server 2008

考题 You need to recommend a monitoring solution for the file servers in the main office. The solution must meet the company’s technical requirements.    What should you include in the recommendation?()A、File Server Resource Manager (FSRM) active file screensB、File Server Resource Manager (FSRM) passive file screensC、Performance Monitor alertsD、Performance Monitor logs

考题 You work as a network Exchange administrator at Company.com.The Company.com network currently consists of a single Active Directory forest containing a single domain named Company.com.The Company.com organization makes use of Microsoft Exchange Server 2010 as their messaging solution.During the course of the business week you receive instruction from Company.com to ensure that the network users are able to open a resource mailbox. What should you do?()A、You should consider having a new Sharing policy crated from the Exchange Management Console (EMC).B、You should consider having the Resource Delegated parameter set for the resource mailbox from the Exchange Management Shell.C、You should consider having the password for the account associated to the resource mailbox reset from Active Directory Users And Computers console.You should then have the password provided to the network users .D、You should consider having the properties of the resource mailbox modified from Microsoft Office Outlook.

考题 单选题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  RATIOB  EMPHASISC  ACTIVE_SESS_POOL_MTHD  RESOURCE_DEGREE_LIMIT_ABSOLUTE

考题 单选题Your company has a main office and a branch office. Your network contains a single Active Directory domain. You install 25 Windows Server 2008 R2 member servers in the branch office. You need to  recommend a storage solution that meets the following requirements: èEncrypts all data on the hard disks   èAllows the operating system to start only when the authorized user is present What should you recommend?()A Encrypting File System (EFS)B File Server Resource Manager (FSRM)C Windows BitLocker Drive Encryption (BitLocker)D Windows System Resource Manager (WSRM)

考题 单选题You need to recommend a strategy for the file servers that meets the company’s technical requirements.   What should you recommend?()A Implement active file screens.B Implement passive file screens.C Configure classification rules.D Configure File Server Resource Manager (FSRM) quotas.

考题 单选题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 network consists of a single Active Directory domain. Users access and share documents by using a DFS namespace. You need to recommend a solution to manage user access to documents. The solution must meet the following requirements: èAllow for document versioning èAllow for online collaboration What should you recommend?()A File Server Resource Manager (FSRM)B Volume Shadow Copy Service (VSS)C Microsoft SharePoint Foundation 2010D Windows System Resource Manager (WSRM)

考题 单选题You are a Database Administrator with TXGlobal. You use a password file to establish remote connections to the HR database on the server located at the home office. Currently, two active remote sessions exist to this database. These sessions were established using the SYSDBA privilege from the remote machines. You accidentally deleted the password file. What will be the consequence of this action?()A  Both the sessions will be killed, and no new sessions will be created using the SYSDBA or SYSOPER privilege.B  Both the sessions will remain active, but no new sessions will be created using the SYSDBA or SYSOPER privilege.C Both the sessions will be killed, but new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.D  The database will crash, and no new sessions will be created using the SYSDBA or SYSOPER privilege when the database restarts.

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

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

考题 单选题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 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 need to validate whether Active Directory successfully replicated between two domain  controllers.     What should you do()A Run the DSget command.B Run the Dsquery command.C Run the RepAdmin command.D Run the Windows System Resource Manager.

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