niusouti.com

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

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

相似考题

1.You are a network administrator for your company. All servers run Windows Server 2003. A server namedServer34 runs an application named App1.Users report that App1 is performing slowly. You suspect that an unauthorized application is installed on Server34.You run the netstat command and examine the output, as shown in the exhibit. (Click the Exhibit button.)You need to identify the unauthorized application by using the output from the netstat command.Which tool should you use to identify the application? （）A. Performance consoleB. System MonitorC. Network MonitorD. Task Manager

2.View the exhibit and examine the TRANS table‘s storage information.After a massive delete operation, you executed the following statement to shrink the TRANS table:SQL> ALTER TABLE trans SHRINK SPACE CASCADE;Which statement describes the outcome of the command?（）A. An error is produced.B. The table and all related objects are compacted and the position of the high-water mark (HWM) for the table is adjustedC. The table and related indexes are compacted but the position of the high-water mark (HWM) for the table remains unchangedD. The unused space in the table is reclaimed and returned to the tablespace and the data manipulation language (DML) triggers on the table are fired during the shrinking process

3.Examine the following commands and their output:SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 1050QL> UPDATE emp SET sal=sal+sal*1.2 WHERE ename=‘JAMES‘;1 row updated.SQL> SELECT ename, sal FROM emp WHERE ename=‘JAMES‘; ENAME SAL JAMES 2310View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）A. Flashback logging is not enabled for the database.B. The changes made to the table are not committed.C. Supplemental logging is not enabled for the database.D. The database is not configured in ARCHIVELOG mode.

