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
相关考题：
You are in the process of creating a virtual private catalog in your Oracle Database 11g database. The PROD1, PROD2, and PROD3 Oracle Database 10g databases are registered in the base recovery catalog. The database user who owns the base recovery catalog is CATOWNER. CATOWNER executes the following command to grant privileges to a new user VPC1 using Oracle Database 11g RMAN executables:What is the outcome of the above commands?（）A. They execute and create a virtual catalog for pre-Oracle 11g clients.B. They produce an error because PROD1 and PROD2 databases belong to the older version.C. They produce an error because you need to connect as CATOWNER to execute this packaged procedure.D. They produce an error because you need to connect to the target database to execute this packaged procedure.
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)－compliant? () A. ORACLE_BASE should be set explicitly.B. An Oracle base should have only one Oracle home created in it.C. Flash recovery area and data file location should be on separate disks.D. Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
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
What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? （）A、ORACLE_BASE should be set explicitly.B、An Oracle base should have only one Oracle home created in it.C、Flash recovery area and data file location should be on separate disks.D、Flash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
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
What are the different logging modes available in Oracle Database 11g？（） A、 NOLOG modeB、 NOARCHIVELOG modeC、 LOGGING modeD、 HOTDATABASE modeE、 ARCHIVELOG mode
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? （）(Choose all that apply.)A、partitioning recommendationsB、statistics collection recommendationsC、index creation recommendationsD、materialized view recommendationsE、materialized view log recommendations
单选题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
多选题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
多选题What are the recommendations for Oracle Database 11g installation to make it Optimal Flexible Architecture (OFA)-compliant? （）AORACLE_BASE should be set explicitly.BAn Oracle base should have only one Oracle home created in it.CFlash recovery area and data file location should be on separate disks.DFlash recovery area and data file location should be created under Oracle base in a non-Automatic Storage Management (ASM) setup.
多选题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