Oracle
1Z0-043 · Question #89
View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m.You noticed this at 11:00 a.m. and you want to perform an incomplete…
The correct answer is B. You must recover all data files, except those that are offline, to the required SCN. See the full explanation below for the reasoning.
Question
View the Exhibit. One of the important tables in the USERS tablespace was dropped and purged from the recycle bin at 9:00 a.m.You noticed this at 11:00 a.m. and you want to perform an incomplete recovery to recover the table. Which statement is true?
Exhibit
Options
- AYou must recover all data files to the required system change number (SCN).
- BYou must recover all data files, except those that are offline, to the required SCN.
- CYou must recover all data files belonging to the USERS tablespace to the required SCN.
- DYou cannot recover all data files because segment space management is performed manually for the
How the community answered
(68 responses)- A13% (9)
- B78% (53)
- C6% (4)
- D3% (2)
Community Discussion
No community discussion yet for this question.
