网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
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 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.” 相关考题
考题
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
考题
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 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.
考题
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.
考题
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.
考题
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 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.
考题
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.
考题
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 SanJose2B、The serial 0/0/1 interface on the ISP router has been configured with the set metric 50commandC、The output was generated by entering the show ip bgp command on the SanJose1 routerD、The output was generated by entering the show ip bgp command on the ISP routerE、The serial 0/0/1 interface on the ISP router has been configured with the set metric 75commandF、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
考题
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 relationshipD、All ecisting neighbor relationships will go down
考题
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 limitB、 The pages to paging space per secondC、 The number of page operations per secondD、 The number of processes waiting for page out
考题
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
考题
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 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.
考题
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）.
考题
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.
考题
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.
考题
单选题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 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.
考题
单选题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.
考题
多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in the undo tablespace.DThe transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
考题
单选题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
考题
单选题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.
考题
单选题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 limitB
The pages to paging space per secondC
The number of page operations per secondD
The number of processes waiting for page out
考题
单选题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.
考题
单选题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
热门标签
最新试卷