Oracle认证考试
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（） A、 BACKGROUND_DUMP_DESTB、 FOREGROUND_DUMP_DESTC、 CORE_DUMP_DESTD、 USER_DUMP_DESTE、 DIAGNOSTIC_DESTF、 Al
题目
Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（）
- A、 BACKGROUND_DUMP_DEST
- B、 FOREGROUND_DUMP_DEST
- C、 CORE_DUMP_DEST
- D、 USER_DUMP_DEST
- E、 DIAGNOSTIC_DEST
- F、 All of the above
相似问题和答案
第1题：
Examine the following values of the initialization parameters in the database having the SID ORCL:BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdumpUSER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udumpCORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdumpDIAGNOSTIC_DEST=The environment variables have the following value:ORACLE_BASE=/u01/app/oracleORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1What is the location of the Automatic Diagnostic Repository (ADR) home?（）
A./u01/app/oracle/product/11.1.0/db_1
B./u01/app/oracle
C.$ORACLE_HOME/bdump
D.$ORACLE_HOME/log
第2题：
In an Oracle 10g database， the in-memory statistics are gathered at regular intervals and used to perform growth-trend analysis and capacity planning of the database. Which component stores these statistics？（）
- A、 Recovery catalog
- B、 Oracle Enterprise Manager Repository
- C、 Automatic Workload Repository （AWR）
- D、 Oracle 10g Enterprise Manager Grid Control
- E、 Automatic Database Diagnostic Monitor （ADDM）
正确答案:C
第3题：
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 BASIC
B. The moving window size must be less than Undo Retention
C. The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
D. The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
第4题：
In an Oracle 10g database， the in/x7fmemory statistics are gathered at regular intervals and used to perform growth/x7ftrend analysis and capacity planning of the database. Which component stores these statistics？（）
- A、recovery catalog
- B、Oracle Enterprise Manager Repository
- C、Automatic Workload Repository （AWR）
- D、Oracle 10g Enterprise Manager Grid Control
- E、Automatic Database Diagnostic Monitor （ADDM）
正确答案:A
第5题：
You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page. Which two links should you click to go to the Memory Advisor page？（）
- A、 Advisor Central
- B、 Global Attributes
- C、 Resource Monitors
- D、 Memory Parameters
- E、 Database Usage Statistics
- F、 All Initialization Parameters
- G、 Automatic Workload Repository
正确答案:A,C
第6题：
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 BASIC
- B、The moving window size must be less than Undo Retention
- C、The moving window size should be greater than the Automatic Workload Repository (AWR) retention period
- D、The moving window size should be equal to or less than the Automatic Workload Repository (AWR) retention period
正确答案:D
第7题：
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.
正确答案:D
第8题：
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).
第9题：
The Automatic Shared Memory Management feature is enabled for the PROD database. Currently， a lot of insert activity is taking place in the database， and the memory structures are allocated according to the database workload. As the workload reduces， you decide to perform batch jobs in the database. Which of the following initialization parameters are NOT automatically resized according to the new workload and continue to remain unchanged？（）
- A、 LOG_BUFFER
- B、 DB_CACHE_SIZE
- C、 JAVA_POOL_SIZE
- D、 LARGE_POOL_SIZE
- E、 SHARED_POOL_SIZE
- F、 STREAMS_POOL_SIZE
正确答案:A,F
第10题：
Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/udump CORE_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/cdump DIAGNOSTIC_DEST= The environment variables have the following value: ORACLE_BASE=/u01/app/oracle ORACLE_HOME=/u01/app/oracle/product/11.1.0/db_1 What is the location of the Automatic Diagnostic Repository (ADR) home?（）
- A、/u01/app/oracle/product/11.1.0/db_1
- B、/u01/app/oracle
- C、$ORACLE_HOME/bdump
- D、$ORACLE_HOME/log
正确答案:B