网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which setting enables the baselines by default in Oracle Database 11g?（）
A
setting the STATISTICS_LEVEL parameter to TYPICAL
B
adding filters to the Automatic Database Diagnostic Monitor (ADDM)
C
enabling Automated Maintenance Task using Oracle Enterprise Manager
D
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which setting enables the baselines by default in Oracle Database 11g?（）A setting the STATISTICS_LEVEL parameter to TYPICALB adding filters to the Automatic Database Diagnostic Monitor (ADDM)C enabling Automated Maintenance Task using Oracle Enterprise ManagerD setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE” 相关考题
考题
You create a new Automatic Database Diagnostic Monitor (ADDM) task: instance_analysis_mode_task. To view the ADDM report, you use the following command:You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT‘s segments.What would you do to achieve this?（）A. Add a finding directive for the ADDM task.B. Add a segment directive for the ADDM task.C. Add a parameter directive for the ADDM task.D. Disable the Segment Advisor from the Automatic Maintenance Task.
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default?()
A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor
考题
Which setting enables the baselines by default in Oracle Database 11g?()
A. setting the STATISTICS_LEVEL parameter to TYPICALB. adding filters to the Automatic Database Diagnostic Monitor (ADDM)C. enabling Automated Maintenance Task using Oracle Enterprise ManagerD. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default? ()(Choose all that apply.)
A. Segment AdvisorB. SQL Access AdvisorC. Optimizer statistics gatheringD. Automatic SQL Tuning AdvisorE. Automatic Database Diagnostics Monitor
考题
Which three methods can you use to run an Automatic Database Diagnostic Monitor （ADDM） analysis over a specific time period？（）A、 Enterprise Manager GUIB、 DBMS_TRACE package APIsC、 DBMS_ADVISOR package APIsD、 DBMS_MONITOR package APIsE、 $ORACLE_HOME/rdbms/admin/addmrpt.sql script
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default? （）(Choose all that apply.)A、Segment AdvisorB、SQL Access AdvisorC、Optimizer statistics gatheringD、Automatic SQL Tuning AdvisorE、Automatic Database Diagnostics Monitor
考题
Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service （IPS） to MetaLink？（）A、 The database must be running in ARCHIVELOG mode.B、 No special setup is required， and the feature is enabled by default.C、 The path for the Automatic Diagnostic Repository （ADR） must be configured with the DIAGNOSTIC_DEST initialization parameter.D、 The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor （MMON） is configured.E、 Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software， provide valid MetaLink credentials and select license agreement.
考题
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）
考题
Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（） A、 Only the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.B、 The problem key is the same as the incident number.C、 The database sends an incident alert to the Oracle Enterprise Manager Database Home page.D、 Every problem has a problem key， which is a text string that describes the problem.E、 The database makes an entry into the alert log file when problems and incidents occur.
考题
Which setting enables the baselines by default in Oracle Database 11g？（） A、 setting the STATISTICS_LEVEL parameter to TYPICALB、 adding filters to the Automatic Database Diagnostic Monitor （ADDM）C、 enabling Automated Maintenance Task using Oracle Enterprise ManagerD、 setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
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）
考题
A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A、The value for MINEXTENTS setting B、The value for PCTINCREASE setting C、The value for MAXEXTENTS setting D、By default, Oracle allocates six extents to all database objects
考题
Which tasks are run automatically as part of the Automated Maintenance Task by default？（） A、 Segment AdvisorB、 SQL Access AdvisorC、 Optimizer statistics gatheringD、 Automatic SQL Tuning AdvisorE、 Automatic Database Diagnostics Monitor
考题
In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（） A、 Setting a nonzero value for SGA_TARGETB、 Configuring Automatic Shared Memory ManagementC、 Configuring Automatic Memory ManagementD、 Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE、 None of the above
考题
You create a new Automatic Database Diagnostic Monitor （ADDM） task： instance_analysis_mode_task. To view the ADDM report， you use the following command： SQL SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual； You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. What would you do to achieve this？（）A、 Add a finding directive for the ADDM task.B、 Add a segment directive for the ADDM task.C、 Add a parameter directive for the ADDM task.D、 Disable the Segment Advisor from the Automatic Maintenance Task.
考题
多选题Which tasks are run automatically as part of the Automated Maintenance Task by default?（）ASegment AdvisorBSQL Access AdvisorCOptimizer statistics gatheringDAutomatic SQL Tuning AdvisorEAutomatic Database Diagnostics Monitor
考题
单选题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 Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）A
Setting a nonzero value for SGA_TARGETB
Configuring Automatic Shared Memory ManagementC
Configuring Automatic Memory ManagementD
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGETE
None of the above
考题
单选题Which setting enables the baselines by default in Oracle Database 11g？（）A
setting the STATISTICS_LEVEL parameter to TYPICALB
adding filters to the Automatic Database Diagnostic Monitor （ADDM）C
enabling Automated Maintenance Task using Oracle Enterprise ManagerD
setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
考题
单选题Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service （IPS） to MetaLink？（）A
The database must be running in ARCHIVELOG mode.B
No special setup is required， and the feature is enabled by default.C
The path for the Automatic Diagnostic Repository （ADR） must be configured with the DIAGNOSTIC_DEST initialization parameter.D
The Enterprise Manager Support Workbench can be enabled only if the background process manage ability monitor （MMON） is configured.E
Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software， provide valid MetaLink credentials and select license agreement.
考题
单选题A table was just created on your Oracle database with six extents allocated to it. Which of the following factors most likely caused the table to have so many extents allocated?（）A
The value for MINEXTENTS setting B
The value for PCTINCREASE setting C
The value for MAXEXTENTS setting D
By default, Oracle allocates six extents to all database objects
考题
单选题Which statement is true for enabling Enterprise Manager Support Workbench in Oracle Database 11g to upload the physical files generated by Incident Packaging Service (IPS) to MetaLink?（）A
The database must be running in ARCHIVELOG mode.B
No special setup is required, and the feature is enabled by default.C
The path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.D
The Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.E
Select the Enable option in the Oracle Configuration Manager Registration window during the installation of the Oracle Database 11g software, provide valid MetaLink credentials and select license agreement.
考题
单选题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）
考题
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database， you want to determine the optimal size of the online redo log files. Which tool enables you to determine the optimal size of the online redo log files？（）A
Oracle Enterprise ManagerB
The V$LOG viewC
The V$LOGFILE viewD
The V$FLASHBACK_DATABASE_LOGS view
考题
单选题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）
考题
单选题You create a new Automatic Database Diagnostic Monitor （ADDM） task： instance_analysis_mode_task. To view the ADDM report， you use the following command： SQL SELECT dbms_addm.get_report（’my_instance_analysis_mode_task’） FROM dual； You want to suppress ADDM output relating to Segment Advisor actions on user SCOTT’s segments. What would you do to achieve this？（）A
Add a finding directive for the ADDM task.B
Add a segment directive for the ADDM task.C
Add a parameter directive for the ADDM task.D
Disable the Segment Advisor from the Automatic Maintenance Task.
考题
多选题Which statements are true regarding the concept of problems and incidents in the fault diagnosability infrastructure for Oracle Database 11g？（）AOnly the incident metadata and dumps are stored in the Automatic Diagnostic Repository （ADR）.BThe problem key is the same as the incident number.CThe database sends an incident alert to the Oracle Enterprise Manager Database Home page.DEvery problem has a problem key， which is a text string that describes the problem.EThe database makes an entry into the alert log file when problems and incidents occur.
热门标签
最新试卷
