多选题Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance 

题目
多选题
Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）
A

increase the number of checkpoint processes

B

define the POWER option while adding or removing the disks

C

increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES

D

increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

E

increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

相似考题

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

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.Which two statements are true regarding an Automatic Storage Management (ASM) instance?() (Choosetwo.)A. As ASM instance mounts an ASM control fileB. An ASM instance uses the ASMB process for rebalancing of disks within a disk groupC. Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyD. An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

更多“多选题Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance ”相关问题

  • 第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 statement is true about the Manageability Monitor （MMON） background proces（）

    • A、It transfers statistics from memory to disk at regular intervals.
    • B、It coordinates the rebalance activity for disk groups when ASM is used.
    • C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.
    • D、It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.

    正确答案:A

  • 第3题：

    Which background process of a database instance，using Automatic Storage Management （ASM）， connects as a foreground process into the ASM instance？（）

    • A、 ASMB
    • B、 PMON
    • C、 RBAL
    • D、 SMON

    正确答案:A

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

    Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?（）

    • A、Define the POWER option while adding or removing the disks
    • B、Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
    • C、Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
    • D、Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

    正确答案:A,B

  • 第6题：

    Which background process of a database instance, using Automatic Storage Management (ASM), connects asa foreground process into the ASM instance?（）

    • A、ASMB
    • B、PMON
    • C、RBAL
    • D、SMON

    正确答案:A

  • 第7题：

    Which statement is true about the Manageability Monitor （MMON） background process（）

    • A、It transfers statistics from memory to disk at regular intervals.
    • B、It coordinates the rebalance activity for disk groups when ASM is used.
    • C、It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
    • D、It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

    正确答案:A

  • 第8题：

    多选题
    Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）
    A

    As ASM instance mounts an ASM control file

    B

    An ASM instance uses the ASMB process for rebalancing of disks within a disk group

    C

    Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly

    D

    An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started


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

    单选题
    Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（）
    A

     You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.

    B

     You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.

    C

     You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.

    D

     You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.


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

  • 第11题：

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

  • 第12题：

    单选题
    Which statement is true about the Manageability Monitor （MMON） background proces（）
    A

    It transfers statistics from memory to disk at regular intervals.

    B

    It coordinates the rebalance activity for disk groups when ASM is used.

    C

    It communicates with the Automatic Storage Management （ASM） instance on behalf of the databaseinstance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabledfor the database instance.


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

  • 第13题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance? （）

    • A、As ASM instance mounts an ASM control file
    • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
    • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
    • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

    正确答案:C,D

  • 第14题：

    Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）

    • A、 increase the number of checkpoint processes
    • B、 define the POWER option while adding or removing the disks
    • C、 increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
    • D、 increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
    • E、 increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

    正确答案:B,E

  • 第15题：

    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

  • 第16题：

    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

  • 第17题：

    Your database is configured on non-ASM disk storage. You need to migrate your database to ASM disk storage.  Which statement is true about migrating from non-ASM disk storage to ASM disk storage？（） 

    • A、 You can use the operating system utility to migrate from non-ASM disk storage to ASM disk storage.
    • B、 You cannot perform a database backup from non-ASM disk storage to tape and then move it to ASM disk storage.
    • C、 You can use the SWITCH DATABASE TO COPY Recovery Manager （RMAN） command to switch back to non-ASM disk storage if you have not deleted your original datafiles.
    • D、 You cannot use Recovery Manager （RMAN） to migrate from non-ASM disk storage to ASM disk storage if you are not using RMAN for your backup and recovery strategies.

    正确答案:C

  • 第18题：

    Which two statements are true regarding an Automatic Storage Management (ASM) instance?（） (Choosetwo.)

    • A、As ASM instance mounts an ASM control file
    • B、An ASM instance uses the ASMB process for rebalancing of disks within a disk group
    • C、Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitly
    • D、An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

    正确答案:C,D

  • 第19题：

    Immediately after adding a new disk to or removing an existing disk from an Automatic StorageManagement （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels.  Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）

    • A、increase the number of checkpoint processes
    • B、define the POWER option while adding or removing the disks
    • C、increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES
    • D、increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES
    • E、increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process

    正确答案:B,E

  • 第20题：

    单选题
    Which statement is true about the Manageability Monitor （MMON） background process（）
    A

    It transfers statistics from memory to disk at regular intervals.

    B

    It coordinates the rebalance activity for disk groups when ASM is used.

    C

    It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.

    D

    It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance


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

  • 第21题：

    多选题
    Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）
    A

    increase the number of checkpoint processes

    B

    define the POWER option while adding or removing the disks

    C

    increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES

    D

    increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

    E

    increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal


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

  • 第22题：

    多选题
    Immediately after adding a new disk to or removing an existing disk from an ASM instance, you find that the performance of the database goes down initially until the time the addition or removal process is completed, and then gradually becomes normal. Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?（）
    A

    Define the POWER option while adding or removing the disks

    B

    Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

    C

    Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES

    D

    Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES


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

  • 第23题：

    多选题
    Immediately after adding a new disk to or removing an existing disk from an Automatic StorageManagement （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels.  Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）
    A

    increase the number of checkpoint processes

    B

    define the POWER option while adding or removing the disks

    C

    increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES

    D

    increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

    E

    increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process


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

  • 第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
    解析： 暂无解析

相关内容