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

A .  The audit trail is stored in an operating system file. B .  Auditing is disabled for all privileges. C .  The audit trail is stored in the database. D .  Auditing is enabled for all privileges. E .  Auditing is enabled for certain privileges related to database security.

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

A .  The database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances. B .  RDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group. C .  The RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk. D .  ASM compatibility controls which features for the ASM will be enabled.

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.

A . 正确 B . 错误

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

A . The Oracle kernel will be placed in this location. B . The Oracle software will be placed in this location. C . The server parameter file （SPFILE） will be placed in this location. D . The database files will be placed in this location， if not specified explicitly. E . The location will be considered for the base of Oracle Managed Files （OMF）. F . The location will be considered for the base of Optimal Flexible Architecture （OFA）.

A . Oracle Data Pump B . Oracle Recovery Manager (RMAN) C . Oracle Label Security D . Oracle Database Vault E . Oracle Real Application Security

A .  The au_size disk group attribute determines the size of allocation units in the disk group.  B .  The allocation unit size may vary but the extent size is fixed. C .  The allocation unit size and extent size are fixed for all the disks in a disk group and cannot be changed. D .  Extent management is completely automated.

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

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.

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）.

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.

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 .  NOLOG mode B .  NOARCHIVELOG mode C .  LOGGING mode D .  HOTDATABASE mode E .  ARCHIVELOG mode

A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

A .  partitioning recommendations B .  statistics collection recommendations C .  index creation recommendations D .  materialized view recommendations E .  materialized view log recommendatio

A . row level B . block level C . object level D . schema level E . database level

A . SYSTEM B . SYSAUX C . EXAMPLE D . UNDO E . TEMP F . USERS

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.

A . It is a SQL script. B . It is a PL/SQL file. C . It is an operating system （OS） file. D . It is a Recovery Manager （RMAN） script

A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

A．Permission is determined by the UMASK valu B．Only administrator permission is grante C．You must specify the values as you create the shar D．Permission is granted to everyon E．