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

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

相似考题

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. What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；A、 The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.B、 The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.C、 The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.D、 This command will fail because you cannot drop a specific disk in an ASM disk group.E、 The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.

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

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

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

  • 第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_LIMIT
    • B、ASM_DISKSTRING
    • C、ASM_DISKGROUPS
    • D、INSTANCE_TYPE

    正确答案:A

  • 第2题：

    Which of the following is a benefit of ASM fast disk resync?（）

    • A、Failed disks are taken offline immediately but are not dropped.
    • B、Disk data is never lost.
    • C、By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.
    • D、The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.
    • E、Hot spare disks are automatically configured and added to the disk group.

    正确答案:A

  • 第3题：

    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

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

  • 第6题：

    单选题
    You are an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.  What do you do？（）
    A

     Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.

    B

     Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to  its original value.

    C

     You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.

    D

     If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can  correct the problem and perform recovery.

    E

     Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.


    正确答案： 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题：

    单选题
    What is the net effect of the following command？（）   alter diskgroup dgroup1 drop disk abc；
    A

     The disk ABC will be dropped from the disk group. Since you did not issue a rebalance command，the data on that disk will be lost.

    B

     The command will raise an error indicating that you need to rebalance the disk group to remove the data from that disk prior to dropping the disk.

    C

     The disk group will be automatically rebalanced during the drop operation. Once the rebalancing is complete，the disk will be dropped.

    D

     This command will fail because you cannot drop a specific disk in an ASM disk group.

    E

     The disk drop command will be suspended for a predetermined amount of time，waiting for you to also issue an alter diskgroup rebalance command. Once you have issued the rebalance command，ASM will proceed to rebalance the disk group and then drop the disk.


    正确答案： 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 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
    解析： 暂无解析

  • 第11题：

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

  • 第12题：

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

  • 第13题：

    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

  • 第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 an Oracle DBA responsible for an ASM instance. The disk controller on your system fails. You suspect that the disk itself is okay. You know it will take 24 hours to replace the controller and you don’t want to have to rebuild the disks from scratch.  What do you do？（）  

    • A、 Take the whole disk group offline and wait for the controller card to be installed. Once it’s installed，bring the disk group online again.
    • B、 Change the ASM parameter ASM_PREFERRED_READ_FAILURE_GROUPS to indicate that you want to read from the non-failed disk. Once the disk controller is replaced，reset the parameter to  its original value.
    • C、 You have no choice but to rebuild the disk. Drop the disk from the disk group and wait for the controller to be replaced. Once the controller is replaced， add the disk back into the disk group and allow ASM to rebuild it.
    • D、 If you are using any setting other than REDUNDANCY EXTERNAL for your disk group，you will have to recover any data on that disk from a backup. The database will be unavailable until you can  correct the problem and perform recovery.
    • E、 Change the attribute DISK_REPAIR_TIME on the disk group to a time greater than 24 hours.

    正确答案:E

  • 第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 in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a single Database Mail profile. Reports are sent to all the company employees by using the Mail profile. During office hours, a large volume of reports are sent by the sp_send_dbmail stored procedure. Now you notice that it takes a long time for the reports to be sent to the company manager. As the technical support, you have to speed up the delivery. So what action should you perform to achieve this goal?（）  

    • A、Another SMTP account should be added to the existing Database Mail profile 
    • B、When you send the reports to the manager, you should use the @importance = high parameter. 
    • C、You should change the Account Retry Attempts option of the Database Mail system properties 
    • D、You should configure a new Database Mail profile. The new one will be used for sending the reports to the manager. 

    正确答案:D

  • 第18题：

    单选题
    Which of the following is a benefit of ASM fast disk resync?（）
    A

    Failed disks are taken offline immediately but are not dropped.

    B

    Disk data is never lost.

    C

    By default, the failed disk is not dropped from the disk group ever, protecting you from loss of that disk.

    D

    The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.

    E

    Hot spare disks are automatically configured and added to the disk group.


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

  • 第19题：

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

  • 第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 the network administrator for ExamSheet. Your Windows 2000 Professional computer contains a single hard disk configured with two NTFS partitions C and D. You want to move a folder named Sales from the C partition to a folder named Corp on the D partition.  You want the files in the Sales folder to still be compressed after moving the folder. You want the files in the Corp folder to remain uncompressed. You want to ensure that the files are recoverable in case of any disk problems. You also want to move the files with the least amount of administrative effort.   What should you do?（）
    A

    Back up the Sales Folder. Move the Sales folder to the Corp folder. Compress the Sales folder

    B

    Back up the Sales folder. Copy the Sales folder to the Corp folder

    C

    Copy the Sales folder to a second computer. Then move the Sales folder to the Corp folder

    D

    Run the commandxcopy.exe c：/Sales d：/Corp /S /C


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

  • 第23题：

    单选题
    Which of the following is a benefit of ASM fast disk resync？（）
    A

     Failed disks are taken offline immediately but are not dropped.

    B

     Disk data is never lost.

    C

     By default， the failed disk is not dropped from the disk group ever， protecting you from loss of that disk.

    D

     The failed disk is automatically reformatted and then resynchronized to speed up the recovery process.

    E

     Hot spare disks are automatically configured and added to the disk group.


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

相关内容