多项选择题
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
相关考题
-
单项选择题
YouworkasadatabaseadministratoratCertkiller.com.Inyourproductiondatabasethereisajob，CALC_STAT，whichhasbeenscheduledtoruneveryFridayat5.00p.m.CALC_STATupdatestheoptimizerstatisticsfortheobjectsownedbytheAPPSschema.Youwantthetasktobegeneric，therebyallowinguserstomodifytheattributesofthetaskatruntimewithoutaffectingtheoriginaltask.WhichcomponentofOracleSchedulermustyoudefinetoachievethis？（）
A. Window
B. Program
C. Job class
D. Window group -
单项选择题
Consider the following configuration： /devices/D1is a member of disk group dgroupA. /devices/D2is a member of disk group dgroupA. /devices/D3is a member of disk group dgroupA. You plan to add a new disk， /devices/D4，to the disk group dgroupA. You execute the following command： SQL> ALTER DISKGROUP dgroupA ADD DISK ’/devices/D*’； Which task would be accomplished by the command？（）
A. The command adds the new disk， D4， to the disk group.
B. The command would result in an error because the is no disk by the name "’/devices/D*’"
C. The command will be ignored because disks starting with "D" are already members of the disk group.
D. The command would result in an error because no wildcard characters can be used in the disk name.
E. The command first detaches all the member disks starting with "D"， and the reattaches them including the new disk. -
单项选择题
You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）
A. It would return information regarding only the last committed transaction.
B. It would return only the active transactions in all the undo segments in the database.
C. It would return only the committed transactions in all the undo segments in the database.
D. It would return both active and committed transactions in all the undo segments in the database.
E. It would return information regarding the transactions that began and were committed in the last 30 minutes.
