网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
Oracle 11g是基于（）的。
- A、关系型
- B、文件系统
- C、层次型
- D、网络型
参考答案
更多 “Oracle 11g是基于（）的。A、关系型B、文件系统C、层次型D、网络型” 相关考题
考题
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.
考题
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？（） 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 recommendationsB、statistics collection recommendationsC、index creation recommendationsD、materialized view recommendationsE、materialized view log recommendations
考题
多选题对于Oracle的服务，描述正确的是（）。AOracleOraDb11g_homeTNSListener服务：Oracle服务器的监听程序BOracleDBConsoleSID://Oracle的核心服务，要启动Oracle实例，必须启动该服务COracleJobSchedulerSID://任务调度服务，负责对用户创建的作业按预先设置的时间周期性地进行调度执行，从而实现Oracle服务器的自动管理功能DOracleServiceSID://负责在Windows平台下启动Oracle企业管理器。Oracle 11g企业管理器是一个功能完善的Oracle数据库管理工具，可以管理本地数据库环境和网格环境
考题
单选题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 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?（）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.
考题
单选题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 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.
考题
单选题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.
考题
多选题What are the different logging modes available in Oracle Database 11g？（）ANOLOG modeBNOARCHIVELOG modeCLOGGING modeDHOTDATABASE modeEARCHIVELOG mode
热门标签
最新试卷
