单选题You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to supp

题目
单选题
You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments.  What would you do to achieve this？（）
A

 Add a finding directive for the ADDM task.

B

 Add a segment directive for the ADDM task.

C

 Add a parameter directive for the ADDM task.

D

 Disable the Segment Advisor from the Automatic Maintenance Task.

相似考题

1.You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?（）A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.

2.View the Exhibit to examine the Automatic Database Diagnostic Monitor (ADDM) tasks.Which statement describes the consequence?()A. The ADDM task is filtered to suppress the Segment Advisor suggestions for the SCOTT schema.B. The ADDM task is filtered to produce the Segment Advisor suggestions for the SCOTT schema only.C. The PL/SQL block produces an error because the my_instance_analysis_mode_task task has not been reset to its initial state.D. All subsequent ADDM tasks including my_instance_analysis_mode_task are filtered to suppress the Segment Advisor suggestions for the SCOTT schema.

3.You executed the following PL／SQL block successfully:The above command produces Automatic Database Diagnostic Monitor (ADDM) analysis.()A. with the CPU Usage finding if it is less than 90B. without the CPU Usage finding if it is less than 90C. with the CPU Usage finding for snapshots below 90D. with the CPU Usage finding for snapshots not between 150 and 162

4.You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.How would you accomplish this task?（）A. Set metric thresholdB. Implement Database Resource ManagerC. Enable resumable timeout for user sessionsD. Add directives to Automatic Database Diagnostic Monitor (ADDM)

