In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)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? （）(Choose all that apply.)
- A、partitioning recommendations
- B、statistics collection recommendations
- C、index creation recommendations
- D、materialized view recommendations
- E、materialized view log recommendations
相关考题：
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.
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 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.
In Oracle 11g, which recommendations does the SQL Access Advisor generate? ()(Choose all that apply.) A. partitioning recommendationsB. statistics collection recommendationsC. index creation recommendationsD. materialized view recommendationsE. materialized view log recommendations
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.
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.
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
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
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
In a new installation of Oracle Database 11g， you perform these activities： 1：Organize software and data on different subdirectories to avoid poor performance. 2：Use consistent naming conventions for database files. 3：Separate administrative information pertaining to the database in different directories. Which option corresponds to the type of activities you performed（）A、Oracle Managed FilesB、Oracle Grid ArchitectureC、Optimal Flexible ArchitectureD、Oracle database architectureE、Automatic Storage Management
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，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 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?（）AIt must be executed from the Oracle Database 11g environment.BIt must be executed only after the SYSAUX tablespace has been created.CIt must be executed from the environment of the database that is being upgraded.DIt must be executed only after AUTOEXTEND is set to ON for all existing tablespaces.EIt must be executed from both the Oracle Database 11g and Oracle Database 9i environments.
单选题Which setting enables the baselines by default in Oracle Database 11g?（）Asetting the STATISTICS_LEVEL parameter to TYPICALBadding filters to the Automatic Database Diagnostic Monitor (ADDM)Cenabling Automated Maintenance Task using Oracle Enterprise ManagerDsetting the OPTIMIZER_USE_PENDING_STATISTICS parameter to TRUE
多选题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
单选题Note the following points describing various utilities in Oracle Database 11g： 1. It enables the transfer of data from one database to another. 2. It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3. It enables the loading of data from an external file into tables of an Oracle database. 4. It provides a tape backup management for the Oracle ecosystem. Which point describes the Oracle Data Pump utility（）A1B2C3D4E1 and 3F1， 2， 3， and 4
多选题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.
多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations
单选题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?（）AThe database must be running in ARCHIVELOG mode.BNo special setup is required, and the feature is enabled by default.CThe path for the Automatic Diagnostic Repository (ADR) must be configured with the DIAGNOSTIC_DEST initialization parameter.DThe Enterprise Manager Support Workbench can be enabled only if the background process manageability monitor (MMON) is configured.ESelect 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.
单选题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
单选题Note the following points describing various utilities in Oracle Database 11g： 1：It enables the high-speed transfer of data from one database to another. 2：It provides a complete solution for the backup， restoration， and recovery needs of the entire database. 3：It enables the loading of data from an external file into an Oracle database. 4：It provides a tape backup management for the Oracle ecosystem. Which point describes Oracle Secure Backup（）A1B2C3D4E1，2，and 4F1，2，3，and 4
多选题In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)Apartitioning recommendationsBstatistics collection recommendationsCindex creation recommendationsDmaterialized view recommendationsEmaterialized view log recommendations
多选题Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（）AGenerate reports on data failure such as data file failures.BYou can track the Service Request （SR） and implement repairs.CYou can package and upload diagnostic data to Oracle Support.DYou can manually run health checks to gather diagnostic data for a problem.
单选题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.
多选题盒子化产品oracle用户下安装的组件有（）。Aoracle 11g服务端BDatastationCoracle 11g客户端Diweb