单项选择题
You lost the PRODSTD tablespace, which was read/write. The tablespace was read-only when the last backup was performed. How would you recover the tablespace?()
A. restore the tablespace from the backup; there is no need to apply the redo information
B. restore the full database to recover the data up to the point when you performed the backup
C. restore the tablespace from the backup and then perform a recovery using the backup control file
D. restore the tablespace from the backup and then recover the tablespace; all the redo information from the point when the tablespace was made read/write is applied
相关考题
-
单项选择题
Thecurrenttimeis12:00noon.YouwanttorecovertheUSERStablespacefromafailurethatoccurredat11:50a.m.Youdiscoverthattheonlymemberofanunarchivedredologgroupcontaininginformationfrom11:40a.m.onwardsiscorrupt.Withreferencetothisscenario,ifyouarenotusingRecoveryManager(RMAN),whichrecoverymethodwouldyouuse?()
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
