单选题You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding t

第1题：

Which of the following options is true about shutting down an Automatic Storage Management （ASM） instance？（）  

• A、 If the SHUTDOWN IMMEDIATE command is issued to the ASM instance， the ASM instance immediately shuts down.
• B、 If the SHUTDOWN ABORT command is issued to the ASM instance， the ASM instance will shut down all the database instances and then shut down immediately.
• C、 If the SHUTDOWN NORMAL command is issued to the ASM instance， before shutting down， the ASM instance waits for the dependent database instances to shut down.
• D、 If the SHUTDOWN TRANSACTIONAL command is issued to the ASM instance， the ASM instance passes the same SHUTDOWN command to the dependent database instances， but does not wait for any active transactions to complete before it shuts down.

第2题：

You are managing Oracle Database 11g with an ASM storage with high redundancy. The following command was issued to drop the disks from the dga disk group after five hours：   ALTER DISKGROUP dga OFFLINE DISKS IN FAILGROUP f2 DROP AFTER 5H；   Which statement is true in this scenario？（）

• A、 It starts the ASM fast mirror resync.
• B、 All the disks in the dga disk group would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.
• C、 It drops all disk paths from the dga disk group.
• D、 All the disks in the dga disk group in failure group f2 would be OFFLINE and the DISK_REPAIR_TIME disk attribute would be set to 5 hours.

第3题：

You are the Database Administrator for WonderWeb， which has recently acquired a media company TXGlobal. You have been assigned the task to migrate all the database applications of TXGlobal to the database server of WonderWeb. To accommodate more database applications， you need to add disks to the existing disk group. Whenever you add or remove disks from the disk group， Automatic Storage Management （ASM） rebalancing distributes the data evenly across all the disks of the disk group. Which background process performs this actual rebalancing activity， resulting in the movement of data extents in the disk groups？（）  

• A、 ASMB
• B、 ARBn
• C、 RBAL in the ASM instance
• D、 RBAL in the database instance

第4题：

You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）

• A、The command succeeds but it retrieves only the disk names.
• B、The command produces an error because the ASM instance is down.
• C、The command succeeds but it shows only the status of the ASM instance.
• D、The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.

第5题：

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.

第6题：

第7题：

第8题：

第9题：

第10题：

第11题：

第12题：

第13题：

You are managing an Oracle Database 11g database with the ASM storage. The database is having big file tablespaces. You want files to open faster and less memory to be used in the shared pool to manage the extent maps.  What configuration would you effect to achieve your objective？（）  

• A、 Set the ASM compatibility attribute for the ASM disk group to 11.1.0.
• B、 Set the RDBMS compatibility attribute for the ASM disk group to 11.1.0.
• C、 Set the COMPATIBLE initialization parameter for the ASM instance to 11.1.0.
• D、 Set the COMPATIBLE initialization parameter for the database instance to 11.1.0.

第14题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？ （）

• A、 RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
• B、 RMAN would relocate the ASM files to an ASM disk group and the non-ASM files to an operating system location， defined using OMF
• C、 RMAN would relocate all the database files to an ASM disk group.
• D、 RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.

第15题：

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario？（）

• A、 The disk is immediately dropped from the disk group.
• B、 The ASM tracks the extents that are modified during the outa
• C、 The ASM migrates the extents from the unavailable disk to the remaining disks.
• D、 The disk automatically goes offline.

第16题：

You have an Automatic Storage Management （ASM） instance managing the database files of your production database. The database contains ASM files and non/x7fASM files. Using Recovery Manager （RMAN）， you migrate the complete production database to use the ASM instance. Which statement is true？（）

• A、RMAN would relocate all the database files to an ASM disk group.
• B、RMAN would change the file definitions in the control file to use the ASM but would not relocate the database files physically.
• C、RMAN would relocate all the data files to an ASM disk group and other files to an operating system location， defined using Oracle Managed Files （OMF）.
• D、RMAN would relocate the ASM files to an ASM disk group and the non­ASM files to an operating system location， defined using OMF

第17题：

第18题：

第19题：

第20题：

第21题：

第22题：

第23题：