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

相似题目

• 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 statement about Automatic Memory Management with Oracle 11g is true?（）

  A . You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or PGA_AGGREGATE_TARGET values that are greater than zero in your parameter file. B . Oracle can reallocate memory between the SGA and PGA automatically as needed. C . To use Automatic Memory Management, you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file. D . You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

  查看最佳答案

• 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 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 manage ability 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.

  查看最佳答案

• 在Oracle11g中，可以使用ADDINDEX语句创建索引。

  A . 正确 B . 错误

  查看最佳答案

• Oracle11G中可以使用（）数据字典视图查看有关用户和对象的权限信息。

  A . USER_TAB_PRIVS_MADE B . USER_COL_TAB_RECD C . USER_COL_PRIVS_MADE D . USER_TAB_PRIVS_RECD E . USER_COL_PRIVS_RECD

  查看最佳答案

• Oracle11G软件可以安装在以下哪些系统（）。

  A . UNIX B . Linux C . Windows D . Mac E . 只有UNIX、Linux和Window

  查看最佳答案

• You are managing an Oracle Database 11g instance.You want to create a duplicate database for testing purpose. What are the prerequisites for performing the active database duplication?（）

  A . The source database backup must be copied over the net for test database. B . The source database must be run in ARCHIVELOG mode if the database is open. C . The source database must be shut down cleanly if the database is in mounted state. D . A net service name should be set up and a listener configured with the target as well as the source database.

  查看最佳答案

• Oracle 11g是基于（）的。

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

  查看最佳答案

• 用于在启动实例时配置数据库，确定Oracle 11g的运行环境文件是（）。

  A、参数文件 B、数据文件 C、可执行文件 D、控制文件

  查看最佳答案

• Which statement about the enabling of table compression in Oracle Database 11g is true？（）  

  A .  Compression can be enabled at the table， tablespace， or partition level for direct loads only. B .  Compression can be enabled only at the table level for both direct loads and conventional DML. C .  Compression can be enabled at the table， tablespace， or partition level for conventional DML only. D .  Compression can be enabled at the table， tablespace， or partition level for both direct loads and conventional DML.

  查看最佳答案

• Which statements are true regarding the system-defined moving window baseline in Oracle Database 11g？（）

  A .  It does not allow you to change the moving window size. B .  Adaptive threshold functionalities use it by default to compute statistics. C .  It is created by default with the window size being equal to the AWR retention time. D .  It is created when the first snapshot is collected by the Automatic Workload Repository （AWR）.

  查看最佳答案

• Which two statements are true regarding Health Monitor checks in Oracle Database 11g？（）  

  A .  Health Monitor checks can be used to scan the contents of the redo log and archive logs for accessibility and corruption. B .  Health Monitor checks can be used to verify the integrity of database files and report failures if these files are inaccessible，corrupt or inconsistent. C .  Health Monitor checks can be used to verify the contents of dictionary entries for each dictionary object and fix it automatically. D .  Health Monitor checks are always initiated manually when there is some critical error.

  查看最佳答案

• In Oracle 11g，by default which one of the following conditions implicitly enables Automatic PGA Memory Management？（）  

  A .  Setting a nonzero value for SGA_TARGET B .  Configuring Automatic Shared Memory Management C .  Configuring Automatic Memory Management D .  Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET E .  None of the above

  查看最佳答案

• 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 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

  查看最佳答案

• What are the different logging modes available in Oracle Database 11g？（） 

  A .  NOLOG mode B .  NOARCHIVELOG mode C .  LOGGING mode D .  HOTDATABASE mode E .  ARCHIVELOG mode

  查看最佳答案

• 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 recommendatio

  查看最佳答案

• How many different calendars does Oracle 11g support?（）

  A . 22 B . 7 C . 6 D . 15 E . 2

  查看最佳答案

• Which statement about Automatic Memory Management with Oracle 11g is true？（）  

  A .  You cannot specify MEMORY_TARGET if you explicitly specify SGA_TARGET or  PGA_AGGREGATE_ TARGET values that are greater than zero in your parameter file. B .  Oracle can reallocate memory between the SGA and PGA automatically as needed. C .  To use Automatic Memory Management， you must explicitly set both the MEMORY_TARGET and MEMORY_MAX_TARGET parameters in your parameter file. D .  You can set the MEMORY_TARGET parameter to a maximum value of the current SGA size plus the current PGA size.

  查看最佳答案

• Which tasks can be accomplished using the Enterprise Manager Support Workbench in Oracle Database 11g？（） 

  A .  Generate reports on data failure such as data file failures. B .  You can track the Service Request （SR） and implement repairs. C .  You can package and upload diagnostic data to Oracle Support. D .  You can manually run health checks to gather diagnostic data for a problem.

  查看最佳答案

• Oracle11g新引入了（)的概念，当集群节点增加或者减少时，无需调整客户端的连接参数。

  A．共有IP B．私有IP C．VIP D．SCANIP

  查看最佳答案

• ORACLE11G数据库有很多初始化参数,其中NLS_LANUGE表示：。

  A．A.数据库的字符集 B．B.环境变量 C．C.数据库菜单语言 D．D.数据库的默认语言

  查看最佳答案

• 关于Oracle11G的AMM（AutomaticMemoryManagement)，哪种说法是正确的（)。

  A．如果明确设置了SGA_TARGET或者PGA_AGGREGATE_TARGET的值大于0，那么就不能指定MEMORY_TARGET值的大小 B．Oracle会根据需要自动在SGA和PGA之间分配内存大小 C．如果想使用AMM，必需在初始化参数文件中明确设置MEMORY_TARGET和MEMORY_MAX_TARGET参数的值 D．可以把当前SGA加上PGA的值设置为MEMORY_TARGET参数的最大值

  查看最佳答案