In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）A、partitioning recommendationsB、statistics collection recommendationsC、index creation recommendationsD、materialized view recommendationsE、materialized view log recommendations

题目

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

如果没有搜索结果或未解决您的问题，请直接联系老师获取答案。

相似问题和答案

第1题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process, you execute the following script:SQL>@utlu111i.sqlWhich statement about the execution of this script is true?（）

A. It must be executed from the Oracle Database 11g environment.

B. It must be executed only after the SYSAUX tablespace has been created.

C. It must be executed from the environment of the database that is being upgraded.

D. It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.

E. It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

参考答案：C

第2题：

盒子化产品oracle用户下安装的组件有（）。

A、oracle 11g服务端
B、Datastation
C、oracle 11g客户端
D、iweb

正确答案:A,C

第3题：

You decided to use Direct NFS configuration in a non－RAC Oracle installation and created the oranfstab file in ／etc. Which two statements are true regarding this oranfstab file? ()

A. Its entries are specific to a single database.

B. It contains file systems that have been mounted by Direct NFS.

C. It is globally available to all Oracle 11g databases on the machine.

D. It contains file systems that have been mounted by the kernel NFS system.

参考答案：C, D

第4题：

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

正确答案:A,C,D

第5题：

You installed Oracle Database 11g and are performing a manual upgrade of the Oracle9i database. As a part of the upgrade process，you execute the following script： SQL>@utlu111i.sql Which statement about the execution of this script is true？（）

A、 It must be executed from the Oracle Database 11g environment.
B、 It must be executed only after the SYSAUX tablespace has been created.
C、 It must be executed from the environment of the database that is being upgraded.
D、 It must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.
E、 It must be executed from both the Oracle Database 11g and Oracle Database 9i environments.

正确答案:C

第6题：

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

参考答案：A, C, D, E

第7题：

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.

正确答案:C,D,E

第8题：

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

参考答案：A

第9题：

Oracle 11g是基于（）的。

A、关系型
B、文件系统
C、层次型
D、网络型

正确答案:A

第10题：

For Oracle 11g， Oracle strongly recommends that you configure your database to use which of the following memory-management features？（）

A、 Automatic PGA Memory Management
B、 Automatic SGA Memory Management
C、 Automatic Shared Memory Management
D、 Automatic Memory Management
E、 Manual SGA Memory Management
F、 None of the above

正确答案:D

In Oracle 11g, which recommendat

题目

相似问题和答案

更多相关问题

相关内容