Oracle
1Z0-043 · Question #191
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data…
The correct answer is D. perform point-in-time recovery to recover the table. See the full explanation below for the reasoning.
Question
You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m. What would you do to recover the table?
Options
- Ause the Flashback Transaction Query feature to identify the relevant SQL statement and use it to
- Brestore the entire database from the most recent backup and open it
- Crecover the table by using the Flashback Table feature
- Dperform point-in-time recovery to recover the table
How the community answered
(25 responses)- A8% (2)
- B4% (1)
- C4% (1)
- D84% (21)
Community Discussion
No community discussion yet for this question.