Topic: 1z0-083 topic 1 question 4

Which three are true about requirements for various FLASHBACK operations? (Choose three.)

A.
FLASHBACK transaction query requires undo to retrieve all versions of a row that existed between two points in time.
B.
FLASHBACK drop requires that the RECYCLEBIN parameter be set to ON.
C.
FLASHBACK version query requires that the RECYCLEBIN parameter be set to ON.
D.
FLASHBACK DATA ARCHIVE requires undo to store all versions of all rows of a table being tracked.
E.
FLASHBACK drop requires undo to retrieve all versions of a row that existed between two points in time.
F.
FLASHBACK version query requires undo to retrieve all versions of a row that existed between two points in time.

  • janw
  • New member
  • Offline

Re: 1z0-083 topic 1 question 4

A
B
F

C incorrect, recycle bin not used for flashback version

Re: 1z0-083 topic 1 question 4

Janw, did you passed in test 083? I fault today. Do you study for here?

Re: 1z0-083 topic 1 question 4

what was your score? i was also studying from this, but i have noticed so many wrong answers

Re: 1z0-083 topic 1 question 4

are you following the tool answer or comment answers ? I'm starting to study now for this exam.

  • ama
  • New member
  • Offline

Re: 1z0-083 topic 1 question 4

i agree!!!

Re: 1z0-083 topic 1 question 4

In my opinion, B,D,F are correct

Re: 1z0-083 topic 1 question 4

ABF, I AGREE

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

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

  • auwia
  • New member
  • Offline

Re: 1z0-083 topic 1 question 4

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

  • _gio_
  • New member
  • Offline

Re: 1z0-083 topic 1 question 4

ABF 100 %

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

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.

  • j_tw
  • New member
  • Offline

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

B D F - see yennism

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

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."

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

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

Re: 1z0-083 topic 1 question 4

ABF correct

Re: 1z0-083 topic 1 question 4

A B F  is correct