单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action woul

题目
单选题
Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）
A

Set the STATISTICS_LEVEL initialization parameter to ALL.

B

Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.

C

Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.

D

Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.

相似考题

1.You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference.Which method or feature should you use?()A. Compare Period ADDM reportB. AWR Compare Period reportC. Active Session History (ASH) reportD. Taking a new snapshot and comparing it with a preserved snapshot

2. Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future.  What action would you take to achieve this task？（）A、Set the STATISTICS_LEVEL initialization parameter to ALL.B、Create a baseline on a pair of snapshots that have the statistics of the peak­load period in the database.C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.

3. You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）A、Use the external table population.B、Use the Oracle Data Pump export and import utility.C、Use the conventional path data load of the SQL*Loader utility.D、Use the INSERT INTO...SELECT command to load the data

4. Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would you take to achieve this task（）A、Insert finding directives for ADDM tasks in the future.B、Create a baseline on a pair of snapshots spanning the peak-load period.C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.

更多“单选题Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action woul”相关问题

  • 第1题：

    You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）

    • A、create baseline metrics for today’s performance
    • B、write the current database metrics to a database table and create a trigger to compare with future database statistics
    • C、write the current database metrics to a flat file and create an operating script to compare with future database statistics
    • D、write the current database metrics to a database table and create a procedure to compare with future database statistics
    • E、write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics

    正确答案:A

  • 第2题：

    You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）

    • A、Run Segment Advisor
    • B、Run the SQL Tuning Advisor (STA)
    • C、Run the Automatic Workload Repository (AWR) report
    • D、Run the SQL Access Advisor with a hypothetical workload

    正确答案:D

  • 第3题：

    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

  • 第4题：

    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）

    • A、by using the SQL access advisor
    • B、by using the Automatic Workload Repository report
    • C、by running the Automatic Database Diagnostic Monitor （ADDM）
    • D、by using the Automatic Workload Repository Compare Period report
    • E、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view

    正确答案:D

  • 第5题：

    Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.  What action would you take to achieve this task（）

    • A、Insert finding directives for ADDM tasks in the future.
    • B、Create a baseline on a pair of snapshots spanning the peak-load period.
    • C、Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots

    正确答案:B

  • 第6题：

    You notice a performance change in your production Oracle database and you want to know which change has made this performance difference. You generate the Compare Period Automatic Database Diagnostic Monitor (ADDM) report to further investigation. Which three findings would you get from the report?（）

    • A、It detects any configuration change that caused a performance difference in both time periods.
    • B、It identifies any workload change that caused a performance difference in both time periods.
    • C、It detects the top wait events causing performance degradation.
    • D、It shows the resource usage for CPU, memory, and I/O in both time periods.
    • E、It shows the difference in the size of memory pools in both time periods.
    • F、It gives information about statistics collection in both time periods.

    正确答案:A,B,E

  • 第7题：

    单选题
    You find today’s performance of your production database to be the best ever. Therefore， you want to be notified in the future whenever the performance degrades by 10% of today’s performance. What is the first step that you would take to ensure this？（）
    A

    create baseline metrics for today’s performance

    B

    write the current database metrics to a database table and create a trigger to compare with future database statistics

    C

    write the current database metrics to a flat file and create an operating script to compare with future database statistics

    D

    write the current database metrics to a database table and create a procedure to compare with future database statistics

    E

    write the current database metrics to a database table and submit a job using DBMS_JOB to compare with future database statistics


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

  • 第8题：

    单选题
    Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）
    A

    Set the STATISTICS_LEVEL initialization parameter to ALL.

    B

    Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.

    C

    Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.

    D

    Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.


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

  • 第9题：

    单选题
    The application workload on your database is same between 10 a.m. and 11 a.m. on weekdays. Suddenly you observe poor performance between 10 a.m. and 11 a.m. in the middle of the week. How would you identify the changes in configuration settings， workload profile， and statistics to diagnose the possible causes of the performance degradation？（）
    A

    by using the SQL access advisor

    B

    by using the Automatic Workload Repository report

    C

    by running the Automatic Database Diagnostic Monitor （ADDM）

    D

    by using the Automatic Workload Repository Compare Period report

    E

    by analyzing the output of the V$ACTIVE_SESSION_HISTORY view


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

  • 第10题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data.


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

  • 第11题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables.  While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）
    A

    use the external table population

    B

    use the Oracle Data Pump export and import utility

    C

    use the conventional path data load of SQL*Loader utility

    D

    use the direct path data load of Oracle export and import utility


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

  • 第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 notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

    • A、Compare Period ADDM report
    • B、AWR Compare Period report
    • C、Active Session History (ASH) report
    • D、Taking a new snapshot and comparing it with a preserved snapshot

    正确答案:B

  • 第14题：

    You work as a database administrator for Certkiller .com. In your database server， the parameter PLSQL_OPTIMIZE_LEVEL has been set to 2. What would this setting achieve？（）

    • A、It degrades the run time and compiler performance.
    • B、It provides better run time and compiler performance.
    • C、It provides better optimization of the statement during parse time.
    • D、It forces the rule based optimizer to be used for statement optimization.
    • E、It provides better run time performance but slightly degraded compiler performance. 
    • F、It provides better run time performance but slightly degraded run time performance.

    正确答案:E

  • 第15题：

    You are using flat files as the data source for one of your data warehousing applications. To optimizethe application performance， you plan to move the data from the flat files toclustered tablesin an Oracle database.  While migrating the data， you want to have minimal impact on the database performance and optimize thedata load operation. Which method would you use to load data into the Oracle database（）

    • A、Use the external table population.
    • B、Use the Oracle Data Pump export and import utility.
    • C、Use the conventional path data load of the SQL*Loader utility.
    • D、Use the INSERT INTO...SELECT command to load the data.

    正确答案:C

  • 第16题：

    You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data， you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database？（）

    • A、use the external table population
    • B、use the Oracle Data Pump export and import utility
    • C、use the conventional path data load of SQL*Loader utility
    • D、use the direct path data load of Oracle export and import utility

    正确答案:C

  • 第17题：

    Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of thedatabase in the future. What action would you take to achieve this task？（）

    • A、Set the STATISTICS_LEVEL initialization parameter to ALL.
    • B、Create a baseline on a pair of snapshots that have the statistics of the peak-load period in the database.
    • C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak-load period.
    • D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid the automatic purging of the snapshots.

    正确答案:B

  • 第18题：

    单选题
    Your database is functional with a peak load for the last one hour. You want to preserve theperformance statistics collected during this period to be used for comparison when you analyze theperformance of the database in the future.  What action would you take to achieve this task（）
    A

    Insert finding directives for ADDM tasks in the future.

    B

    Create a baseline on a pair of snapshots spanning the peak-load period.

    C

    Decrease the snapshot interval in the AWR to collect more snapshots during the peak-load period.

    D

    Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automatic purging of snapshots.


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

  • 第19题：

    多选题
    You are a database administrator for your company. The company uses a SQL Server 2005 application. Each night， data is imported into a database， and the database is then set to be read-only. During business hours， users run predefined and ad hoc queries. You need to monitor the servers performance during the day. What are two possible ways to achieve this goal？（）
    A

    Use the Lock Waits/sec performance counter.

    B

    Use the Number of Deadlocks/sec performance counter.

    C

    Use the Transactions/sec performance counter.

    D

    Use the Full Scans/sec performance counter.

    E

    Use the Batches/sec performance counter.


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

  • 第20题：

    单选题
    You work with a newly created database. Presently, there is no application load on the database instance.You want to create a baseline for tuning the application, so you decide to collect recommendations that can be implemented to improve application performance.What action must you take to achieve this?（）
    A

    Run Segment Advisor

    B

    Run the SQL Tuning Advisor (STA)

    C

    Run the Automatic Workload Repository (AWR) report

    D

    Run the SQL Access Advisor with a hypothetical workload


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

  • 第21题：

    单选题
    Your database is functional with peak load for one hour. You want to preserve the performance statistics collected during this period so that they can be used for comparison while analyzing the performance of the database in the future.  What action would you take to achieve this task？（）
    A

    Set the STATISTICS_LEVEL initialization parameter to ALL.

    B

    Create a baseline on a pair of snapshots that have the statistics of the peak­load period in the database.

    C

    Decrease the snapshot interval in the AWR to collect more number of snapshots during the peak­load period.

    D

    Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.


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

  • 第22题：

    单选题
    You are using flat files as the data source for one of your data warehousing applications. To optimize the application performance， you plan to move the data from the flat files to clustered tables in an Oracle database.While migrating the data， you want to have minimal impact on the database performance and optimize the dataload operation.  Which method would you use to load data into the Oracle database（）
    A

    Use the external table population.

    B

    Use the Oracle Data Pump export and import utility.

    C

    Use the conventional path data load of the SQL*Loader utility.

    D

    Use the INSERT INTO...SELECT command to load the data


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

  • 第23题：

    单选题
    You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）
    A

    Compare Period ADDM report

    B

    AWR Compare Period report

    C

    Active Session History (ASH) report

    D

    Taking a new snapshot and comparing it with a preserved snapshot


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

  • 第24题：

    单选题
    Your database is functional with a peak load for the last one hour. You want to preserve the performancestatistics collected during this period to be used for comparison when you analyze the performance of thedatabase in the future.  What action would you take to achieve this task（）
    A

    Insert finding directives for ADDM tasks in the future.

    B

    Create a baseline on a pair of snapshots spanning the peak-load period.

    C

    Decrease the snapshot interval in the AWR to collect more snapshots during the peak- load period.

    D

    Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid automaticpurging of snapshots


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

相关内容