You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A、The collect

题目

You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）

  • A、The collection level for the AWR should be set to BASIC
  • B、The moving window size must be less than Undo Retention
  • C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
  • D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
相似考题

1.View the Exhibit that sets the threshold for the Current Open Cursors Count metric.Why is the Significance Level threshold type not available in the threshold setting?()A. because AWR baseline is not enabledB. because Current Open Cursors Count is not a basic metricC. because the STATISTICS_LEVEL parameter is set to BASICD. because the AWR baseline is a system-defined moving window baseline

2.Which statements are true regarding the system－defined moving window baseline in Oracle Database 11g?()A. It does not allow you to change the moving window size.B. Adaptive threshold functionalities use it by default to compute statistics.C. It is created by default with the window size being equal to the AWR retention time.D. It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).

3.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.

4.You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period

更多“You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A、The collect”相关问题

  • 第1题：

    You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()

    A. Compute the baseline statistics.

    B. Take an immediate AWR snapshot.

    C. Decrease the window size for the baseline.

    D. Decrease the expiration time for the baseline.


    参考答案：A

  • 第2题：

    You are the administrator of a SQL Server computer. Users report that the database times out when they attempt to modify data. You use the Current Activity window to examine locks held in the database as shown in the following screenshot.

    You need to discover why users cannot modify data in the database, but you do not want to disrupt normal database activities. What should you do?

    A．Use the spid 52 icon in the Current Activity window to discover which SQL statement is being executed

    B．Use the sp_who stored procedure to discover who is logged in as spid 52

    C．Use SQL Profiler to capture the activity of the user who is logged in as spid 52

    D．Use System Monitor to log the locks that are granted in the database


    正确答案：A
    解析：Explanation: The current activity window in SQL Server Enterprise Manager can be used to perform. ad hoc monitoring of an instance of SQL Server. This allows for the quick analysis of the volume and general types of activity on the system and can indicate current blocked and blocking transactions, currently connected users on an instance of SQL Server and the last statement executed and locks that are in effect on the database.

    In the screen shot of current activity window the icon, labeled spid 51, indicates that a database lock is in place; the second icon, labeled spid 52, can be used to identify the process that is blocking one or more connections; and the third icon, labeled spid 53, can be used to identify the process that is being blocked by another connection

    Incorrect Answers:
    B: The system stored procedure sp_lock can be used to return a result set that contains information about resources that are locked and the sp_who stored procedure provides information about current SQL Server 2000 users and processes. The information returned by the sp_who procedure can be filtered to return only current non-idle processes. This makes it possible to identify which resources are being locked and which processes are responsible for creating those locks. These stored procedures require more resources and more administrative effort than the Current Activity window. It is therefore not the best answer.

    C: The SQL profiler is not the best tool to immediately solve the locking problem. It could be used at a later moment if a long-term solution to the problem is required. SQL profiler would require more system resources and might impact normal database activities.

    Note: SQL Profiler is a graphical tool that allows system administrators to monitor events in an instance of SQL Server. Data pertaining to an event can be captured and saved to a file or SQL Server table to be analyzed at a later date. It can be is used to step through problem queries to find the cause of the problem; to find and diagnose slow-running queries; to capture the series of SQL statements that led to a problem; and to monitor the performance of SQL Server to tune workloads.

    D: SQL Server provides objects and counters that can be used by System Monitor in a Windows 2000 or by Performance Monitor in Windows NT 4.0 to monitor the system performance of computers running an instance of SQL Server. However, these counters are used for statistics and alerts and they cannot, in a direct way, be used to track down the cause of the locking problem.

  • 第3题：

    A server is connected to a gigabit Ethernet switch and has negotiated 1Gbps / Full Duplex. When transferring large files to and from other servers on the segment via FTP slow performance is noticed.All network cabling，network hardware and server hardware were verified to be working correctly.  Which of the following could be done to improve performance？（）

    • A、 Decrease the TCP window size.
    • B、 Increase the UDP window size.
    • C、 Increase the TCP window size.
    • D、 Decrease the UDP window size.

    正确答案:C

  • 第4题：

    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.

    正确答案:C

  • 第5题：

    As an alternative to setting the Visible property to No for the ORDERS_WINDOW, which built-in could you use to achieve the same result? （）

    • A、HIDE_WINDOW 
    • B、CLOSE_WINDOW 
    • C、REPLACE_CONTENT_VIEW
    • D、GET_WINDOW_PROPERTY

    正确答案:A

  • 第6题：

    Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）

    • A、 It does not allow you to change the moving window size.
    • B、 Adaptive threshold functionalities use it by default to compute statistics.
    • C、 It is created by default with the window size being equal to the AWR retention time.
    • D、 It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.

    正确答案:B,C

  • 第7题：

    You notice that the elapsed time for an important database scheduler Job is unacceptably long. The job belongs to a scheduler job class and window. Which two actions would reduce the job's elapsed time?（）

    • A、Increasing the priority of the job class to which the job belongs
    • B、Increasing the job's relative priority within the Job class to which it belongs
    • C、Increasing the resource allocation for the consumer group mapped to the scheduler job's job class within the plan mapped to the scheduler window
    • D、Moving the job to an existing higher priority scheduler window with the same schedule and duration
    • E、Increasing the value of the JOB_QUEUE_PROCESSES parameter
    • F、Increasing the priority of the scheduler window to which the job belongs

    正确答案:B,C

  • 第8题：

    After you install a new update， an application on the computer fails to run. You need to remove the update.  What should you do？（）

    • A、Use the Software Explorer window.
    • B、Use the Add or Remove Programs window.
    • C、Restore hidden updates.
    • D、Use the Installed updates list on the Windows Update window.

    正确答案:D

  • 第9题：

    单选题
    You developing a form module, and you would like to make an indicated window visible in a new display position. Which built-in can you use to accomplish this task?（）
    A

    SHOW_WINDOW 

    B

    RESIZE_WINDOW 

    C

    DISPLAY_WINDOW 

    D

    MOVE_WINDOW_X_Y 

    E

    WINDOW_VISIBLE_X_Y


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

  • 第10题：

    多选题
    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）
    A

    The retention period to support flashback

    B

    The expected length of the longest-running query

    C

    The number of undo tablespaces in the database

    D

    The size of the Flash Recovery Area for the database instance


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

  • 第11题：

    多选题
    Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）
    A

    It does not allow you to change the moving window size.

    B

    Adaptive threshold functionalities use it by default to compute statistics.

    C

    It is created by default with the window size being equal to the AWR retention time.

    D

    It is created when the first snapshot is collected by the Automatic Workload Repository (AWR).


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

  • 第12题：

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


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

  • 第13题：

    You notice that the elapsed time for an important database scheduler Job is unacceptably long.The job belongs to a scheduler job class and window.Which two actions would reduce the job‘s elapsed time?（）

    A. Increasing the priority of the job class to which the job belongs

    B. Increasing the job‘s relative priority within the Job class to which it belongs

    C. Increasing the resource allocation for the consumer group mapped to the scheduler job‘s job class within the plan mapped to the scheduler window

    D. Moving the job to an existing higher priority scheduler window with the same schedule and duration

    E. Increasing the value of the JOB_QUEUE_PROCESSES parameter

    F. Increasing the priority of the scheduler window to which the job belongs


    参考答案：B, C

  • 第14题：

    You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?（）

    • A、Compute the baseline statistics.
    • B、Take an immediate AWR snapshot.
    • C、Decrease the window size for the baseline.
    • D、Decrease the expiration time for the baseline.

    正确答案:A

  • 第15题：

    Your database instance is running with full workload after database creation. You have decided to use a fixed-size undo tablespace. You want to use the Undo Advisor to estimate the capacity of the undo tablespace. Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

    • A、The retention period to support flashback
    • B、The expected length of the longest-running query
    • C、The number of undo tablespaces in the database
    • D、The size of the Flash Recovery Area for the database instance

    正确答案:A,B

  • 第16题：

    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）

    • A、 SQL Tuning Advisor
    • B、 Undo Advisor
    • C、 ADDM
    • D、 Memory Advisor

    正确答案:D

  • 第17题：

    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.

    正确答案:A

  • 第18题：

    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

  • 第19题：

    You developing a form module, and you would like to make an indicated window visible in a new display position. Which built-in can you use to accomplish this task?（）

    • A、SHOW_WINDOW 
    • B、RESIZE_WINDOW 
    • C、DISPLAY_WINDOW 
    • D、MOVE_WINDOW_X_Y 
    • E、WINDOW_VISIBLE_X_Y

    正确答案:A

  • 第20题：

    单选题
    As an alternative to setting the Visible property to No for the ORDERS_WINDOW, which built-in could you use to achieve the same result? （）
    A

    HIDE_WINDOW 

    B

    CLOSE_WINDOW 

    C

    REPLACE_CONTENT_VIEW

    D

    GET_WINDOW_PROPERTY


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

  • 第21题：

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


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

  • 第22题：

    单选题
    You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance.  Which advisor would you use to determine the suitable size of the SGA？（）
    A

     SQL Tuning Advisor

    B

     Undo Advisor

    C

     ADDM

    D

     Memory Advisor


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

  • 第23题：

    单选题
    You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）
    A

     Compute the baseline statistics.

    B

     Take an immediate AWR snapshot.

    C

     Decrease the window size for the baseline.

    D

     Decrease the expiration time for the baseline.


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

相关内容