多项选择题
When performing a backup using Recovery Manager (RMAN), which four types of files can be backed up with the RMAN BACKUPcommand? ()
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 -
单项选择题
You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed, what would be the status of this backup after seven days?()
A. The backup would be marked as invalid.
B. The backup would be marked as obsolete.
C. The backup would be removed from the media.
D. The backup would be removed from the RMAN repository. -
单项选择题
Thewarningandcriticalthresholdvalueshavebeensetto85%and97%,respectively,foroneofthetablespaces.Thecurrenttablespacespaceusageis54%.Youmodifythewarningthresholdtobe50%andcriticalthresholdtobe53%inDatabaseControl.Whichstatementistrue?()
A. The new setting would be applied but no alerts would be raised immediately.
B. The new setting would be applied and an alert would be raised immediately.
C. The new setting would be ignored because the tablespace space usage is more than the specified threshold value.
D. The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
