Exam 1z0-083 topic 1 question 4 discussion

A B F C incorrect, recycle bin not used for flashback version

In my opinion, B,D,F are correct

Last, UNDO is used for all Flashback features: "Oracle Flashback features use the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. They rely on undo data, which are records of the effects of individual transactions. For example, if a user runs an UPDATE statement to change a salary from 1000 to 1100, then Oracle Database stores the value 1000 in the undo data. Undo data is persistent and survives a database shutdown. It is retained for the time specified by undo_retention, or up to the tuned undo retention in the presence of Automatic Undo Management (AUM). By using flashback features, you can use undo data to query past data or recover from logical damage."

D is correct because the Time Travel (Archiver) is using tablespaces, but it is enabled per table: "Flashback Time Travel provides the ability to track and store transactional changes to a table over its lifetime... A Flashback Archive consists of one or more tablespaces or parts thereof... By default, Flashback Archive is not enabled for any tables. You can enable Flashback Archive for a table if all of these conditions are true:... When choosing a Flashback Archive for a specific table, consider the data retention requirements for the table and the retention times of the Flashback Archives on which you have the FLASHBACK ARCHIVE object privilege."

It is not A because flashback transaction query don't use two points in time necessarily, it is just a query for transaction metadata. You can utilize Flashback Version Query ("VERSIONS BETWEEN TIMESTAMP") as a subquery in a Flashback Transaction Query to associate each row version with the LOGON_USER responsible for the row data change "Oracle Flashback Transaction Query: Use this feature to retrieve metadata and historical data for a given transaction or for all transactions in a given time interval. To perform an Oracle Flashback Transaction Query, select from the static data dictionary view FLASHBACK_TRANSACTION_QUERY."

BDF

ABF, I AGREE

ABF is correct. D is not correct because it's about flashback of a Tablespace not table: A flashback data archive consists of one or more tablespaces or parts of tablespaces. When you create a flashback data archive, you specify the name, retention period, and tablespace

ABF A true --> FTQ uses UNDO. B true --> FD uses recyclebin C false --> FVQ does not use recyclebin. See F D false --> FDA use Flashback Archive Tablespace E false --> FD does not use undo. See B F true --> FVQ uses UNDO

I read the note Click to add to Favorites FDA - Flashback Data Archive Usage and Best Practices (a.k.a. Total Recall) (Doc ID 2370465.1). and use UNDO, then the aswer is BDF

A, B, and F are correct. C is wrong because FDA needs a user tablespace.

ABF 100 %

ABF is correct. A which is the most debated is right I just confirm from oracle document that flashback transaction query uses time interval

Why D? : Oracle Flashback features uses the Automatic Undo Management (AUM) system to obtain metadata and historical data for transactions. They rely on undo data, which are records of the effects of individual transactions.

Is there any reference about D? I think A B F but D is the most voted option. whY?

B D F - see yennism

C is incorrect, the recyclebin relates just to whole objects (segments), not to the individual rows