You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed 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?

Question

Accepted Answer

D. until last Sunday's backup

Answer

A. until Thursday morning

Answer

B. until that point in time when the database is opened

Answer

C. until that point in time when the recovery is performed

Answer

E. until that point in time when the table is dropped and purged

Answer

F. until Wednesday evening

You have only two redo log groups and these groups get overwritten several times in a day. Your database operates in NOARCHIVELOG mode and user-managed consistent backups are performed every Sunday…

Question

Options

How the community answered

Community Discussion