单选题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.
单选题
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 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
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).
Which three statements are true about Automatic Workload Repository (AWR)?() A. All AWR tables belong to the SYSTEM schema.B. The AWR data is stored in memory and in the database.C. The snapshots collected by AWR are used by the self-tuning components in the databaseD. AWR computes time model statistics based on time usage for activities, which are displayed in the v$SYS time model and V$SESS_TIME_MODEL views.E. AWR contains system wide tracing and logging information.
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
Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）A、The ADDM requires at least four AWR snapshots for analysis.B、The ADDM runs after each AWR snapshot is collected automatically by MMON.C、The results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.D、The ADDM analysis provides only diagnostic information but does not provide recommendations.E、The ADDM calls other advisors if required， but does not provide recommendations about the advisors.
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 advisorB、by using the Automatic Workload Repository reportC、by running the Automatic Database Diagnostic Monitor （ADDM）D、by using the Automatic Workload Repository Compare Period reportE、by analyzing the output of the V$ACTIVE_SESSION_HISTORY view
Which two statements are true about the Automatic Diagnostic Repository （ADR）？（） A、 The ADR base keeps all diagnostic information in binary formatB、 SQL*Plus provides the ADRI script， which can be used to work with ADRC、 The ADR can be used for problem diagnosis only when the database is openD、 The ADR can be disabled by settting the DIAGNOSTIC_DEST parameter to nullE、 The ADR can be used for problem diagnosis even when the database instance is downF、 The ADR base is shared across multiple instances
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 about the Manageability Monitor （MMON） background proces（）A、It transfers statistics from memory to disk at regular intervals.B、It coordinates the rebalance activity for disk groups when ASM is used.C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.
Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository （ADR）？（） A、 The incident metadata is purged when the problem is resolved and the DBA closes the SRB、 The incident files and dumps are not retained in the ADR for the manually created incidents C、 The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD、 The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?（）A、The incident metadata is purged when the problem is resolved and the DBA closes the SRB、The incident files and dumps are not retained in the ADR for the manually created incidentsC、The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD、The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
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）.
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.
Observe the following warning in an RMAN session of your database instance： WARNING:// new failures were found since last LIST FAILURE command Which statement describes the scenario that must have produced this warning？（）A、 The CHANGE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository（ADR）B、 The VALIDATE DATABASE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR）C、 The ADVISE FAILURE command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURED、 The RECOVER command has detected new failures recorded in the Automatic Diagnostic Repository （ADR） since the last LIST FAILURE command was executed
单选题Which statement is true regarding the retention policy for the incidents accumulated in the Automatic Diagnostic Repository （ADR）？（）A The incident metadata is purged when the problem is resolved and the DBA closes the SRB The incident files and dumps are not retained in the ADR for the manually created incidents C The incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRD The default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
多选题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
单选题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？（）Aby using the SQL access advisorBby using the Automatic Workload Repository reportCby running the Automatic Database Diagnostic Monitor （ADDM）Dby using the Automatic Workload Repository Compare Period reportEby analyzing the output of the V$ACTIVE_SESSION_HISTORY view
多选题Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（）ABACKGROUND_DUMP_DESTBFOREGROUND_DUMP_DESTCCORE_DUMP_DESTDUSER_DUMP_DESTEDIAGNOSTIC_DESTFAll of the above
多选题Which two statements are true about the Automatic Database Diagnostic Monitor （ADDM）（）AThe ADDM requires at least four AWR snapshots for analysis.BThe ADDM runs after each AWR snapshot is collected automatically by MMON.CThe results of the ADDM analysis are stored in the Automatic Workload Repository （AWR）.DThe ADDM analysis provides only diagnostic information but does not provide recommendations.EThe ADDM calls other advisors if required， but does not provide recommendations about the advisors.
单选题Which statement is true when Automatic Workload Repository (AWR) baselines are created using baseline templates?（）AAWR baselines are always created as repeating baselines.BAWR baselines can be created on the basis of two time values.CAWR baselines are always created with infinite expiration duration.DAWR baselines are always created using the Automatic Workload Repository (AWR) retention period as expirationduration.
单选题Which statement is true regarding the retention policy for the incidents accumulated in the AutomaticDiagnostic Repository (ADR)?（）AThe incident metadata is purged when the problem is resolved and the DBA closes the SRBThe incident files and dumps are not retained in the ADR for the manually created incidentsCThe incident files are retained but the incident metadata is purged when the problem is resolved and the DBA closes the SRDThe default setting is for one year after which the incident metadata is purged from the ADR and the files are retained for one month
多选题Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g?（）AIt does not allow you to change the moving window size.BAdaptive threshold functionalities use it by default to compute statistics.CIt is created by default with the window size being equal to the AWR retention time.DIt is created when the first snapshot is collected by the Automatic Workload Repository (AWR).
单选题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.
单选题Which statement is true about the Manageability Monitor （MMON） background process（）AIt transfers statistics from memory to disk at regular intervals.BIt coordinates the rebalance activity for disk groups when ASM is used.CIt communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.DIt performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance
多选题Which two statements are true about the Automatic Workload Repository （AWR）（）AAll AWR tables belong to the SYSTEM schema.BThe AWR contains systemwide tracing and logging information.CThe snapshots collected by the AWR are accessible through data dictionary views.DThe snapshots collected by the AWR are used by self-tuning components in the database.