网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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
参考答案
参考解析
解析：
暂无解析
更多 “单选题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” 相关考题
考题
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
考题
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.
考题
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
考题
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).
考题
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.
考题
Teaching students of threshold level is hard work but the effort is very worthwhile．A:precious
B:rewarding
C:worth
D:challenging
考题
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 = 4B、rts threshold = 4000，cwmin = 5C、rts threshold = 4000，cwmin = 3D、rts threshold = 1，cwmin = 5
考题
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
考题
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.
考题
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=3B、rts threshold=1，cwmin=4C、rts threshold=4000，cwmin=5D、rts threshold=1，cwmin=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.
考题
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.
考题
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.
考题
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）.
考题
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.
考题
单选题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.
考题
单选题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.
考题
单选题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.
考题
单选题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 = 3B
RTS threshold = 1， CWmin = 4C
RTS threshold = 4000， CWmin = 5D
RTS threshold = 1， CWmin = 5
考题
单选题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 = 4B
RTS threshold = 4000，CWmin = 5C
RTS threshold = 4000，CWmin = 3D
RTS threshold = 1，CWmin = 5
考题
单选题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.
考题
单选题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.
考题
多选题Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）AIt does not allow you to change the moving window size.BAdaptive threshold functionalities use it by default to compute statistics.CIt is created by default with the window size being equal to the AWR retention time.DIt is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
考题
单选题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.
考题
单选题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
热门标签
最新试卷