In Oracle 11g, which recommendations does the SQL Access Advisor generate?（）

相似题目

• Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  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.

  查看最佳答案

• You installed Oracle Database 11g afresh. Which statements are true regarding the default audit settings in this database？（） 

  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.

  查看最佳答案

• Which three statements are true regarding the data types in Oracle Database 10g/11g?（）

  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

  查看最佳答案

• Which two statements are true regarding transactions in an Oracle database（）

  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.

  查看最佳答案

• Which of the following initialization parameters have been deprecated in Oracle 11g because of the introduction of the Automatic Workload Repository？（） 

  A .  BACKGROUND_DUMP_DEST B .  FOREGROUND_DUMP_DEST C .  CORE_DUMP_DEST D .  USER_DUMP_DEST E .  DIAGNOSTIC_DEST F .  All of the above

  查看最佳答案

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

  查看最佳答案

• You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario？（）

  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.

  查看最佳答案

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

  查看最佳答案

• You are maintaining the database in Oracle10g. You are performing an incomplete recovery by using RMAN because an important table， EMPLOYEE， is dropped and purged from the Recycle Bin. Which statement is NOT true regarding an incomplete recovery？（）

  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.

  查看最佳答案

• You are managing an Oracle Database 11g database with ASM storage. The ASM disk group has the COMPATIBLE.ASM attribute set to 11.1.  Which statements are true regarding extent management and allocation units in the ASM disk group？（）

  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.

  查看最佳答案

• You are maintaining your database in Oracle10g. You are not using the recovery catalog to maintain the backup information of your database. Which file can be used as a repository to store information regarding the RMAN backup？（）

  A .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

  查看最佳答案

• Which four service offerings are included in Oracle Public Cloud?（）

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

  查看最佳答案

• 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

  查看最佳答案

• Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups？（）

  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.

  查看最佳答案

• 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

  查看最佳答案

• You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command？（）

  A . Datafiles B .  Current control file C .  Server parameter file （spfile） D .  Password file

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  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.

  查看最佳答案

• 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

  查看最佳答案

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

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

  查看最佳答案

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

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

  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.

  查看最佳答案