Oracle
1Z0-050 · Question #35
View the Exhibit and examine the output. You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table: ALTER TABLE exchange_rate FLASHBACK ARCHIVE; What is the…
The correct answer is D. The command generates an error because no Flashback Archive name is specified and there is. See the full explanation below for the reasoning.
Question
View the Exhibit and examine the output. You executed the following command to enable Flashback Data Archive on the EXCHANGE_RATE table:
ALTER TABLE exchange_rate FLASHBACK ARCHIVE; What is the outcome of this command?
Exhibit
Options
- AThe table uses the default Flashback Archive.
- BThe Flashback Archive is created on the SYSAUX tablespace.
- CThe Flashback Archive is created on the same tablespace where the tables are stored.
- DThe command generates an error because no Flashback Archive name is specified and there is
How the community answered
(42 responses)- A2% (1)
- B14% (6)
- C5% (2)
- D79% (33)
Community Discussion
No community discussion yet for this question.