Home » Oracle » 1z0-083 » Which three are true about requirements for various FLASHBACK operations?
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.
Correct Answer: ABC
Explanation/Reference:
Reference: https://books.google.com.pk/books?id=0iwrL9P25Z0C&pg=PA35&lpg=PA35&dq=FLASHBACK+transaction+query+requires+undo+to+retrieve+all+versions+of+a+row+that+existed+between+two+points+in
+time&source=bl&ots=MJnYl5CZ1u&sig=ACfU3U0dWP-NPd-U8uu3zbaoi3YZzT0FTQ&hl=en&sa=X&ved=2ahUKEwigi5_Jl9joAhXzUBUIHUh4DksQ6AEwAnoECAsQJg#v=onepage&q=FLASHBACK%20transaction%20query%20requires%
20undo%20to%20retrieve%20all%20versions%20of%20a%20row%20that%20existed%20between%20two%20points%20in%20time&f=false https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables011.htm
Download Printable PDF. VALID exam to help you PASS.
|
|
ABF
FLASHBACK transaction query is using undo but the question is asking to retrieve all versions of a row that existed between two points in time. This is done by using the FLASHBACK version query and FLASHBACK version query is using undo as well. Thus, A is incorrect and F is correct.
As FLASHBACK version query is using undo instead of recycle bin, so C is correct too.
The correct answer is BDF.