Oracle
1Z0-047 · Question #77
The first DROP operation is performed on PRODUCTS table using the following command: DROP TABLE products PURGE; Then you performed the FLASHBACK operation by using the following command: FLASHBACK…
The correct answer is D. It is not possible to recover the table structure, data, or the related indexes. See the full explanation below for the reasoning.
Question
The first DROP operation is performed on PRODUCTS table using the following command:
DROP TABLE products PURGE; Then you performed the FLASHBACK operation by using the following command:
FLASHBACK TABLE products TO BEFORE DROP; Which statement describes the outcome of the FLASHBACK command?
Options
- AIt recovers only the table structure.
- BIt recovers the table structure, data, and the indexes.
- CIt recovers the table structure and data but not the related indexes.
- DIt is not possible to recover the table structure, data, or the related indexes.
How the community answered
(52 responses)- A2% (1)
- B10% (5)
- C4% (2)
- D85% (44)
Community Discussion
No community discussion yet for this question.