多项选择题
These are the details about V$FLASHBACK_DATABASE_STAT: SQL> DESC v$FLASHBACK_DATABASE_STAT
Name Null? Type
------------- -------- --------------
BEGIN_TIME DATE
END_TIME DATE
FLASHBACK_DATA NUMBER
DB_DATA NUMBER
REDO_DATA NUMBER
ESTIMATED_FLASHBACK_SIZE NUMBER
Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()
A. BEGIN_TIME is the time at which Flashback logging is enabled.
B. END_TIME is the time at which the query is executed on the view.
C. REDO_DATA is the number of bytes of redo data written during the interval.
D. This view contains information about flashback data pertaining to the last 24 hours.
E. FLASHBACK_DATA is the amount of flashback data generated since the database was opened.
相关考题
-
单项选择题
YouwererecentlyhiredbyCertkiller.comasadatabaseadministrator.Youareaskedtofindoutwhetherthecurrentlyfunctionallistenerprocess,namedL1,hasbeenpasswordprotectedornot.Youarenotfamiliarwiththefilesystemoftheneworganization.Howwouldyouaccomplishthetask?()
A. by using the STATUS command of the Listener control utility
B. by using the STATUS L1 command of the Listener control utility
C. by using the SHOW RULES command of the Listener control utility
D. by using the SET PASSWORD command of the Listener control utility
E. by searching for the PASSWORD_LISTENER entry in the listener.ora file -
多项选择题
WhenperformingabackupusingRecoveryManager(RMAN),whichfourtypesoffilescanbebackedupwiththeRMANBACKUPcommand?()
A. data file
B. password file
C. archivelog file
D. temporary file
E. online redo log file
F. the current control file
G. the tnsnames.ora file
H. current server parameter file -
单项选择题
YouworkasadatabaseadministratoratCertkiller.com.Youareworkinginanonlinetransactionprocessing(OLTP)environment.Yourealizethatthesalaryforanemployee,John,hasbeenaccidentallymodifiedintheEMPLOYEEStable.Twodaysago,thedatawasinthecorrectstate.Flashbacklogsgeneratedduringlasttwodaysareavailableintheflashrecoveryarea.Whichoptionwouldyouchoosetobringthedatatothecorrectstatewhileensuringthatnootherdatainthesametableisaffected?()
A. perform point-in-time recovery
B. perform a Flashback Table operation to restore the table to the state it was in two days ago
C. perform a Flashback Database operation to restore the database to the state it was in two days ago
D. perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements, and then use them for recovery
