单项选择题
You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?()
A.The Flashback Archive FLA1 is dropped only if it is empty.
B.The tablespace having Flashback Archive is dropped.
C.The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive.
D.The Flashback Data Archive and historical data are dropped.
相关考题
-
单项选择题
ouaremanaginganOracleDatabase11gdatabase.YouwanttotakethebackupofMULT_DATA,abigfiletablespaceofsize100TBontapedrive,butyouhavetapedrivesofonly10GBeach.Whichmethodwouldaccomplishthetaskquicklyandefficiently?()
A.parallel image copy backup
B.backup with MAXPIECESIZE configured for the channel
C.parallel backup with MAXPIECESIZE configured for the channel
D.intrafile parallel backup -
单项选择题
Whatistheimplicationofthiscommand?()
A.The command produces an error because the retention time cannot be reduced.
B.All historical data is retained but the subsequent flashback data archives are maintained for only three years.
C.All historical data is purged and the new flashback data archives are maintained for three years.
D.All historical data older than three years is purged from the flashback archive FLA1. -
单项选择题
Whileperformingthebackupoftheflashrecoveryarea,younoticethatoneofthearchivedredologfilesismissing.Youhavemultipledestinationsforarchivedredologfiles.Whatimplicationsdoesithaveonthebackupoftheflashrecoveryarea?()
A.The backup fails because one of the archived redo log files is missing.
B.The backup succeeds but it would be without the missing archived log.
C.During backup, you are prompted for the alternative destination for the missing archived redo log file.
D.The backup succeeds because it fails over to one of the alternative archived redo log destinations.
