nerdexam
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

1Z0-043 question #89 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)
  • A
    13% (9)
  • B
    78% (53)
  • C
    6% (4)
  • D
    3% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice