单项选择题
Note the output of the following query;
SQL> SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1
You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;
What is the outcome of this command?()
A. The table uses the default Flashback Data Archive.
B. The Flashback Data Archive Is created In the SYSAUX tablespace.
C. The Flashback Data Archive is created in the same tablespace where the tables are stored.
D. The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.
相关考题
-
单项选择题
Whichofthefollowingmethodscanbeusedtodetectblockcorruption?()
A. ANALYZE operations
B. dbv
C. SQL queries that access the potentially corrupt block
D. RMAN
E. All of the above -
单项选择题
Whichofthefollowingisnotanadvantageofblockmediarecovery(BMR)?()
A. Reduced MTTR.
B. Datafiles remain offline while corrupt blocks are repaired.
C. Datafiles remain online while corrupt blocks are repaired.
D. A and C -
单项选择题
ChoosethecorrectordertopackageanduploaddataforanincidenttoOracleSupport.()
A. Schedule,create new package,view manifest,view contents
B. Create new package,view manifest,view contents,schedule
C. Schedule,create new package,view contents,view manifest
D. Create new package,view contents,view manifest,schedule
E. None of the above.
