Oracle
1Z0-043 · Question #109
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? (Choose all that apply)
The correct answer is D. To view changes made by all the transactions during a given period of time. E. To view changes made by a single transaction during a given period of time. See the full explanation below for the reasoning.
Question
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? (Choose all that apply)
Options
- ATo recover a dropped table.
- BTo recover a dropped schema.
- CTo recover data from a truncated table.
- DTo view changes made by all the transactions during a given period of time.
- ETo view changes made by a single transaction during a given period of time.
How the community answered
(23 responses)- A4% (1)
- B4% (1)
- C9% (2)
- D83% (19)
Community Discussion
No community discussion yet for this question.