单选题View the Exhibit to examine the metrics with a threshold.Which statement is true regarding the Number of Transactions (per second) metric?（）AOracle uses statistical relevance to determine when an adaptive threshold has been breached for the metric.BThe

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

相似考题

1.The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session?()A. The tape I/O performed is asynchronousB. The tape buffer is allocated from the System Global Area (SGA)C. The tape buffer is allocated from the Program Global Area (PGA)D. Oracle I/O uses an interrupt mechanism to determine when each I/O completes

2.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

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

4.View the exhibit and examine the output.Which statement can be an inference from the output?()A. The FRA disk group has an asynchronous I/O bottleneckB. The least number of I/Os are performed on the last data file in the listC. The number of times that the backup or restore process directed the OS to wait until an I/O was complete is the highest for the last data file in the listD. The number of times that the backup or restore process made an OS call to poll for I/O completion in Nonblocking mode is the least for the FRA disk group

更多“单选题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 ”相关问题

  • 第1题：

    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

  • 第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).


    参考答案：B, C

  • 第3题：

    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

  • 第4题：

    A new Backup Connection is being deployed on a remote site router. the stability of the connection has been a concern. in order to provide more information to EIGRP Regarding this interface， You wish to incorporate the "Reliability" cost metric in the EIGRP Calculation with the command metric weights 1 0 1 0 1. What impact will this modification on the remote site router have for other existing EIGRP neighborships from the same EIGRP Domain？（）

    • A、Existing Neighbors will immediately begin using the new metric.
    • B、Existing Neighbors will use the new metric after clearing the EIGRP Neighbors.
    • C、Existing Neighbors will resync， maintaining the neighbor relationship
    • D、All ecisting neighbor relationships will go down

    正确答案:D

  • 第5题：

    The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）  

    • A、 The tape I/O performed is asynchronous
    • B、 The tape buffer is allocated from the System Global Area （SGA）
    • C、 The tape buffer is allocated from the Program Global Area （PGA）
    • D、 Oracle I/O uses an interrupt mechanism to determine when each I/O completes

    正确答案:C

  • 第6题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第7题：

    Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which statement regarding the usage of redo log files during instance recovery is true？ （）

    • A、Transactions are rolled back using redo log files.
    • B、Transactions are rolled forward using redo log files.
    • C、Transactions are rolled back using redo log files and archived log files.
    • D、Transactions are rolled forward using redo log files and rolled back using redo log files.

    正确答案:B

  • 第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题：

    单选题
    View the Exhibit and examine the structure of the ORDERS and ORDERJTEMS tables.  Evaluate the following SQL statement：   SELECT oi.order_id， product_jd， order_date   FROM order_items oi JOIN orders o   USING （order_id）；   Which statement is true regarding the execution of this SQL statement？（）
    A

     The statement would not execute because table aliases are not allowed in the JOIN clause.

    B

     The statement would not execute because the table alias prefix is not used in the USING clause.

    C

     The statement would not execute because all the columns in the SELECT clause are not prefixed with table aliases.

    D

     The statement would not execute because the column part of the USING clause cannot have a qualifier in the SELECT list.


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

  • 第10题：

    多选题
    Which two statements are true regarding transactions in an Oracle database（）
    A

    Multiple transactions can use the same undo segment.

    B

    A transaction is assigned an undo segment when it is started.

    C

    More than one transaction cannot share the same extent in the undo tablespace.

    D

    The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.


    正确答案： B,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题：

    单选题
    Which statement is true regarding remote archive log file destinations？（）
    A

    Only two destinations per remote database can be specified.

    B

    Destination is an Oracle Net alias specified by using the SERVICE keyword.

    C

    The REOPEN attribute must be used when using remote archive log file destinations.

    D

    The service name is resolved by searching sqlnet.ora file for the remote database name.


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

  • 第13题：

    View the Exhibit to examine the error while executing the REPAIR FAILURE command in an RMAN session.What is the reason for this error?()

    A. Another repair session is running concurrently.

    B. The failure ID has not been mentioned in the command for data file 5.

    C. There are new failures recorded in the Automatic Diagnostic Repository (ADR).

    D. The ADVISE FAILURE command has not been issued before the REPAIR FAILURE command.


    参考答案：A

  • 第14题：

    View the Exhibit to examine the output for the V$DIAG_INFO view. Which statements are true regarding the location of diagnostic traces?()

    A. The path to the location of the background as well as the foreground process trace files is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

    B. The location of the text alert log file is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.

    C. The location of the trace file for the current session is /u01/oracle/diag/rdbms/orclbi/orclbi/trace.

    D. The location of the XML-formatted version of the alert log is /u01/oracle/diag/rdbms/orclbi/orclbi/alert.


    参考答案：A, C, D

  • 第15题：

    Refer to the exhibit. On the basis of the information in the exhibit， which two statements are true？（）

    • A、When traffic is sent from the ISP to autonomous system 64512， the traffic will be forwarded toSanJose2 because of the higher MED value of SanJose2
    • B、The serial 0/0/1 interface on the ISP router has been configured with the set metric 50command
    • C、The output was generated by entering the show ip bgp command on the SanJose1 router
    • D、The output was generated by entering the show ip bgp command on the ISP router
    • E、The serial 0/0/1 interface on the ISP router has been configured with the set metric 75command
    • F、When traffic is sent from the ISP to autonomous system 64512， the traffic will be forwarded toSanJose1 because of the lower MED value of SanJose1

    正确答案:D,F

  • 第16题：

    When monitoring a system using vmstat with an interval， the metrics under page po represent which of the following phrases？（） 

    • A、 The number pages over the limit
    • B、 The pages to paging space per second
    • C、 The number of page operations per second
    • D、 The number of processes waiting for page out

    正确答案:B

  • 第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题：

    Which statement is true regarding remote archive log file destinations？（）

    • A、Only two destinations per remote database can be specified.
    • B、Destination is an Oracle Net alias specified by using the SERVICE keyword.
    • C、The REOPEN attribute must be used when using remote archive log file destinations.
    • D、The service name is resolved by searching sqlnet.ora file for the remote database name.

    正确答案:B

  • 第20题：

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

  • 第21题：

    单选题
    View the Exhibit and examine the structure of the EMP table. You executed the following command to add a primary key to the EMP table：   ALTER TABLE emp   ADD CONSTRAINT emp_id_pk  PRIMARY KEY （emp_id）   USING INDEX emp_id_idx；   Which statement is true regarding the effect of the command？（）
    A

     The PRIMARY KEY is created along with a new index.

    B

     The PRIMARY KEY is created and it would use an existing unique index.

    C

     The PRIMARY KEY would be created in a disabled state because it is using an existing index.

    D

     The statement produces an error because the USING clause is permitted only in the CREATE TABLE command.


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

  • 第22题：

    单选题
    The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Which statement is true while performing a tape backup in an RMAN session？（）
    A

     The tape I/O performed is asynchronous

    B

     The tape buffer is allocated from the System Global Area （SGA）

    C

     The tape buffer is allocated from the Program Global Area （PGA）

    D

     Oracle I/O uses an interrupt mechanism to determine when each I/O completes


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

  • 第23题：

    单选题
    When monitoring a system using vmstat with an interval， the metrics under page po represent which of the following phrases？（）
    A

     The number pages over the limit

    B

     The pages to paging space per second

    C

     The number of page operations per second

    D

     The number of processes waiting for page out


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

  • 第24题：

    单选题
    Which statement is true regarding synonyms?（）
    A

    Synonyms can be created only for a table 

    B

    Synonyms are used to reference only those tables that are owned by another user 

    C

    A public synonym and a private synonym can exist with the same name for the same table 

    D

    The DROP SYNONYM statement removes the synonym, and the table on which the synonym has been created becomes invalid


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

相关内容