Identify three key features of ASM.（）A、file stripingB、allocation unit mirroringC、automatic disk rebalancingD、automatic file size incrementE、automatic undo management

第1题：

第2题：

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？（）

• A、 You must use automatic undo management in the database.
• B、 You must configure OMF in your database.
• C、 You must configure ASM for storing the datafiles.
• D、 You must multiplex the online redo log file.

第3题：

第4题：

Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

• A、Flash recovery area must be defined
• B、Undo retention guarantee must be enabled.
• C、Database must be running in archivelog mode.
• D、Automatic undo management must be enabled.
• E、The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

第5题：

Which statement is true about the Manageability Monitor （MMON） background proces（）

• A、It transfers statistics from memory to disk at regular intervals.
• B、It coordinates the rebalance activity for disk groups when ASM is used.
• C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.
• D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

第6题：

第7题：

Identify three key features of ASM.（）

• A、 file striping
• B、 allocation unit mirroring
• C、 automatic disk rebalancing
• D、 automatic file size increment
• E、 automatic undo management

第8题：

第9题：

Which statement about Automatic Memory Management with Oracle 11g is true？（）  

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

第10题：

You have included the following parameter setting in your server parameter file：       PGA_AGGREGATE_TARGET = 800M        SORT_AREA_SIZE = 100M        HASH_AREA_SIZE = 100M        BITMAP_MERGE_AREA_SIZE = 100M        CREATE_BITMAP_AREA_SIZE = 100M   Which statement is true？（）  

• A、 All the *_AREA_SIZE parameters are ignored.
• B、 The Automatic PGA Memory Management feature cannot be disabled.
• C、 The total Program Global Area （PGA） memory cannot be manually increased above 800M.
• D、 The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.