Which three statements are true about using flashback database in a multitenant container database(CDB)?() A. The root container can be flashed back without flashing back the pluggable databases (PDBs).B. To enable flashback database, the CDB must be mounted.C. Individual PDBs can be flashed back without flashing back the entire cdb.D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
Which three statements are true about using flashback database in a multitenant container database(CDB)?()
A. The root container can be flashed back without flashing back the pluggable databases (PDBs).
B. To enable flashback database, the CDB must be mounted.
C. Individual PDBs can be flashed back without flashing back the entire cdb.
D. The DB_FLASHBACK RETENTION_TARGET parameter must be set to enable flashback of the cdb.
E. A CDB can be flashed back specifying the desired target point in time or an SCN, but not a restore point.
相关考题：
On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）A. Check the alert log fileB. Query the V$FLASHBACK_DATABASE_LOG viewC. Query the V$RECOVERY_FILE_DEST_SIZE viewD.Query the V$FLASHBACK_DATABASE_STAT viewE. Check the value assigned for the UNDO_RETENTION parameter
Youexecutedthefollowingqueryinyourdatabase:FROMV$FLASHBACK_DATABASE_LOGWhatwouldyoudeterminefromtheoutput?() A.thetimewhenthelastflashbackoperationinyourdatabasewasperformedB.thetimewhenthefirstflashbackoperationinyourdatabasewasperformedC.alistofflashbackoperationsperformedinyourdatabaseusingSCNandtimeD.theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase
ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT：SQLDESCV$FLASHBACK_DATABASE_STATNameNull？Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue？（）A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.
YouaremaintainingyourdatabaseinOracle10g.YouhavesetthevalueoftheSTATISTICS_LEVELinitializationparametertoTYPICALandthevalueoftheFAST_START_MTTR_TARGETparameterto900seconds.Toincreasetheperformanceofthedatabase，youwanttodeterminetheoptimalsizeoftheonlineredologfiles.Whichtoolenablesyoutodeterminetheoptimalsizeoftheonlineredologfiles？（）A.OracleEnterpriseManagerB.TheV$LOGviewC.TheV$LOGFILEviewD.TheV$FLASHBACK_DATABASE_LOGSview
YouareworkingasaDBAatNetFxCorporation.YoudiscoverthattheSCOTTschemaisdeletedbymistake.Youdecidetoflashthedatabasebacktothetimewhentheschemaexisted.Whichviewwillyouquerytodeterminetheestimatedsizeoftheflashbackdatathatyourequireforyourcurrenttargetretention？（）A.V$FLASHBACK_DATABASE_LOGB.V$FLASHBACK_DATABASE_STATC.V$DATABASED.V$UNDOSTAT
FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneofyourdatabaseuserserroneouslypurgedanimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10：00P.M.and10：30P.M.Thenextday，youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase，youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable？（）A.V$DATABASEB.V$UNDOSTATC.V$FLASHBACK_DATABASE_LOGD.V$FLASHBACK_DATABASE_STAT
At10：30A.M.，youranabatchjobbymistake，whichexecutedatransactioninthedatabase.Thetransactionidentifierofthetransactionthatmadetothechangesinthedatabaseis0500A00627B000.At11：10A.M.，youstoppedthebatchjob.Now，youwanttoidentifythechangesmadetothedatabasetablesbythebatchjob.Whichviewwillyouquery？（）A.DBA_PENDING_TRANSACTIONSB.DBA_AUDIT_STATEMENTC.V$FLASHBACK_DATABASE_STATSD.FLASHBACK_TRANSACTION_QUERY
Youarerequiredtoflashbackyourdatabase.Youwanttofindtheamountofflashbackdatageneratedsincethedatabasewasopened.Whichtaskwillyouperformtoobtaintherequiredinformation?() A.QuerytheV$FLASHBACK_DATABASE_LOGview.B.QuerytheV$FLASHBACK_DATABASE_STATview.C.CheckthevalueoftheDB_FLASHBACK_RETENTION_TARGETinitializationparameter.D.QuerytheV$RECOVERY_FILE_DESTview.
YouaremaintainingtheSALESdatabaseforanorganization.YouhaveenabledtheFlashbackDatabasefeatureandwanttoestimatetheflashbackspacerequiredforfutureoperations.Whichviewwouldyouquerytoestimatetheflashbackspacerequired？（）A.V$DATABASEB.V$FLASHBACK_DATABASE_STATC.V$FLASHBACK_DATABASE_LOGD.V$RECOVERY_FILE_DEST
Youexecutedthefollowingqueryinyourdatabase:SELECToldest_flashback_scn,oldest_flashback_timeFROMV$FLASHBACK_DATABASE_LOG;Whatwouldyoudeterminefromthe output?() A.Thetimewhenthelastflashbackoperationinyourdatabasewasperformed.B.Thetimewhenthefirstflashbackoperationinyourdatabasewasperformed.C.AlistofflashbackoperationsperformedinyourdatabaseusingSCNandtime.D.Theapproximatetimeandthelowestsystemchangenumber（SCN）towhichyoucanflashbackyourdatabase.