1Z0-034 · Question #38
Note the output of the following query: SQL> SELECTflashback_archive_name,status FROM dba_flashback_archive; FLASHBACK_ARCHIVE_NAMESTATUS --------------------------------------------------------------
Sign in or unlock 1Z0-034 to reveal the answer and full explanation for question #38. The question stem and answer options stay visible for context.
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
Unlock 1Z0-034 to see the answer
You've previewed enough free 1Z0-034 questions. Unlock 1Z0-034 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.