单选题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

题目
单选题
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

相似考题

1.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_LIMITB. ASM_DISKSTRINGC. ASM_DISKGROUPSD. INSTANCE_TYPE

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

3.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 instanceB、 restart the ASM instance and the production database instanceC、 register the new disk groups in the production database instanceD、 restart the ASM instance without restarting the production database instanceE、 include the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

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

参考答案和解析
正确答案： C
解析： 暂无解析
更多“单选题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”相关问题

  • 第1题：

    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

  • 第2题：

    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

  • 第3题：

    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

  • 第4题：

    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

    正确答案:B

  • 第5题：

    You have a server named Server 1.Server1 runs Windows Server 2012 R2. Server1 has a thin provisioned disk named Disk1.You need to expand Disk1.Which two actions should you perform？（）

    • A、From File and Storage Services， extend Disk1
    • B、From File and Storage Services， add a physical disk to the storage pool
    • C、From Disk Management， extend the volume
    • D、From Disk Management， delete the volume， create a new volume， and then format the volume
    • E、From File and Storage Services， detach Disk1

    正确答案:A,B

  • 第6题：

    Which of the following options will allow you to increase the size of a thin provisioned disk in Windows Server 2012 R2？（）

    • A、You should add a new hard disk to the storage pool，extend the disk in File and Storage Services.
    • B、You should mount a new volume on the storage pool in File and Storage Services.
    • C、You should convert the disk to a dynamic disk in Computer Management.
    • D、You should convert the disk to a dynamically expanding virtual hard disk （VHD）.
    • E、You should detach the disk in File and Storage Services and increase its size.

    正确答案:A

  • 第7题：

    单选题
    You work as a network administrator， and your responsibilities include managing server storage. You havebeen asked to purchase a new disk subsystem for your company’s storage-area network （SAN）. You arein the process of testing hardware solutions before making purchases， and you attach a new disksubsystem to the network. You want to provision the new disks and create new logical unit numbers （LUNs）to assign to a server named Server1. You open Storage Manager for SANs， but you can’t see the newhardware. However， you can connect to the new hardware by using the software provided by the vendor.You want to be able to manage the new disk subsystem you purchase by using Storage Manager for SANs. What should you do？（）
    A

    In Disk Management， chooses the Rescan Disks option.

    B

    Choose a disk subsystem from a vendor that has a Virtual Disk Service hardware provider.

    C

    On Server1， configures iSCSI Initiator to specify the new hardware as a favorite target.

    D

    Use Storage Explorer to configure Server1 as an iSNS server.


    正确答案： C
    解析： 暂无解析

  • 第8题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    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
    解析： 暂无解析

  • 第10题：

    多选题
    You have a server named Server 1.Server1 runs Windows Server 2012 R2. Server1 has a thin provisioned disk named Disk1.You need to expand Disk1.Which two actions should you perform？（）
    A

    From File and Storage Services， extend Disk1

    B

    From File and Storage Services， add a physical disk to the storage pool

    C

    From Disk Management， extend the volume

    D

    From Disk Management， delete the volume， create a new volume， and then format the volume

    E

    From File and Storage Services， detach Disk1


    正确答案： B,E
    解析： 暂无解析

  • 第11题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

  • 第12题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    You work as a network administrator， and your responsibilities include managing server storage. You havebeen asked to purchase a new disk subsystem for your company’s storage-area network （SAN）. You arein the process of testing hardware solutions before making purchases， and you attach a new disksubsystem to the network. You want to provision the new disks and create new logical unit numbers （LUNs）to assign to a server named Server1. You open Storage Manager for SANs， but you can’t see the newhardware. However， you can connect to the new hardware by using the software provided by the vendor.You want to be able to manage the new disk subsystem you purchase by using Storage Manager for SANs. What should you do？（）

    • A、In Disk Management， chooses the Rescan Disks option.
    • B、Choose a disk subsystem from a vendor that has a Virtual Disk Service hardware provider.
    • C、On Server1， configures iSCSI Initiator to specify the new hardware as a favorite target.
    • D、Use Storage Explorer to configure Server1 as an iSNS server.

    正确答案:B

  • 第18题：

    单选题
    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
    解析： 暂无解析

  • 第19题：

    多选题
    You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage 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 failure happens 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.


    正确答案： E,D
    解析： 暂无解析

  • 第20题：

    单选题
    You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1and DG2with 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.


    正确答案： C
    解析： 暂无解析

  • 第21题：

    单选题
    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.


    正确答案： C
    解析： 暂无解析

  • 第22题：

    单选题
    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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    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


    正确答案： D
    解析： 暂无解析

  • 第24题：

    单选题
    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


    正确答案： C
    解析： 暂无解析

相关内容