Which two statements are true about Flashback Version Query?
A.
The result of a query can be used as part of a DML statement.
B.
It can be used to create views.
C.
It can be used only if Flashback Data Archive is enabled for a table.
D.
It retrieves all versions of rows that exist in a time interval, including the start time and end time.
E.
It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the
change.
ans D,E
A,D is the answer.
To undo a change the SQL needed is available in FLASHBACK_TRANSACTION_QUERY
E is FLASHBACK_TRANSACTION_QUERY VIEW column name UNDO_SQL ?
Yes ! But the question is about Flashback version query. By the way, did you give the exam already ?
I understand. Thank you.
Ans A,D
Next month’s exam
Okay.. I am giving it tomorrow… Will keep you posted..
Gave the exam yesterday.. cleared with 75%… Whats your linked in profile ? We will discuss there …
Congratulations on your success.
How was the question rate?
I passed the exam today. The result was 78% and the question rate was 80%