Oracle
1Z0-043 · Question #182
You executed the following FLASHBACK TABLE command: FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi'); Which two statements are correct? (Choose two.)
The correct answer is C. The changes made to the EMP table since the specified time will be undone. E. The FLASHBACK TABLE statement will be executed within a single transaction. See the full explanation below for the reasoning.
Question
You executed the following FLASHBACK TABLE command:
FLASHBACK TABLE emp TO TIMESTAMP ('11:45','hh12:mi'); Which two statements are correct? (Choose two.)
Options
- AThe FLASHBACK TABLE statement will not be written to the alert log file.
- BThe EMP table that was dropped by mistake from the database will be restored.
- CThe changes made to the EMP table since the specified time will be undone.
- DThe FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.
- EThe FLASHBACK TABLE statement will be executed within a single transaction.
- FThe list of transactions that have modified the EMP table since the specified time will be displayed.
How the community answered
(21 responses)- B14% (3)
- C71% (15)
- D10% (2)
- F5% (1)
Community Discussion
No community discussion yet for this question.