Oracle
1Z0-034 · Question #38
1Z0-034 Question #38: Real Exam Question with Answer & Explanation
The correct answer is A. The table uses the default Flashback Data Archive.. See the full explanation below for the reasoning.
Question
Note the output of the following query: SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS -------------------------------------------------------------- FLA1 You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table: ALTERTABLEexchange_rateFLASHBACK ARCHIVE; What is the outcome of this command?
Options
- AThe table uses the default Flashback Data Archive.
- BThe Flashback Data Archive is created in the SYSAUX tablespace.
- CThe Flashback Data Archive is created in the same tablespace where the tables are stored.
- DThe command generates an error because no Flashback Data Archive name is specified and
Community Discussion
No community discussion yet for this question.