Oracle
1Z0-034 · Question #38
Note the output of the following query: SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS…
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
How the community answered
(56 responses)- A82% (46)
- B5% (3)
- C11% (6)
- D2% (1)
Community Discussion
No community discussion yet for this question.