网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）
A
Compute the baseline statistics.
B
Take an immediate AWR snapshot.
C
Decrease the window size for the baseline.
D
Decrease the expiration time for the baseline.
参考答案
参考解析
解析：
暂无解析
更多 “单选题You plan to set up the Automatic Workload Repository （AWR） baseline metric thresholds for a moving window baseline. Which action would you take before performing this task？（）A Compute the baseline statistics.B Take an immediate AWR snapshot.C Decrease the window size for the baseline.D Decrease the expiration time for the baseline.” 相关考题
考题
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A. The collection level for the AWR should be set to BASICB. The moving window size must be less than Undo RetentionC. The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
考题
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?()
A. Compute the baseline statistics.B. Take an immediate AWR snapshot.C. Decrease the window size for the baseline.D. Decrease the expiration time for the baseline.
考题
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.()
A. Cursor cacheB. Stored outlineC. SQL Tuning SetD. Automatic Workload Repository (AWR) snapshots
考题
You plan to have a larger moving window size for the default system-defined moving window baseline because you want to use the adaptive threshold. Which statement factors in this consideration while increasing the size of the moving window?（）A、The collection level for the AWR should be set to BASICB、The moving window size must be less than Undo RetentionC、The moving window size should be greater than the Automatic Workload Repository (AWR) retention periodD、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
考题
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.
考题
You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?（）A、Compute the baseline statistics.B、Take an immediate AWR snapshot.C、Decrease the window size for the baseline.D、Decrease the expiration time for the baseline.
考题
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 peakload period in the database.C、Decrease the snapshot interval in the AWR to collect more number of snapshots during the peakload period.D、Set the snapshot retention period in the Automatic Workload Repository （AWR） to zero to avoid theautomatic purging of the snapshots.
考题
You plan to collect the Automatic Workload Repository （AWR） data every Monday morning for a month. You want Oracle Database to automatically create a baseline every Monday and remove the old baseline. What is the correct action to achieve this？（） A、 Create and populate a SQL Tuning Set from the AWR on every Monday.B、 Change the RETENTION setting for the AWR snapshots to 7 days on Monday.C、 Create a repeating baseline template.D、 Insert a finding directive for future ADDM tasks.
考题
Which two statements are true about the Automatic Workload Repository （AWR）（）A、All AWR tables belong to the SYSTEM schema.B、The AWR contains systemwide tracing and logging information.C、The snapshots collected by the AWR are accessible through data dictionary views.D、The snapshots collected by the AWR are used by self-tuning components in the database.
考题
Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）A、AWR baselines are always created as repeating baselines.B、AWR baselines can be created on the basis of two time values.C、AWR baselines are always created with infinite expiration duration.D、AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expirationduration.
考题
In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）A、The optimizer statistics are collected automatically.B、Only the timed operating system （OS） statistics and plan execution statistics are collected.C、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.D、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. E、Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
考题
Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（） A、 AWR baselines are always created as repeating baselines.B、 AWR baselines can be created on the basis of two time values.C、 AWR baselines are always created with infinite expiration duration.D、 AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.
考题
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 AdvisorB、Segment AdvisorC、SQL Access AdvisorD、Automatic Workload Repository （AWR）E、Automatic Database Diagnostic Monitor （ADDM）
考题
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）.
考题
Identify the two direct sources from where SQL plans can be loaded into the SQL plan baselines.（）A、Cursor cacheB、Stored outlineC、SQL Tuning SetD、Automatic Workload Repository (AWR) snapshots
考题
The following command is executed to create the baseline template： SQL EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME= TO_TIESTAMP（SYSDATE+2）， END_TIME=TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=’Mybase4’， TEMPLATE_NAME=’Mytemp4’， EXPIRATION=NULL）； Which statement is true about the effect of the above command？（） A、 It creates a baseline template that never expires.B、 It produces an error because no snapshot information is provided to create the baseline.C、 It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.D、 It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.
考题
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
考题
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.
考题
The system was running a normal workload during the last 24 hours. You need to ensure that with the same workload you should be able to flashback tables by three hours. What would you do to find the system recommendations for the undo retention period and the undo tablespace size?（）A、set DB_FLASHBACK_RETENTION_TARGET=10800 B、create a new scheduler window for the time period of 24 hours and use the optimizer statistics C、modify the Automatic Workload Repository (AWR) snapshot time interval to three hours and use ADDMfindings D、specify New Undo Retention as three hours and Analysis Time period as Last One Day in the Undo Advisor page and use its recommendations
考题
In your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What isthe impact of this setting（）A、Optimizer statistics are collected automatically.B、Only timed operating system （OS） statistics and plan execution statistics are collected.C、The snapshots for the Automatic Workload Repository （AWR） are not generated automatically.D、Snapshots cannot be collected manually by using the DBMS_WORKLOAD_REPOSITORY package.E、The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.
考题
单选题Which statement is true when Automatic Workload Repository （AWR） baselines are created using baseline templates？（）A
AWR baselines are always created as repeating baselines.B
AWR baselines can be created on the basis of two time values.C
AWR baselines are always created with infinite expiration duration.D
AWR baselines are always created using the Automatic Workload Repository （AWR） retention period as expiration duration.
考题
多选题You work as a database administrator for Supportcenter.cn. You have set the retention period for Automatic Repository （AWR） statistics to four days and collection interval to 15 minutes. You want to view the statistics collected and stored in AWR snapshot. Which two methods would you use to view the AWR statistics？（）Ause enterprise managerBuse DBMS_SQL packageCuse DBMS_AWR packageDuse PRVT_WORKLOAD packageEquery the AWR snapshot repository objectsFuse DBMS_WORKLOAD_REPOSITORY package
考题
单选题Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）A
AWR baselines are always created as repeating baselines.B
AWR baselines can be created on the basis of two time values.C
AWR baselines are always created with infinite expiration duration.D
AWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expirationduration.
考题
单选题In your database，the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）A
The optimizer statistics are collected automatically.B
Only the timed operating system （OS） statistics and plan execution statistics are collected.C
The Oracle server dynamically generates the necessary statistics on tables as part of query optimization.D
The snapshots for the Automatic Workload Repository （AWR） are not generated automatically. E
Snapshots cannot be collected manually by using DBMS_WORKLOAD_REPOSITORY PACKAGE.
考题
单选题You plan to set up the Automatic Workload Repository (AWR) baseline metric thresholds for a moving window baseline. Which action would you take before performing this task?（）A
Compute the baseline statistics.B
Take an immediate AWR snapshot.C
Decrease the window size for the baseline.D
Decrease the expiration time for the baseline.
考题
单选题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 AdvisorB
Run the SQL Tuning Advisor （STA）C
Run the Automatic Workload Repository （AWR） reportD
Run the SQL Access Advisor with a hypothetical workload
考题
单选题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 AdvisorB
Segment AdvisorC
SQL Access AdvisorD
Automatic Workload Repository （AWR）E
Automatic Database Diagnostic Monitor （ADDM）
热门标签
最新试卷
