In Oracle 11g， which recommendations does the SQL Access Advisor generate？（）  

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

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 .  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 .  Automatic PGA Memory Management B .  Automatic SGA Memory Management C .  Automatic Shared Memory Management D .  Automatic Memory Management E .  Manual SGA Memory Management F .  None of the above

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 . Multiplex all database files B . Configure the Flash Recovery Area. C . Configure the database instance for ARCHIVELOG mode. D . Configure the FAST_START_MTTR_TARGET initialization parameter.

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

A . The backups would be consistent.  B . The backups would be inconsistent. C . The backups would be possible only if the database is running in ARCHIVELOG mode. D . The backups would be possible only if the database is running in NOARCHIVELOG mode. E . The backups need to be restored and the database has to be recovered in case of a media failure.

A . The backups would be consistent. B . The backups would be inconsistent. C . The backups would be possible only if the database is running in ARCHIVELOG mode. D . The backups would be possible only if the database is running in NOARCHIVELOG mode. E . The backups need to be restored and the database has to be recovered in case of a media failure

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 . Alert log file B . Archived redo log files C . Control file autobackups D . Server Parameter file (SPFILE) E . Recovery Manager (RMAN) backup piece

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 .  Alert log file B .  Archived redo log files C .  Control file autobackups D .  Server Parameter file （SPFILE） E .  Recovery Manager （RMAN） backup piece

A . Multiplex all database files. B . Configure the Flash Recovery Area. C . Configure the database instance for ARCHIVELOG mode. D . Configure the FAST_START_MTTR_TARGET initialization parameter

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.

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