Which three are true about requirements for various FLASHBACK operations? (Choose three.)
Which three are true about requirements for various FLASHBACK operations? (Choose three.)
FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time. FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON. FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time. The RECYCLEBIN parameter is not involved in FLASHBACK version query, and FLASHBACK DATA ARCHIVE does not rely on undo to store all row versions. Therefore, the correct answers are that FLASHBACK operations requiring undo are FLASHBACK transaction query and FLASHBACK version query, and FLASHBACK drop requires the RECYCLEBIN to be set to ON.
A B F C incorrect, recycle bin not used for flashback version
Janw, did you passed in test 083? I fault today. Do you study for here?
what was your score? i was also studying from this, but i have noticed so many wrong answers
are you following the tool answer or comment answers ? I'm starting to study now for this exam.
i agree!!!
In my opinion, B,D,F are correct
D is false. "Use the CREATE FLASHBACK ARCHIVE statement to create a flashback archive, which provides the ability to automatically track and archive transactional data changes to specified database objects. A flashback archive consists of multiple tablespaces and stores historic data from all transactions against tracked tables. The data is stored in internal history tables."
ABF correct
A B F is correct
ABF 100 %
A is wrong, flashback transaction query don't use two points in time. https://www.techtarget.com/searchoracle/tip/How-to-perform-Oracle-Flashback-Transaction-Queries C is wrong, flashback version don't use recyclebin E is wrong flashback drop use recyclebin
Yes, you can query between two points in time: SELECT xid, logon_user FROM flashback_transaction_query WHERE xid IN ( SELECT versions_xid FROM employees VERSIONS BETWEEN TIMESTAMP TO_TIMESTAMP('2003-07-18 14:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_TIMESTAMP('2003-07-18 17:00:00', 'YYYY-MM-DD HH24:MI:SS') ); Example from: https://docs.oracle.com/en/database/oracle/oracle-database/19/adfns/flashback.html#GUID-212A4073-ABE2-4053-A852-3A41DEF6A24D
hello Yennism A is right Flashback transaction query uses time interval see below oracle document https://docs.oracle.com/cd/B14117_01/appdev.101/b10795/adfns_fl.htm
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 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