What is a flashback query and when should it be used?
Answer / Kamlesh Pushkar
Flashback Query allows you to query an earlier version of a table as it appeared at a specific point in time. It's useful when you need to recover data that was deleted or modified, or when you want to compare the state of a table between two points in time.
| Is This Answer Correct ? | 0 Yes | 0 No |
How is incremental backup different from differential backup?
Why do we use materialized view instead of table or views?
What is a password file in a database and why is it required when a user can be authenticated using data dictionary tables?
What is the load balancing advisory?
Mention what is split brain syndrome in rac?
What is an explain plan and how does it help in optimizing the sql query?
Mention what is the volume management techniques used in oracle rac?
Mention what is the function of cache fusion in oracle rac?
Explain the oracle real application clusters architecture?
Mention how oracle flex asm works?
How oracle flex asm works?
What is new feature in oracle asm 12c?