In Oracle 11g, which recommendations does the SQL Access Advisor generate? （）(Choose all that apply.)

A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode. E . The database operates in NOARCHIEVELOG mode.

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 . Only one LONG column can be used per table  B . A TIMESTAMP data type column stores only time values with fractional seconds  C . The BLOB data type column is used to store binary data in an operating system file  D . The minimum column width that can be specified for a VARCHAR2 data type column is one  E . The value for a CHAR data type column is blank-padded to the maximum defined column width

A . Multiple transactions can use the same undo segment. B . A transaction is assigned an undo segment when it is started. C . More than one transaction cannot share the same extent in the undo tablespace. D . The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

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

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 target database must be in the MOUNT mode to ensure restoration of the datafiles. B .  You can restore the datafiles from the backup by using the RMAN utility only if the backups were taken using the RMAN utility. C .  The control file must be recreated. D .  The database must be opened with the RESETLOGS option.

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 .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

A .  Database Service B .  Data Service C .  Java Service D .  Security Service E .  .NET Service F .  SOA Service

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 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 database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode.  E . The database operates in NOARCHIEVELOG mode.

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 . Datafiles B .  Current control file C .  Server parameter file （spfile） D .  Password file

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