Your production database uses an Automatic Storage Management （ASM） instance to manage its files.  You want to add a new disk group to the ASM instance to manage the increased data load.  What action would you perform to include the new disk group in the 

第1题：

Consider the following command to create a tablespace in your production database （which is using an Automatic Storage Management [ASM] instance to manage the database files）：  CREATE TABLESPACE user_tbsp  DATAFILE ’+dgroup3（user_temp）/user_files/user_tbsp’ SIZE 200M；  What would be the result of this command？（）

• A、It would result in an error because the template cannot be used along with the disk group.
• B、It would result in an error because the path cannot be specified while creating a tablespace in a disk group.
• C、It would create a tablespace with a data file that has an alias， and its attributes are set by the user-defined template.
• D、It would create a tablespace with a data file that does not have an alias， and its attributes are set by the user-defined template.

第2题：

You are using an Automatic Storage Management （ASM） instance to manage the database files of your production database. After adding a new disk group to the ASM instance， you execute the following command：  ALTER DISKGROUP dg3 REBALANCE POWER 0； What would be the result of this command？（）

• A、The rebalancing of the disk group would be stopped.
• B、The rebalancing of the disk group would be completed as fast as possible.
• C、The command would result in an error because the value of POWER cannot be 0.
• D、The rebalancing of the disk group would be completed without affecting the disk group DG3.
• E、The command would result in an error because the disk groups cannot be manually rebalanced.

第3题：

第4题：

You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. While studying the parameter file of the ASM instance， you find the following entry：  ASM_DISKSTRING = /devices/*  What could be the reason for this setting？（）

• A、to enable the ASM instance to identify the alert log file
• B、to enable the ASM instance to identify the server parameter file
• C、to enable the ASM instance to define the locations for Oracle Managed Files （OMF）
• D、to enable the ASM instance to identify all disks that can be accessed by it in the /devices directory

第5题：

You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have been specified： DB_CREATE_ONLINE_LOG_DEST_1 = ’+dg1’  DB_CREATE_ONLINE_LOG_DEST_2 = ’+dg2’  What would be the impact of this setting？（）

• A、When a new log group is added， it would have one member in each disk group.
• B、When a new log group is added， it would have two members in each disk group.
• C、When a new tablespace is added， it would have one data file in each disk group.
• D、When a new log file is added， it would have one member spread across the disk groups.

第6题：

n your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）

• A、 Oracle Migration Assistant
• B、 Recovery Manager （RMAN）
• C、 Oracle Data Pump Export and Import
• D、 conventional Oracle Export and Import
• E、 operating system utilities to copy the files to the ASM instance

第7题：

You are maintaining the SALES database.You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity.Which parameter should you specify to control the speed of the rebalancing activity?（）

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

第8题：

You work as a database administrator at Certkiller .com. Your production database uses an Automatic Storage Management （ASM） instance to manage its files. You want to add a new disk group to the ASM instance to manage the increased data load. What action would you perform to include the new disk group in the ASM instance without causing any impact on the currently connected users？（）

• A、 mount the new disk group in the ASM instance
• B、 restart the ASM instance and the production database instance
• C、 register the new disk groups in the production database instance
• D、 restart the ASM instance without restarting the production database instance
• E、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

第9题：

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.

第10题：

You are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control the speed of the rebalancing activity？ （） 

• A、 ASM_POWER_LIMIT
• B、 ASM_DISKSTRING
• C、 ASM_DISKGROUPS
• D、 LARGE_POOL_SIZE