4.View the Exhibit and examine the output.You execute the following RMAN command to perform the backup operation:What is the multiplexing level in the preceding backup process()A. 4B. 8C. 7D. 0

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

  • 第1题：

    View the Exhibit and examine the steps that you executed to create a database resource plan. Subsequently, you execute the following procedure which results in an error:SQL> EXECUTE dbms_resources_manager.validate_pending_area ( );What could be the reason?（）

    A. The pending area is automatically submitted after the plan creation

    B. The procedure must be executed before creating the resources plan directive

    C. The SYS_GROUP resource consumer group is not included in the resource plan directive

    D. The OTHER_GROUPS resources consumer group is not included in the resource plan directive


    参考答案：D

  • 第2题：

    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

  • 第3题：

    View the Exhibit to examine the error during the database startup.You open an RMAN session for the database instance. To repair the failure, you executed the following as the first command in the RMAN session:RMAN> REPAIR FAILURE;Which statement describes the consequence of the command?（）

    A. The command performs the recovery and closes the failures.

    B. The command only displays the advice and the RMAN script required for repair.

    C. The command produces an error because the ADVISE FAILURE command has not been executed before the REPAIR FAILURE command.

    D. The command executes the RMAN script to repair the failure and removes the entry from the Automatic Diagnostic Repository (ADR).


    参考答案：C

  • 第4题：

    A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?()

    A.When view V1 is created

    B.Each time the REFRESH VIEW v1 statement is executed

    C.Each time an SQL statement is executed against view V1

    D.Only the first time an SQL statement is executed against view V1


    参考答案：C

  • 第5题：

    After logging into the RtrB router, you issue the "show interface" command as displayed below:After considering the effects of the command output illustrated in the exhibit above,which of the following protocols are operational on the serial link?（）

    A. PPP

    B. IP

    C. Compression

    D. IPX

    E. Multilink

    F. ATX


    参考答案：A, B

  • 第6题：

    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

  • 第7题：

    View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）

    • A、Because the progress is reported for each data file
    • B、Because the progress is reported for each backup set
    • C、Because other RMAN sessions have issued the same BACKUP command
    • D、Because new data files have been added to the database while the RMAN backup is in progress

    正确答案:B

  • 第8题：

    You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）

    • A、to minimize plan regression due to the use of a new optimizer version
    • B、to completely avoid the use of new plans generated by a new optimizer version
    • C、to prevent plan capturing when the SQL statement is executed after the database upgrade
    • D、to keep the plan in the plan history so that it can be used when the older version of the optimizer is used

    正确答案:A

  • 第9题：

    单选题
    View the Exhibit and examine the output of the query in different times when the following command runs in an RMAN sessions: RMAN> BACKUP DATABASE FILESPERSET 2; The database has seven data files. Why is the %_COMPLETE refreshed to 13.59 in the third output after reaching 88.77?（）
    A

    Because the progress is reported for each data file

    B

    Because the progress is reported for each backup set

    C

    Because other RMAN sessions have issued the same BACKUP command

    D

    Because new data files have been added to the database while the RMAN backup is in progress


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

  • 第10题：

    单选题
    View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）
    A

    The database instance is running with manual PGA management.

    B

    The database instance is running with manual shared memory management.

    C

    The database instance has the MEMORY_TARGET value set to a nonzero value.

    D

    All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed


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

  • 第11题：

    单选题
    You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g: 1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade. 2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade. What is the reason for performing these activities? （）
    A

    to minimize plan regression due to the use of a new optimizer version

    B

    to completely avoid the use of new plans generated by a new optimizer version

    C

    to prevent plan capturing when the SQL statement is executed after the database upgrade

    D

    to keep the plan in the plan history so that it can be used when the older version of the optimizer is used


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

  • 第12题：

    单选题
    EXHIBIT, Emp Table Exhibit A Exhibit B Examine the data from the EMP table. Evaluate this SQL statement: SELECT * FROM emp WHERE emp _ id = 3); WHERE commission = (SELECT commission FROM emp What is the result when the query is executed?（）
    A

    Exhibit A

    B

    Exhibit B 

    C

    The query returns no rows 

    D

    The query fails because the outer query is retrieving more than one column

    E

    The query fails because both the inner and outer queries are retrieving data from the same table.


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

  • 第13题：

    You perform the following activities during the database upgrade from Oracle Database 10g to Oracle Database 11g:1. Capture plans for a SQL workload into a SQL Tuning Set (STS) before upgrade.2. Load these plans from the STS into the SQL plan baseline immediately after the upgrade.What is the reason for performing these activities? （）

    A. to minimize plan regression due to the use of a new optimizer version

    B. to completely avoid the use of new plans generated by a new optimizer version

    C. to prevent plan capturing when the SQL statement is executed after the database upgrade

    D. to keep the plan in the plan history so that it can be used when the older version of the optimizer is used


    参考答案：A

  • 第14题：

    Examine the output of the query that you executed to list the objects in the recycle bin:You verified that no table named SALES_TAB exists in the schema. Then you executed the following command to purge the objects in the recycle bin:SQL> PURGE TABLE sales_tab;What would be the outcome of this command?（）

    A. All three tables in the recycle bin are purged

    B. Only the table with the oldest DROPSCN is purged

    C. The command returns an error because multiple entries with the same name exist in the recycle bin

    D. Only the table with the latest DROPSCN is purged


    参考答案：B

  • 第15题：

    Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）

    A. Flashback logging is not enabled for the database.

    B. The changes made to the table are not committed.

    C. Supplemental logging is not enabled for the database.

    D. The database is not configured in ARCHIVELOG mode.


    参考答案：B

  • 第16题：

    Click the Exhibit button and examine the data from the ORDERS and CUSTOMERS tables.Evaluate the SQL statement:SELECT *FROM ordersWHERE cust_id = (SELECT cust_idFROM customersWHERE cust_name = ‘Smith‘);What is the result when the query is executed?（）

    A.A

    B.B

    C.C

    D.D

    E.E


    参考答案：A

  • 第17题：

    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL> CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp； Table dropped.  What happens in this scenario？ （）

    • A、The table is moved to the SYSAUX tablespace.
    • B、The table is moved to the SYSTEM tablespace.
    • C、The table is removed from the database permanently.
    • D、The table is renamed and remains in the TBSFD tablespace.

    正确答案:D

  • 第18题：

    View the Exhibit to examine the output produced by the following query at three different times since thedatabase instance started and has experienced workloads of different capacities：SQL> SELECT substr（component， 0， 10） COMP， current_size CS， user_specified_size US FROM v$memory_dynamic_componentsWHERE current_size!=0；What do you infer from this（）

    • A、The database instance is running with manual PGA management.
    • B、The database instance is running with manual shared memory management.
    • C、The database instance has the MEMORY_TARGET value set to a nonzero value.
    • D、All sessions are connected to the database instance in dedicated mode， and no RMAN or parallel queryoperations have been performed

    正确答案:C

  • 第19题：

    View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）

    • A、 4
    • B、 8
    • C、 7
    • D、 0

    正确答案:A

  • 第20题：

    单选题
    Examine the following commands executed in your database： SQL> ALTER SESSION RECYCLEBIN=ON； Session altered  SQL > CREATE TABLE emp TABLESPACE tbsfd AS SELECT * FROM hr.employees；  Table created.  Further， you executed the following command to drop the table：  SQL> DROP TABLE emp；Table dropped.  What happens in this scenario？（）
    A

    The table is moved to the SYSAUX tablespace.

    B

    The table is moved to the SYSTEM tablespace.

    C

    The table is removed from the database permanently.

    D

    The table is renamed and remains in the TBSFD tablespace.


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

  • 第21题：

    单选题
    To examine the Exhibit, press the Exhibit button. Which option would produce this output from the errpt command? （）
    A

     errpt -t 

    B

     errpt -a 

    C

     errpt -D 

    D

     errpt


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

  • 第22题：

    单选题
    View the Exhibit and examine the output. You execute the following RMAN command to perform the backup operation：   RMAN> RUN { ALLOCATE CHANNEL c1 DEVICE TYPE disk MAXOPENFILES 8； BACKUP DATABASE FILESPERSET 4； }   What is the multiplexing level in the preceding backup process？（）
    A

     4

    B

     8

    C

     7

    D

     0


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

  • 第23题：

    单选题
    A view is created with the following statement:CREATE VIEW v1 AS SELECT col1, col2, col3 FROM t1 WHERE col4 > 1000 ; When will DB2 access the data from table T1 for view V1?（）
    A

    When view V1 is created

    B

    Each time the REFRESH VIEW v1 statement is executed

    C

    Each time an SQL statement is executed against view V1

    D

    Only the first time an SQL statement is executed against view V1


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

相关内容