1Z0-053
单选题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 o
题目
ASM_POWER_LIMIT
ASM_DISKSTRING
ASM_DISKGROUPS
INSTANCE_TYPE
相似问题和答案
第1题：
You are the administrator of a SQL Server 2000 computer. The server contains database named Sales. Users report that they cannot add new data to the database. You examine the properties of the database. The database is configured as shown in the Sales Properties exhibit.
You examine drive E. The hard disk is configured as shown in the Local Disk Properties exhibit.
You want the users to be able to add data, and you want to minimize administrative overhead. What should you do?
A．Increase the maximum file size of Sales_Data to 1,500MB.
B．Use the DBCC SHRINKDATABASE statement.
C．Set automatic file growth to 10 percent.
D．Create another data file named Sales_Data2 in a new SECONDARY filegroup.
解析：Explanation: By examining the first exhibit we see that the database has reached its maximum size of 1001 MB. The data file is located on drive E and the second exhibit shows us that there is enough free space on that disk to increase the maximum size of the data file to 1,500 MB.
Incorrect Answers:
B: DBCC SHRINKDATABASE could possibly shrink the database and new records could be added for a while, but it would just be a temporary solution.
C: The database is already set to automatic file growth, but it has reached the maximum size.
D: The primary file has reached it maximum size. A secondary filegroup would help if it was set to the default file group. New data would still be added to the primary filegroup which is at its maximum size.
第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.
正确答案:A
第3题：
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
第4题：
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
正确答案:A
第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.
正确答案:A
第6题：
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
正确答案:A
第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
正确答案:A
第8题：
You administer an online transaction processing (OLTP) system whose database is stored in AutomaticStorage Management (ASM) and whose disk group use normal redundancy.One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed.When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow.Which two recommendations should you make to speed up the rebalance operation if this type of failurehappens again?（）
A. Increase the value of the ASM_POWER_LIMIT parameter.
B. Set the DISK_REPAIR_TIME disk attribute to a lower value.
C. Specify the statement that adds the disk back to the disk group.
D. Increase the number of ASMB processes.
E. Increase the number of DBWR_IO_SLAVES in the ASM instance.
第9题：
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
正确答案:A
第10题：
You are maintaining the SALES database. You have added a new disk to a disk group. Automatic StorageManagement 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
正确答案:A