单选题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?()AUse the Database Resource Manager.BSet the limits in the profiles used by users.CModify the SESSIONS initialization parameter.DSet the warning threshold for the Current Logons Count metric.

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


参考解析

解析: 暂无解析

相关考题:

Which command would you use to view interface usage details in real time?() A. show interfaces terseB. show interfaces extensiveC. monitor interface trafficD. monitor traffic interface

Which command allows you to view interface usage details in real-time?()A、user@host debug interface interface-nameB、user@host monitor usage interface-nameC、user@host monitor interface interface-nameD、user@host traceoptions interface interface-name

Which command would you use to view interface usage details in real time?()A、show interfaces terseB、show interfaces extensiveC、monitor interface trafficD、monitor traffic interface

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

You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()  A、 INDEX_STATSB、 DBA_INDEXESC、 DBA_IND_COLUMNSD、 V$OBJECT_USAGE

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

Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2.You have a server named Server1 that hosts shared documents. Users report extremely slow response times when they try to open the shared documents on Server1.You log on to Server1 and observe real-time data indicating that the processor is operating at 100 percent of capacity.You need to gather additional data to diagnose the cause of the problem. What should you do?()A、In the Performance Monitor console, create a counter log to track processor usage.B、In Event Viewer, open and review the application log for Performance events.C、In Resource Monitor, use the Resource View to see the percentage of processor capacity used by each application.D、In Performance Monitor, create performance counter alert that will be triggered when processor usage exceeds 80 percent for more than five minutes on Server1.

Your network consists of a single Active Directory domain. All servers run Windows Server 2008 R2.You have a server named Server1 that hosts shared documents. Users report extremely slow response times when they try to open the shared documents on Server1.You log on to Server1 and observe real-time data indicating that the processor is operating at 100 percent of capacity.You need to gather additional data to diagnose the cause of the problem.What should you do?()A、In the Performance Monitor console, create a counter log to track processor usage.B、In Event Viewer, open and review the application log for Performance events.C、In Resource Monitor, use the Resource View to see the percentage of processor capacity used by each application.D、In Performance Monitor, create performance counter alert alert that will be triggered when processor usage exceeds 80 percent for more than five minutes on Server1.

You are developing a product search page named Search.aspx for Web application that will be integrated into Certkiller .com's existing e-Commerce Web site. The Search.aspx page allows customers search for products that match specific criteria. Once a product is located, you want an image of the product to be displayed. You want to use an Image control to display the image. You want to configure the Image control to display a description of the image if the image cannot be displayed in the customer's Web browser. What should you do?()A、Set the ToolTip property of the Image control.B、Set the ImageUrl property of the Image control.C、Set the AlternateText property of the Image control.D、Set the DescriptionUrl property of the Image control.

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 notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?()A、It detects any configuration change that caused a performance difference in both time periods.B、It identifies any workload change that caused a performance difference in both time periods.C、It detects the top wait events causing performance degradation.D、It shows the resource usage for CPU, memory, and I/O in both time periods.E、It shows the difference in the size of memory pools in both time periods.F、It gives information about statistics collection in both time periods.

单选题An administrator is configuring an application monitor. Upon encountering an unrecoverable error the administrator does not want the resource group to failover. How can the application monitor be configured toachieve this?()AConfigure the application monitor with a restart count of 0BConfigure the application monitor with a monitor mode of NotifyCConfigure the application monitor with a notify method of MonitorDConfigure the application monitor with a failure action of Notify

单选题Which command allows you to view interface usage details in real-time?()Auser@host debug interface interface-nameBuser@host monitor usage interface-nameCuser@host monitor interface interface-nameDuser@host traceoptions interface interface-name

单选题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?()ALOGICAL_READS_PER_SESSION BCONNECT_TIME CCOMPOSITE_LIMIT DCPU_PER_SESSION EPRIVATE_SGA

单选题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 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?()AImplement job classesBImplement Scheduler windowsCImplement the mapping rule for the consumer groupsDSet the SWITCH_TIME resource plan directive for both the resource plans

单选题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?()AUse the Database Resource Manager.BSet the limits in the profiles used by users.CModify the SESSIONS initialization parameter.DSet 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

单选题You issued the following statement to monitor the usage of the index:        SQL ALTER INDEX SCOTT.EMP_IDX MONITORING USAGE;   Which view will you query to ensure that the index is being monitored?()A INDEX_STATSB DBA_INDEXESC DBA_IND_COLUMNSD V$OBJECT_USAGE

多选题You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?()AIt detects any configuration change that caused a performance difference in both time periods.BIt identifies any workload change that caused a performance difference in both time periods.CIt detects the top wait events causing performance degradation.DIt shows the resource usage for CPU, memory, and I/O in both time periods.EIt shows the difference in the size of memory pools in both time periods.FIt gives information about statistics collection in both time periods.

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

单选题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?()ASet metric thresholdBImplement Database Resource ManagerCEnable resumable timeout for user sessionsDAdd directives to Automatic Database Diagnostic Monitor (ADDM)

单选题You are the administrator of a Windows XP Professional computer. You run five 16-bit applications on the computer. You want to monitor the performance of the computer when all five applications run at the same time. You use System Monitor to collect the performance data. The performance counters you want to include in your analysis are IO Read Bytes/sec, IO Write Bytes/sec, and Page Faults/sec. You want to ensure that you can collect these counters for each application. What should you do?()ARun the five 16-bit applications in one process. Monitor each thread of Ntvdm.exe. BRun each of the five 16-bit applications in its own memory space. Monitor each instance of Ntvdm.exe.  CRun the five 16-bit applications in Windows 95 compatibility mode. Monitor each instance of the applications. DStart the five 16-bit applications by using the Start /normal command. Monitor each instance of the applications.

单选题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?()Aassign users to consumer groupsBset the resource plan for the instanceCconfigure a simple resource plan and specify plan directivesDconfigure 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