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

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

B

 Implement Database Resource Manager

C

 Enable resumable timeout for user sessions

D

 Add directives to Automatic Database Diagnostic Monitor （ADDM）

相似考题

1.You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）A. Set a threshold for the default system-defined moving window baseline.B. Add directives to the Automatic Database Diagnostic Monitor (ADDM).C. Modify the profile for the targeted users for which control needs to be imposed.D. Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.

2.You have 50 subscribers accessing a LAC to connectto ISP1.com.What is the L2TP Control Connections and Sessions for the subscribers?()A.A single Control Connection and a single SessionB.A single Control Connection and multiple Sessions(one pers ubscriber)C.Multiple Control Connections and a single SessionD.Multiple Control Connections and multiple Sessions(one per subscriber)

3.You‘re the systems administrator at Testing, and you create the following access control lists.You then enter the command "ip access-group 101 in" to apply access control list 101 to router TK1s e0 interface.Which of the following Telnet sessions will be blocked as a result of your access lists?（）A. Telnet sessions from host A to host 5.1.1.10B. Telnet sessions from host A to host 5.1.3.10C. Telnet sessions from host B to host 5.1.2.10D. Telnet sessions from host B to host 5.1.3.8E. Telnet sessions from host C to host 5.1.3.10F. Telnet sessions from host F to host 5.1.1.10

