單項(xiàng)選擇題

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.

你可能感興趣的試題

單項(xiàng)選擇題

ou are managing an Oracle Database 11g database. You want to take the backup of MULT_DATA, a big file tablespace of size 100 TB on tape drive, but you have tapedrives of only 10 GB each. Which method would accomplish the task quickly and efficiently?（）

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

單項(xiàng)選擇題

What is the implication of this command?（）

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.