单项选择题
A.timebased recovery
B.log sequence recovery
C.cancelbased recovery
D.changebased recovery
多项选择题 YourdatabaseisfunctioninginARCHIVELOGmode.Inwhichtwosituationswouldyouperformacancelbasedrecovery?()
单项选择题 You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and usermanaged consistent backups are performed every Sunday night. On Thursday morning, you find that an important table has been dropped and purged. With reference to this scenario, up to what point in time can the data be recovered?()
单项选择题 YourdatabaseoperatesinARCHIVELOGmodeandusermanagedconsistentbackupsareperformedeverySundaynight.OnTuesday,at9:00a.m.thecurrentlogsequencenumberwas369.Also,onTuesdayyoulostthedatafilebelongingtotheSYSTEMtablespaceandanarchivelogfile(sequencenumber356)thatcontainedredoentriesbetween8:00a.m.and8:30a.m.Withreferencetothisscenario,whatwouldyoudotorecoverthedatabase?()