多选题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?()Aincrease the number of checkpoint processesBdefine the POWER option while adding or removing the disksCincrease the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESDincrease the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVESEincrease the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process

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


参考解析

解析: 暂无解析

相关考题:

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

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

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

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.

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

Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()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 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 processesB、 define the POWER option while adding or removing the disksC、 increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESD、 increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVESE、 increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

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

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

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、 ASMBB、 ARBnC、 RBAL in the ASM instanceD、 RBAL in the database instance

You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario?()A、 The disk is immediately dropped from the disk group.B、 The ASM tracks the extents that are modified during the outaC、 The ASM migrates the extents from the unavailable disk to the remaining disks.D、 The disk automatically goes offline.

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 disksB、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_PROCESSESD、Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

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.

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

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

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 processesB、define the POWER option while adding or removing the disksC、increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESD、increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVESE、increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal process

多选题Which two statements are true regarding an Automatic Storage Management (ASM) instance? ()AAs ASM instance mounts an ASM control fileBAn ASM instance uses the ASMB process for rebalancing of disks within a disk groupCAutomatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameter is not set explicitlyDAn RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

多选题As the DBA, you run the following query on your ASM instance. What is the implication of the results of the query?() SQL select group_number, name, state from v$ASM_DISKGROUP;  GROUP_NUMBER NAME STATE  0 DGROUP1 DISMOUNTED  2 DGROUP2 MOUNTED  3 DGROUP3 MOUNTEDAThe DGROUP1 disk group was unmounted by another DBA.BA datafile has been lost, causing the ASM disk group DGROUP1 to go into the DISMOUNTED stateCOne of the redundant disks (DGROUP1) has been lost in a disk group.DThis query has no meaning in an ASM instance.EA disk associated with a disk group was discovered after the ASM instance initially opened.

单选题Which statement is true about the Manageability Monitor (MMON) background process()AIt transfers statistics from memory to disk at regular intervals.BIt coordinates the rebalance activity for disk groups when ASM is used.CIt communicates with the Automatic Storage Management (ASM) instance on behalf of the database Instance.DIt performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

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

多选题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?()Aincrease the number of checkpoint processesBdefine the POWER option while adding or removing the disksCincrease the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESDincrease the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVESEincrease the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

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

多选题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?()ADefine the POWER option while adding or removing the disksBIncrease the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.CIncrease the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSESDIncrease the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES

单选题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?()Amount the new disk group in the ASM instanceBrestart the ASM instance and the production database instanceCregister the new disk groups in the production database instanceDrestart the ASM instance without restarting the production database instanceEinclude the new disk group in the ASM_DISKSTRING parameter in the parameter file and restart the ASM instance

单选题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 ASMBB ARBnC RBAL in the ASM instanceD RBAL in the database instance

多选题You are managing an Oracle Database 11g ASM instance having three disks in a disk group with ASM compatibility attribute set to 11.1.0 and redundancy set to high. One of the disks in the disk group becomes unavailable because of power failure.  Which statements will be true in this scenario?()AThe disk is immediately dropped from the disk group.BThe ASM tracks the extents that are modified during the outaCThe ASM migrates the extents from the unavailable disk to the remaining disks.DThe disk automatically goes offline.

多选题You are managing an Oracle Database 11g instance and an Oracle Database 10g instance on the same machine. Both instances use the ASM instance as storage. Which statement regarding the ASM disk group compatibility attributes are true in this scenario?()AThe database-compatibility version settings for each instance must be greater than or equal to the RDBMS compatibility of all ASM disk groups used by that database instances.BRDBMS compatibility and the database version determines whether a database instance can mount the ASM disk group.CThe RDBMS compatibility settings for a disk group control the format of data structures for ASM metadata on the disk.DASM compatibility controls which features for the ASM will be enabled.