单项选择题
The current time is 12:00 noon. You want to recover the USERS tablespace from a failure that occurred at 11:50 a.m. You discover that the only member of an unarchived redo log group containing information from 11:40 a.m. onwards is corrupt. With reference to this scenario, if you are not using Recovery Manager (RMAN), which recovery method would you use?()
A. time-based recovery
B. log sequence recovery
C. cancel-based recovery
D. change-based recovery
相关考题
-
多项选择题
ImmediatelyafteraddinganewdisktoorremovinganexistingdiskfromanAutomaticStorageManagement(ASM)instance,youfindthattheperformanceofthedatabasedecreasesinitially,untiltheadditionorremovalprocessiscompleted.Performancethengraduallyreturnstonormallevels.Whichtwoactivitiescouldyouperformtomaintainaconsistentperformanceofthedatabasewhileaddingorremovingdisks?()
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.
