1Z0-072 · Question #14
Which two can you use to recover a dropped table? (Choose two.)
The correct answer is D. FLASHBACK TABLE TO SCN E. FLASHBACK DROP. See the full explanation below for the reasoning.
Question
Options
- AFLASHBACK QUERY
- BFLASHBACK DATABASE
- CFLASHBACK TRANSACTION
- DFLASHBACK TABLE TO SCN
- EFLASHBACK DROP
How the community answered
(57 responses)- A5% (3)
- B9% (5)
- C2% (1)
- D84% (48)
Community Discussion
10
Dragan P.Feb 10, 2026D and E are your answers. FLASHBACK DROP pulls the table back out of the recycle bin using UNDROP syntax, and FLASHBACK TABLE TO SCN rewinds the table to a point in time before the drop occurred, provided you have enough undo retention to cover that SCN, which is the same Flashback Table mechanics that have been in place since 10g.
Mei-Ling H.Feb 13, 2026Agree on D and E, but worth flagging for the exam that FLASHBACK TABLE TO SCN also silently requires ROW MOVEMENT to be enabled on the table first, otherwise Oracle throws an error even when your undo retention is perfectly fine, and that detail shows up as a wrong-answer trap in the options.
Grace U.Jan 26, 2026What specifically confused you, the recycle bin restore or the SCN rollback?
Mei-Ling H.Feb 2, 2026I picked B and E first because FLASHBACK DATABASE sounded like it would bring everything back including the table, but then I noticed the question says "recover a dropped table," not "recover the whole database," so B is too broad and wrong. The word "drop" in option E points directly to FLASHBACK DROP which uses the recycle bin, and option D works too because FLASHBACK TABLE TO SCN can restore the table to a point before the DROP happened, so D and E are the two correct picks here.
Lena V.Feb 3, 2026Mei-Ling you have it right, just add that D only works if you know a valid SCN or timestamp before the drop and flashback logging is enabled, otherwise E via the recycle bin is the more reliable path in practice.
Anjali D.Feb 26, 2026I had B in my head at first because Flashback Database feels like the big recovery hammer, but then I remembered that it rolls back the whole database, not a single object, and once I focused on what actually targets a table specifically, D and E clicked because Flashback Table to SCN restores it in place and Flashback Drop pulls it straight out of the recycle bin. Anyone else get tripped up by B here?
Imani T.Mar 5, 2026I been going back and forth on this one but I keep landing on C and E. My thinking on FLASHBACK TRANSACTION is that if you dropped the table inside a transaction that also did other DML, you need to back out the whole transaction to get the table object back into a consistent state, and that is exactly what FLASHBACK TRANSACTION is designed for. The Oracle docs talk about transaction backout pretty clearly and dropping an object is still a transactional operation at the data dictionary level, so it follows that you could use it here. I know everyone jumps straight to E for FLASHBACK DROP because of the recycle bin, and yeah that one is solid, but dismissing C feels like leaving a tool on the table just because it is less obvious. The exam loves to test whether you know the full scope of a feature, not just the textbook use case, and I think that is exactly what they are going for with this question.
Anjali D.Mar 7, 2026Imani, I appreciate you digging into FLASHBACK TRANSACTION but the group landed on D and E because FLASHBACK TRANSACTION only backs out DML like inserts, updates, and deletes, not DDL, and a DROP TABLE is DDL that causes an implicit commit, so transaction backout simply cannot touch it. FLASHBACK TABLE (D) restores the table to a prior point in time via undo, and FLASHBACK DROP (E) pulls it from the recycle bin, which are the two paths Oracle actually gives you for recovering a dropped object.
Lena V.Mar 6, 2026I am locked in on A and E here. FLASHBACK QUERY lets you pull data from a past point in time using AS OF, so if you dropped a table you can query what was there and reconstruct it, and FLASHBACK DROP is the obvious recycle bin restore, which Oracle tests constantly on this exam.
Mei-Ling H.Mar 7, 2026Flashback Query (AS OF) only lets you read historical row data from a surviving table, it cannot recover a table that has already been dropped, so A does not apply here. D, Flashback Table, is the correct pairing with E because it restores a dropped or modified table object itself back to a prior state, which is exactly what the question is testing.