Which three statements are true about Flashback Data Archive?
A.
Flashback Data Archive prevents flashback queries from getting a snapshot too-old error.
B.
A table enabled for Flashback Data Archive cannot be dropped unless Flashback Data Archive is disabled or disassociated first.
C.
To enable Flashback Data Archive for a table, it is mandatory to have a default Flashback Data Archive for a database.
D.
While enabling Flashback Data Archive for a table, if no name is provided for Flashback Data Archive, it is enabled using the default Flashback Data Archive.
E.
To use Flashback Data Archive, users must have unlimited quota on the Flashback Data Archive tablespace.
Looks like ABD
Use Flashback Data Archive to automatically track and archive both regular queries and Oracle Flashback Query, ensuring SQL-level access to the versions of database objects without getting a snapshot-too-old error. For more information, see Using Flashback Data Archive (Oracle Total Recall).
****
Using any of the following DDL statements on a table enabled for Flashback Data Archive causes error ORA-55610:
ALTER TABLE statement that does any of the following:
Drops, renames, or modifies a column
Performs partition or subpartition operations
Converts a LONG column to a LOB column
Includes an UPGRADE TABLE clause, with or without an INCLUDING DATA clause
DROP TABLE statement
***
If you are logged on as SYSDBA, you can also specify that this is the default Flashback Data Archive for the system. If you omit this option, you can still make this Flashback Data Archive the default later
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
alipilot2006
Highly Voted 5 years, 7 months agomihanik
Most Recent 4 years, 5 months agoKalinos20
4 years, 10 months agosherifelia
4 years, 10 months ago