单选题 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？（）

单选题 In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

单选题 You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）

单选题 William specified the following initialization parameter settings in the pfile：   BACKGROUND_DUMP_DEST = ’u01/oradata/dir_A’   USER_DUMP_DEST = ’u01/oradata/dir_B’   DB_CREATE_FILE_DEST = ’u01/oradata/dir_C’   DB_CREATE_ONLINE_LOG_DEST_n = ’u01/oradata/dir_D’   William enabled the change-tracking feature because he does not want to scan the entire datafile during backup. What is the default storage location for the change tracking file？（）  

单选题 View the Exhibit and examine the properties of the TT tablespace.  Using Database Control， you have scheduled a job to shrink the TRANS table residing on the TT tablespace. The job would run at 5：00 p.m. every Friday.  When you examine the space usage of the table after the completion of the job， you find that the table has not been shrunk.  What could have been the reason for this？（）

单选题 You are maintaining your database in Oracle10g. You are performing an incomplete recovery because the tablespace， DATA1， was dropped and purged from the Recycle Bin. After performing an incomplete recovery， you open the database with the RESETLOGS option.  What will NOT be the impact of using the RESETLOGS option？（）

单选题 You need to check the EMP_EAST partition in the EMPLOYEES table for physical corruptions. You also need to verify that the rows belong to the correct partition. Which option could you use？（）

单选题 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？（）

单选题 You are creating a job class. You want access to the detailed information for all the runs of each job in the class and every operation performed on every job in the class. Which setting will you use for the LOGGING_LEVEL parameter？（）

单选题 Exhibit， Viewing the Exhibit and examine the Flashback Database architecture. Identify the missing component （shown with a "？`"= in the Flashback Database architecture.（）