niusouti.com

单选题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?（）Abecause AWR baseline is not enabledBbecause Current Open Cursors Count is not a ba

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

B

because Current Open Cursors Count is not a basic metric

C

because the STATISTICS_LEVEL parameter is set to BASIC

D

because the AWR baseline is a system-defined moving window baseline

相似考题

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

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

4.View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?()A. Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.B. The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.C. Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.D. The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.

参考答案和解析
正确答案： A
解析： 暂无解析
更多“单选题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 ”相关问题

  • 第1题：

    View the Exhibit exhibit1 to examine the series of SQL commands. View the Exhibit exhibit2 to examine the plans available in the SQL plan baseline. The baseline in the first row of the Exhibit is created when OPTIMIZER_MODE was set to FIRST_ROWS.Which statement is true if the SQL query in exhibit1 is executed again when the valueof OPTIMIZER_MODE is set to FIRST_ROWS?（）

    A. The optimizer uses a new plan because none of the plans in the exhibit2 are fixed plans.

    B. The optimizer uses the plan in the second row of the exhibit2 because it is an accepted plan.

    C. The optimizer uses the plan in the first row of the exhibit2 because it is the latest generated plan.

    D. The optimizer uses the plan in the first row of the exhibit2 because OPTIMIZER_MODE was set to FIRST_ROW during its creation.


    参考答案：B

  • 第2题：

    Teaching students of threshold level is hard work but the effort is very worthwhile．

    A:precious
    B:rewarding
    C:worth
    D:challenging

    答案：B
    解析：
    教入门级的学生需要付出大量努力，但结果很另人欣慰。precious“珍贵的”，例如：Pandas are precious creatures．熊猫是珍贵的动物。rewarding“值得的、有回报的”, 最符合题意，例如：To spend some time in English is rewarding．花点时间学英语是值得的。 worth“值得的”，多用be worth doing/sth．例如：The house is worth a lot of money．这栋房子值很多钱。challenging“有挑战的”，例如：I intend to give up my present post in order to get a more challenging opportunity．为了获得一个更有挑战性的工作机会，本人打算放弃目前的职位。

  • 第3题：

    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

    正确答案:D

  • 第4题：

    阈值（Threshold）


    正确答案:由易患性决定的多基因病的发病的最低限度称为阈值。

  • 第5题：

    The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50 % and critical threshold to be 53% in Database Control. Which statement is true？（）

    • A、 The new setting would be applied but no alerts would be raised immediately.
    • B、 The new setting would be applied and an alert would be raised immediately.
    • C、 The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
    • D、 The new setting would cause an error because the tablespace space usage is more than the specified threshold value.

    正确答案:A

  • 第6题：

    While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

    • A、It would result in an error because the warning threshold cannot be more than the critical threshold.
    • B、The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
    • C、The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
    • D、Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

    正确答案:A

  • 第7题：

    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.

    正确答案:D

  • 第8题：

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

    B

    because Current Open Cursors Count is not a basic metric

    C

    because the STATISTICS_LEVEL parameter is set to BASIC

    D

    because the AWR baseline is a system-defined moving window baseline


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

  • 第9题：

    单选题
    While setting up the thresholds for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
    A

    It would result in an error because the warning threshold cannot be more than the critical threshold.

    B

    The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.

    C

    The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.

    D

    Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.


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

  • 第10题：

    单选题
    When optimizing a standalone point-to-multipoint bridge installation with eight non-root bridges. Which of the following RTS threshold and CWmin settings would be correct for the non-root bridges？（）
    A

    RTS threshold = 1，CWmin = 4

    B

    RTS threshold = 4000，CWmin = 5

    C

    RTS threshold = 4000，CWmin = 3

    D

    RTS threshold = 1，CWmin = 5


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

  • 第11题：

    单选题
    View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）
    A

    An Automatic Workload Repository snapshot has been taken recently.

    B

    The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.

    C

    The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.

    D

    The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.


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

  • 第12题：

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


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

  • 第13题：

    同频A5实际的门限参数是()

    A.threshold2a

    B.threshold2

    C.threshold3a

    D.threshold3


    参考答案：C, D

  • 第14题：

    When optimizing a standalone point-to-multipoint bridge installation with eight non-root bridges Which of the following rts threshold and cwmin settings would be correct for the non-root bridges？（）

    • A、rts threshold = 1，cwmin = 4
    • B、rts threshold = 4000，cwmin = 5
    • C、rts threshold = 4000，cwmin = 3
    • D、rts threshold = 1，cwmin = 5

    正确答案:D

  • 第15题：

    While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）

    • A、 It would result in an error because the warning threshold cannot be more than the critical threshold.
    • B、 The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.
    • C、 The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.
    • D、 Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.

    正确答案:A

  • 第16题：

    When optimizing a standalone point-to-multipoint bridge installation with eight non-root bridges. Which of the following rts threshold and cwmin settings would be correct for the non-root bridges？（）

    • A、rts threshold=4000，cwmin=3
    • B、rts threshold=1，cwmin=4
    • C、rts threshold=4000，cwmin=5
    • D、rts threshold=1，cwmin=5

    正确答案:D

  • 第17题：

    View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view. After 30 minutes， you executed the following command：  SQL> SELECT reason，metric_value FROM dba_outstanding_alerts； REASON         METRIC_VALUE  ------------------------------------------------------------  ------------  Tablespace [TEST] is [28 percent]full  28.125  What could be the reason for the elimination of the other rows in the output（）

    • A、An Automatic Workload Repository snapshot has been taken recently.
    • B、The non-threshold-based alerts are transferred to DBA_ALERT_HISTORY.
    • C、The threshold alerts conditions are cleared and the alerts are transferred to DBA_ALERT_HISTORY.
    • D、The threshold alerts related to database metrics are permanently stored in DBA_ALERT_HISTORY but not the threshold alerts related to instance metrics.

    正确答案:C

  • 第18题：

    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

  • 第19题：

    单选题
    The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50% and critical threshold to be 53% in Database Control. Which statement is true？（）
    A

    The new setting would be applied but no alerts would be raised immediately.

    B

    The new setting would be applied and an alert would be raised immediately.

    C

    The new setting would be ignored because the tablespace space usage is more than the specified threshold value.

    D

    The new setting would cause an error because the tablespace space usage is more than the specified threshold value.


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

  • 第20题：

    单选题
    While setting up the threshold for tablespace space usage metrics for one of your tablespaces， you define the critical threshold as 60% and warning threshold as 75%. What would be the result of this setting？（）
    A

     It would result in an error because the warning threshold cannot be more than the critical threshold.

    B

     The warning threshold is ignored and alerts would be generated when space usage exceeds the critical threshold.

    C

     The critical threshold is ignored and alerts would be generated when space usage exceeds the warning threshold.

    D

     Both threshold values are used and alerts are generated when space usage exceeds the respective threshold values.


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

  • 第21题：

    单选题
    When optimizing a standalone point-to-multipoint bridge installation with eight non-root bridges，which of the following RTS threshold and CWmin settings would be correct for the non-root bridges？（）
    A

    RTS threshold = 4000， CWmin = 3

    B

    RTS threshold = 1， CWmin = 4

    C

    RTS threshold = 4000， CWmin = 5

    D

    RTS threshold = 1， CWmin = 5


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

  • 第22题：

    单选题
    View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?（）
    A

    Oracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.

    B

    The statistics for the metric values observed over the baseline time period are not examined to determine threshold values.

    C

    Oracle determines when an adaptive threshold has been breached based on the maximum value captured by the baseline.

    D

    The total concurrent number of threshold violations, which must occur before an alert is raised for the metric, has been set to zero.


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

  • 第23题：

    多选题
    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
    解析： 暂无解析

  • 第24题：

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


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

相关内容