网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
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
参考答案
更多 “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、 All of the above” 相关考题
考题
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).
考题
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_1B./u01/app/oracleC.$ORACLE_HOME/bdumpD.$ORACLE_HOME/log
考题
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
考题
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 catalogB、 Oracle Enterprise Manager RepositoryC、 Automatic Workload Repository （AWR）D、 Oracle 10g Enterprise Manager Grid ControlE、 Automatic Database Diagnostic Monitor （ADDM）
考题
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 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 CentralB、 Global AttributesC、 Resource MonitorsD、 Memory ParametersE、 Database Usage StatisticsF、 All Initialization ParametersG、 Automatic Workload Repository
考题
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_BUFFERB、 DB_CACHE_SIZEC、 JAVA_POOL_SIZED、 LARGE_POOL_SIZEE、 SHARED_POOL_SIZEF、 STREAMS_POOL_SIZE
考题
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 catalogB、Oracle Enterprise Manager RepositoryC、Automatic Workload Repository （AWR）D、Oracle 10g Enterprise Manager Grid ControlE、Automatic Database Diagnostic Monitor （ADDM）
考题
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_1B、/u01/app/oracleC、$ORACLE_HOME/bdumpD、$ORACLE_HOME/log
考题
For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
The production database has been functional for the last seven days. Because of application requirements， some of the initialization parameters were changed during run time without any comments. You have been asked to find out the value of the parameters when the instance was started. Which source would you use to locate this information？（）A、fixed viewsB、the alert log fileC、the parameter fileD、the server parameter fileE、dynamic performance views
考题
Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（） A、 Automatic PGA Memory ManagementB、 Automatic SGA Memory ManagementC、 Automatic Shared Memory ManagementD、 Automatic Memory ManagementE、 Manual SGA Memory ManagementF、 None of the above
考题
You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A、 INSTANCE_TYPEB、 DB_UNIQUE_NAMEC、 ASM_DISKSTRINGD、 ASM_POWER_LIMIT
考题
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.
考题
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_1B、 /u01/app/oracleC、 $ORACLE_HOME/bdumpD、 $ORACLE_HOME/log
考题
in your database instance， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impactof 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 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
考题
多选题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？（）AAdvisor CentralBGlobal AttributesCResource MonitorsDMemory ParametersEDatabase Usage StatisticsFAll Initialization ParametersGAutomatic Workload Repository
考题
多选题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.
考题
单选题You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）A
INSTANCE_TYPEB
DB_UNIQUE_NAMEC
ASM_DISKSTRINGD
ASM_POWER_LIMIT
考题
多选题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？（）ALOG_BUFFERBDB_CACHE_SIZECJAVA_POOL_SIZEDLARGE_POOL_SIZEESHARED_POOL_SIZEFSTREAMS_POOL_SIZE
考题
多选题Automatic PGA Memory Management eliminates the need to manually configure which of the following initialization parameters？（）ASORT_AREA_SIZEBHASH_AREA_SIZECBITMAP_MERGE_AREA_SIZEDCREATE_BITMAP_AREA_SIZEEPGA_AGGREGATE_TARGET
考题
单选题For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
考题
单选题Which of the following Oracle features is enabled by setting a nonzero value for the MEMORY_TARGET initialization parameter？（）A
Automatic PGA Memory ManagementB
Automatic SGA Memory ManagementC
Automatic Shared Memory ManagementD
Automatic Memory ManagementE
Manual SGA Memory ManagementF
None of the above
热门标签
最新试卷