更多“单选题You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to suppr”相关问题

  • 第1题：

    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests.For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING.What should you do to accomplish this task?（）

    A. Execute the query and view Active Session History (ASH) for information about the query.

    B. Enable SQL trace for the query.

    C. Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D. Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


    参考答案：C

  • 第2题：

    You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）

    • A、Set metric threshold
    • B、Implement Database Resource Manager
    • C、Enable resumable timeout for user sessions
    • D、Add directives to Automatic Database Diagnostic Monitor (ADDM)

    正确答案:B

  • 第3题：

    The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）

    • A、Create two custom ADDM tasks.
    • B、Modify the AWR snapshot time interval to two hours.
    • C、Create a new scheduler window for a time period of two hours.
    • D、Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.

    正确答案:B

  • 第4题：

    You executed the following PL/SQL block successfully：   VARIABLE tname VARCHAR2（20）  BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；  ：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）；  END； /    Then you executed the following command：   SQL> SELECT dbms_addm.get_report（：tname） FROM DUAL；   The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）

    • A、 with the CPU Usage finding if it is less than 90
    • B、 without the CPU Usage finding if it is less than 90
    • C、 with the CPU Usage finding for snapshots below 90
    • D、 with the CPU Usage finding for snapshots not between 150 and 162

    正确答案:B

  • 第5题：

    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）

    • A、Execute the query and view Active Session History (ASH) for information about the query.
    • B、Enable SQL trace for the query.
    • C、Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.
    • D、Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.

    正确答案:C

  • 第6题：

    You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）

    • A、Enable Memory Access Mode, which reads performance data from SGA.
    • B、Use emergency monitoring to fetch data directly from SGA analysis.
    • C、Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.
    • D、Use Active Session History (ASH) data and hang analysis in regular performance monitoring.
    • E、Run ADDM in diagnostic mode.

    正确答案:B

  • 第7题：

    单选题
    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）
    A

    run Segment Advisor

    B

    run SQL Tuning Advisor on top SQL statements

    C

    run the Automatic Workload Repository （AWR） report

    D

    run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements


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

  • 第8题：

    单选题
    You work in a data warehouse environment that involves the execution of complex queries. The current content of the SQL cache holds the ideal workload for analysis. You want to analyze only few most resource-intensive statements. What would be your suggestion to receive recommendations on the efficient use of indexes and materialized views to improve query performance？（）
    A

    Run the SQL Access Advisor.

    B

    Run the SQL Tuning Advisor （STA）.

    C

    Run the Automatic Workload Repository （AWR） report.

    D

    Run the Automatic Database Diagnostic Monitor （ADDM）.


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

  • 第9题：

    单选题
    The Automatic Database Diagnostic Monitor (ADDM) analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future. What would you do?（）
    A

    Create two custom ADDM tasks.

    B

    Modify the AWR snapshot time interval to two hours.

    C

    Create a new scheduler window for a time period of two hours.

    D

    Modify the Automatic Workload Repository (AWR) snapshot retention period to two hours.


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

  • 第10题：

    单选题
    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Access Advisor

    D

     Automatic Workload Repository （AWR）

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第11题：

    单选题
    You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time. How would you accomplish this task?（）
    A

    Set metric threshold

    B

    Implement Database Resource Manager

    C

    Enable resumable timeout for user sessions

    D

    Add directives to Automatic Database Diagnostic Monitor (ADDM)


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

  • 第12题：

    单选题
    You notice that the performance of your production 24/7 Oracle database significantly degraded.Sometimes you are not able to connect to the instance because it hangs. You do not want to restart thedatabase instance.How can you detect the cause of the degraded performance?（）
    A

    Enable Memory Access Mode, which reads performance data from SGA.

    B

    Use emergency monitoring to fetch data directly from SGA analysis.

    C

    Run Automatic Database Diagnostic Monitor (ADDM) to fetch information from the latest Automatic Workload Repository (AWR) snapshots.

    D

    Use Active Session History (ASH) data and hang analysis in regular performance monitoring.

    E

    Run ADDM in diagnostic mode.


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

  • 第13题：

    You are the administrator of a SQL Server 2000 computer in your company's personnel department. Employee data is stored in a SQL Server 2000 database. A portion of the database schema is shown in the exhibit.

    You want to create a text file that lists these data columns in the following format title, FirstName, LastName, WorkPhone, PositionName, DepartmentName.

    You want to create the text file as quickly as possible. You do not expect to re-create this file, and you want to avoid creating new database objects if possible.

    What should you do?

    A．Use the bcp utility to export data from each table to a separate text file. Use format files to select the appropriate columns. Merge the data from each text file into a single text file.

    B．Create a view that joins data from all three tables include only the columns you want to appear in the text file. Use the bcp utility to export data from the view.

    C．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a local temporary table. Use the bcp utility to export data from the local temporary table to a text file.

    D．Create a SELECT query that joins the data from the appropriate columns in the three tables. Add an INTO clause to the query to create a global temporary table. Use the bcp utility to export data from the global temporary table to a text file.


    正确答案：D
    解析：Explanation:Asthecolumnsthatwewantinthetextfileareondifferenttablesinthedatabase,wewouldhavetocombinethecolumnintoatableorview.Becausewewillnotneedtoreproducethefile,wecanwecancombinethecolumnfromthevarioustablesintoaglobaltemporarytablebyusingtheSELECTINTOstatement.Thenweusethebcputilitytoexportthedatafromtheglobaltemporaryfiletoatextfile.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.Ifglobaltemporarytablesarenotdroppedexplicitlybeforetheconnectionthatcreatedthemdisconnects,theyaredroppedassoonasallothertasksstopreferencingthem.Nonewtaskscanreferenceaglobaltemporarytableaftertheconnectionthatcreateditdisconnects.ThebcputilitycopiesdatabetweenaninstanceofSQLServer2000andadatafileinauser-specifiedformat.ItcanbeusedtotransferdatafromaSQLServertabletoadatafileforuseinotherprograms.Furthermore,datacanalsobetransferredoutbyspecifyingaSELECTstatement.Thebcputilitycanuseglobaltemporarytables,butnotlocaltemporarytables.IncorrectAnswers:A:CreatingaglobaltemporarytablebyusingtheSELECTstatementandusingthebcputilitytoexportdatafromthattablewouldrequirelessadministrativeeffortthanusingbcptoexporttherequiredcolumnsfromeachtableintoaseparatetextfileandthenmergingthosetextfilesintoasingletextfile.B:Becausewewouldnotneedtore-createthedatafileagain,itwouldbeeasiertousetheSELECTstatementtocreateaglobaltemporarytableasthesetablesaredroppedautomaticallywhennothingreferencethem.C:Thebcputilitycannotuselocaltemporarytables.Note:Temporarytablesarenotstoredinthecurrentdatabase;theyarestoredinthetempdbsystem.Therearetwotypesoftemporarytables:localtemporarytables,whicharevisibleonlytotheconnectionthatcreatedthem,andglobaltemporarytables,thatarevisibletoallconnections.

  • 第14题：

    Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）

    • A、 Enterprise Manager GUI
    • B、 DBMS_TRACE package APIs
    • C、 DBMS_ADVISOR package APIs
    • D、 DBMS_MONITOR package APIs
    • E、 $ORACLE_HOME/rdbms/admin/addmrpt.sql script

    正确答案:A,C,E

  • 第15题：

    You observe that database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks.  Which advisory component would you refer to， in order to determine the required size of the database buffer cache？（） 

    • A、Memory Advisor
    • B、Segment Advisor
    • C、SQL Tuning Advisor
    • D、SQL Access Advisor
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:A

  • 第16题：

    You work as a database administrator for Certkiller .com. You find that reports are running for a long time in your data warehousing applications. You suspect a lack of indexes is the reason for the performance degradation.  Which advisory component would you refer to， in order to determine the appropriate indexes？（）

    • A、Memory Advisors
    • B、Segment Advisors
    • C、SQL Tuning and Access Advisors
    • D、Automated Workload Repository （AWR）
    • E、Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第17题：

    You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to， in order to determine the appropriate indexes？（）

    • A、 Memory Advisor
    • B、 Segment Advisor
    • C、 SQL Access Advisor
    • D、 Automatic Workload Repository （AWR）
    • E、 Automatic Database Diagnostic Monitor （ADDM）

    正确答案:C

  • 第18题：

    You create a new Automatic Database Diagnostic Monitor （ADDM） task：  instance_analysis_mode_task. To view the ADDM report， you use the following command：   SQL> SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual；   You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments.  What would you do to achieve this？（）

    • A、 Add a finding directive for the ADDM task.
    • B、 Add a segment directive for the ADDM task.
    • C、 Add a parameter directive for the ADDM task.
    • D、 Disable the Segment Advisor from the Automatic Maintenance Task.

    正确答案:B

  • 第19题：

    单选题
    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）
    A

    Execute the query and view Active Session History (ASH) for information about the query.

    B

    Enable SQL trace for the query.

    C

    Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D

    Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


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

  • 第20题：

    单选题
    You observe that a database performance has degraded over a period of time. While investigating the reason， you find that the size of the database buffer cache is not large enough to cache all the needed data blocks. Which advisory component would you refer to， in order to determine that required size of the database buffer cache？ （）
    A

     Memory Advisor

    B

     Segment Advisor

    C

     SQL Tuning Advisor

    D

     SQL Access Advisor

    E

     Automatic Database Diagnostic Monitor （ADDM）


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

  • 第21题：

    单选题
    You executed the following PL/SQL block successfully：   VARIABLE tname VARCHAR2（20）  BEGIN dbms_addm.insert_finding_directive （NULL， DIR_NAME=>’Detail CPU Usage’， FINDING_NAME=>’CPU Usage’， MIN_ACTIVE_SESSIONS=>0， MIN_PERC_IMPACT=>90）；  ：tname ：= ’database ADDM task4’； dbms_addm.analyze_db（：tname， 150， 162）；  END； /    Then you executed the following command：   SQL> SELECT dbms_addm.get_report（：tname） FROM DUAL；   The above command produces Automatic Database Diagnostic Monitor （ADDM） analysis（）
    A

     with the CPU Usage finding if it is less than 90

    B

     without the CPU Usage finding if it is less than 90

    C

     with the CPU Usage finding for snapshots below 90

    D

     with the CPU Usage finding for snapshots not between 150 and 162


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

  • 第22题：

    单选题
    You plan to control idle sessions that are blocking other sessions from performing transactions. Your requirement is to automatically terminate these blocking sessions when they remain idle for a specified amount of time.  How would you accomplish this task？（）
    A

     Set metric threshold

    B

     Implement Database Resource Manager

    C

     Enable resumable timeout for user sessions

    D

     Add directives to Automatic Database Diagnostic Monitor （ADDM）


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

  • 第23题：

    单选题
    The Automatic Database Diagnostic Monitor （ADDM） analysis runs every 60 minutes on your database. Your database is facing a series of interrelated problems over a period of two hours. You need to ensure that the ADDM analysis is run over a time span of two hours in future.  What would you do？（）
    A

     Create two custom ADDM tasks.

    B

     Modify the AWR snapshot time interval to two hours.

    C

     Create a new scheduler window for a time period of two hours.

    D

     Modify the Automatic Workload Repository （AWR） snapshot retention period to two hours.


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

相关内容