In your running instance， some of the initialization paramet

第1题：

You work as a database administrator for Certkiller .com. Your database is functional. One of the disks containing a mirrored redo log member has bad sectors in it. You are unable to fix the damaged file.  How does the loss of a redo log member affect the instance of the database that is currently running？（）

• A、The instance would normally abort.
• B、The instance would not be affected.
• C、The instance would be invalid， so would have to be aborted.
• D、The instance would remain open， but the LGWR process would fail.
• E、The instance would remain open and would automatically create the missing file

第2题：

You specify a nonzero value for the MEMORY_TARGET initialization parameter，but do not set the PGA_AGGREGATE_TARGET or the SGA_TARGET parameters. You restart your database instance.  Which statement about the result is true？（）

• A、 The database instance starts，and Oracle sets the default value of SGA_TARGET to the same value as SGA_MAX_SIZE
• B、 The database instance starts，and Oracle automatically tunes memory and allocates 60 percent to the  SGA and 40 percent to the PGA
• C、 The database instance starts，but Automatic Memory Management is disabled
• D、 The database instance will not start because you did not specify the PGA_AGGREGATE_TARGET or SGA_TARGET parameter

第3题：

第4题：

You included the following Automatic Storage Management （ASM） initialization parameter settings in the ASM initialization parameter file：   INSTANCE_TYPE = ASM  ASM_POWER_LIMIT = 11  LARGE_POOL_SIZE = 4M   ASM_DISKGROUPS = DG1， DG2  DB_UNIQUE_NAME = +ASM   You are unable to start the ASM instance. Which initialization parameter file setting（s） is not allowing the ASM instance to start？（）

• A、 only the INSTANCE_TYPE initialization parameter is set to an invalid value
• B、 only the ASM_POWER_LIMIT initialization parameter is set to an invalid value
• C、 only the LARGE_POOL_SIZE initialization parameter is set to an invalid value
• D、 both the LARGE_POOL_SIZE and INSTANCE_TYPE initialization parameters are set to invalid values

第5题：

You have a single Automatic Storage Management （ASM） instance running on the node on which your Oracle Database 10g resides. Which ASM instance initialization parameters must be included in the ASM instance initialization parameter file？（）

• A、 INSTANCE_TYPE
• B、 DB_UNIQUE_NAME
• C、 ASM_DISKSTRING
• D、 ASM_POWER_LIMIT

第6题：

Your database instance is running with full workload after database creation. You have decided to useafixed-sizeundo tablespace. You want to use the Undo Advisor to estimate the capacity of the undotablespace.  Which two factors must you consider before using the Undo Advisor to estimate the capacity of the undotablespace（）

• A、the retention period to support flashback
• B、the expected length of the longest-running query
• C、the number of undo tablespaces in the database
• D、the size of the Flash Recovery Area for the database instance

第7题：

Which initialization parameter in an ASM instance specifies the disk groups to be automatically mounted at instance startup？（）  

• A、 ASM_DISKMOUNT
• B、 ASM_DISKGROUP
• C、 ASM_DISKSTRING
• D、 ASM_MOUNTGROUP

第8题：

You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）

• A、 The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO.
• B、 The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas.
• C、 Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management.
• D、 The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

第9题：

What effect should the loss of an index tablespace have on an Oracle instance that is running？（）

• A、 instance hangs
• B、 instance gets aborted
• C、 instance continues running
• D、 instance gets restarted automatically

第10题：