YouworkasadatabaseadministratorforSupportcenter.cn.Yourdatabaseisconfiguredforautomaticundomanagement.UNDO_RETENTIONissetto3hours.Youwanttoflashbackatablethatwascreatedlastyear.Howfarbackcantheflashbackquerygo？（）A.3 hoursB.6 monthsC.until last yearD.until last commitE.until the point when the undotablespacewas refreshedF.until the database is shut down and the memory erased

单项选择题

You work as a database administrator for Supportcenter.cn. Your database is configured for automatic undo management. UNDO_RETENTION is set to 3 hours. You want to flash back a table that was created last year. How far back can the flashback query go？（）

A.3 hours
B.6 months
C.until last year
D.until last commit
E.until the point when the undotablespacewas refreshed
F.until the database is shut down and the memory erased

1Z0-042