4.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 plan to control idle sessions that are blocking other se”相关问题

  • 第1题：

    Where do you post your （）(火势控制图)?

    • A、fire control plan
    • B、fire control
    • C、fire plan
    • D、fire-fighting plan

    正确答案:A

  • 第2题：

    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$SYSSTAT
    • B、 V$SESSSTAT
    • C、 V$RSRC_PLAN
    • D、 V$RSRC_CONSUMER_GROUP

    正确答案:D

  • 第3题：

    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

    正确答案:A,B,E

  • 第4题：

    You are developing a Windows Forms Application by using the .NET Framework 3.5.You plan to design a composite custom control for the application. You include a ListBox control has a property that provides the item count of  the ListBox control. You need to ensure that the property cannot be accessed at design time. Which attribute should you use？（）

    • A、[Bindable（false）]
    • B、[DesignOnly（false）]
    • C、[EditorBrowsable（EditorBrowsableState.Never）]
    • D、[Browsable（false）]

    正确答案:D

  • 第5题：

    单选题
    In order to find out which lifeboat you are assigned, you should look at the （）.
    A

    Certificate of Inspection

    B

    Station Bill

    C

    Ships Articles

    D

    Fire Control Plan


    正确答案： B
    解析： 暂无解析

  • 第6题：

    单选题
    You are developing a Windows Forms Application by using the .NET Framework 3.5.You plan to design a composite custom control for the application. You include a ListBox control has a property that provides the item count of  the ListBox control. You need to ensure that the property cannot be accessed at design time. Which attribute should you use？（）
    A

    [Bindable（false）]

    B

    [DesignOnly（false）]

    C

    [EditorBrowsable（EditorBrowsableState.Never）]

    D

    [Browsable（false）]


    正确答案： C
    解析： 暂无解析

  • 第7题：

    单选题
    TS3 is a server running Windows Server 2008 and Terminal Services. You have the responsibility ofsupporting users who connect to TS3 to run various applications. Users complain that the application is responding slowly. You use the quser command on TS3 and discover that many users havemultiple disconnected sessions on the server with idle times of two days or more. You want to reduce thestrain on the TS3 by eliminating disconnected sessions that have been idle for more than two days. What should you do？（）
    A

    Use the Rwinsta command.

    B

    Use the Tsdicon command.

    C

    Use the Tskill command.

    D

    Use the Tscon command.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    You are creating a Windows Forms application by using the .Net Framework 3.5.You plan to design a composite control for the application.You need to derive the control from a base class that supports templates.What should you do？（）
    A

    Derive from the Control class.

    B

    Derive from the UserControl class.

    C

    Derive from the ScrollableControl class.

    D

    Derive from the ContainerControl class.


    正确答案： A
    解析： 暂无解析

  • 第9题：

    单选题
    You use Microsoft .NET Framework 4 to create a Windows Presentation Framework (WPF) application. You plan to create a custom control that contains four text input fields. Each of the text input fields within the control will contain a label. You need to ensure that the text input fields within the control can be validated by using a regular expression validator. Which class should you inherit from?（）
    A

     TextBox

    B

     TextElement

    C

     UIElement

    D

     UserControl


    正确答案： B
    解析： 暂无解析

  • 第10题：

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

    B

    Implement Database Resource Manager

    C

    Enable resumable timeout for user sessions

    D

    Add directives to Automatic Database Diagnostic Monitor (ADDM)


    正确答案： B
    解析： 暂无解析

  • 第11题：

    单选题
    You are creating a Windows Forms application by using the .NET Framework 3.5.You plan to develop a new control for the application. You need to ensure that the control extends the DataGridView control by allowing the cells to contain multicolored text. What should you do？（）
    A

    Override the OnPaint method.

    B

    Write a code segment to handle the CellPainting event.

    C

    Write a code segment to handle the CellParsing event.

    D

    Write a code segment to handle the RowPostPaint event.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You have 50 subscribers accessing a LAC to connectto ISP1.com.What is the L2TP Control Connections and Sessions for the subscribers?（）
    A

    A single Control Connection and a single Session

    B

    A single Control Connection and multiple Sessions(one pers ubscriber)

    C

    Multiple Control Connections and a single Session

    D

    Multiple Control Connections and multiple Sessions(one per subscriber)


    正确答案： C
    解析： 暂无解析

  • 第13题：

    You have 50 subscribers accessing a LAC to connectto ISP1.com.What is the L2TP Control Connections and Sessions for the subscribers?（）

    • A、A single Control Connection and a single Session
    • B、A single Control Connection and multiple Sessions(one pers ubscriber)
    • C、Multiple Control Connections and a single Session
    • D、Multiple Control Connections and multiple Sessions(one per subscriber)

    正确答案:B

  • 第14题：

    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

    正确答案:A,B,E

  • 第15题：

    You are creating a Windows Forms application by using the .NET Framework 3.5. You plan to develop a new control for the application.You need to ensure that the control extends the TreeView control by adding a custom node tag and a highlight color.What should you do？（）

    • A、Override the OnPaint method.
    • B、Write a code segment in the DrawNode event handler to specify the highlight color.
    • C、Set the DrawMode property of the control to OwnerDrawAll， and then implement a custom DrawNode event handler.
    • D、Set the DrawMode property of the control to OwnerDrawText，and then implement a custom DrawNode event handler.

    正确答案:D

  • 第16题：

    You are creating a Windows Forms application by using the .Net Framework 3.5.You plan to display detailed help instructions for each control in the form.You create a help file.You configure a HelpProvider component on the form.You need to display the help file for the control that is focused when the F1 key is pressed.Which method of the HelpProvider class should you call for each control？（）

    • A、SetShowHelp
    • B、SetHelpString
    • C、SetHelpKeyword
    • D、SetHelpNavigator

    正确答案:A

  • 第17题：

    单选题
    You are creating a Windows Forms application by using the .NET Framework 3.5.You plan to develop a custom control for the application.  The control will be a composite control.Your need to derive from the class that will create the control by using the minimum amount of development effort.What should you do？（）
    A

    Derive from the Control class.

    B

    Derive from the UserControl class.

    C

    Derive from the FrameworkElement class.

    D

    Derive from the ContainerControl class.


    正确答案： C
    解析： 暂无解析

  • 第18题：

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

    B

     V$SESSSTAT

    C

     V$RSRC_PLAN

    D

     V$RSRC_CONSUMER_GROUP


    正确答案： D
    解析： 暂无解析

  • 第19题：

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


    正确答案： D,B
    解析： 暂无解析

  • 第20题：

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


    正确答案： B
    解析： 暂无解析

  • 第21题：

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

    B

    Implementing Database Resource Manager

    C

    Enabling resumable timeout for user sessions

    D

    Decreasing the value of the IDLE_TIME resource limit in the default profile


    正确答案： D
    解析： 暂无解析

  • 第22题：

    单选题
    You are creating a Windows Forms Application by using the .NET Framework 3.5.You plan to design a control for the application.You need to ensure that the control meets the following requirements：    （1）Contains the DataGridView， BindingSource， and BindingNavigator controls.  （2）Exposes the properties of the BindingSource control.   （3）Protects the properties of the DataGridView and BindingNavigator controls.    What sholud you do？（）
    A

    Extend the Control class.

    B

    Extend the ContainerControl class.

    C

    Create protected accesses for each control property.

    D

    Create public accesses for the properties of the BindingSource control.


    正确答案： A
    解析： 暂无解析

  • 第23题：

    单选题
    You plan to control the sessions performing a huge number of I/O operations. Your requirement is to kill the session when it exceeds a specified number of I/Os. Which statement describes a solution to the above?（）
    A

    Set a threshold for the default system-defined moving window baseline.

    B

    Add directives to the Automatic Database Diagnostic Monitor (ADDM).

    C

    Modify the profile for the targeted users for which control needs to be imposed.

    D

    Implement the database resource manager to add the SWITCH_IO_REQS and SWITCH_GROUP directives.


    正确答案： D
    解析： 暂无解析

相关内容