多项选择题
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?()
单项选择题 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?()
单项选择题 You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()