In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)

A、partitioning recommendations

B、statistics collection recommendations

C、index creation recommendations

D、materialized view recommendations

E、materialized view log recommendations

查看正确答案

更多“In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)”相关的问题

第1题

[] TFDS-2服务器需要安装的Oracle版本是（）。

A、A.Oracle816 B、B.Oracle9i C、C.Oracle10g D、D.Oracle11g

点击查看答案

第2题

[多选题] In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）

A、partitioning recommendations B、statistics collection recommendations C、index creation recommendations D、materialized view recommendations E、materialized view log recommendations

点击查看答案

第3题

[] Which setting enables the baselines by default in Oracle Database 11g?（）

A、A. setting the STATISTICS_LEVEL parameter to TYPICAL B、B. adding filters to the Automatic Database Diagnostic Monitor (ADDM) C、C. enabling Automated Maintenance Task using Oracle Enterprise Manager D、D. setting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE

点击查看答案

第4题

[单选题] Which of the following WLAN protocols is in the 5GHz band with a MAXIMUM data rate of 54Mbps?（）

A、802.11a B、802.11b C、802.11g D、802.11n

点击查看答案

第5题

[多选题] 对于Oracle的服务，描述正确的是（）。

A、OracleOraDb11g_homeTNSListener服务：Oracle服务器的监听程序 B、OracleDBConsoleSID：Oracle的核心服务，要启动Oracle实例，必须启动该服务 C、OracleJobSchedulerSID：任务调度服务，负责对用户创建的作业按预先设置的时间周期性地进行调度执行，从而实现Oracle服务器的自动管理功能 D、OracleServiceSID：负责在Windows平台下启动Oracle企业管理器。Oracle 11g企业管理器是一个功能完善的Oracle数据库管理工具，可以管理本地数据库环境和网格环境

点击查看答案

第6题

[单选题] 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

点击查看答案

第7题

[单选题] 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）

点击查看答案

第8题

[单选题] 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？（）