nerdexam
Microsoft

98-364 · Question #122

You want to recover one or more tablespaces to a point in time older than the rest of the database. Which of the following are the recovery situations in which tablespace Point-in-Time Recovery…

The correct answer is A. To recover a tablespace that contains rollback segments. B. To recover a table that has become logically corrupted. C. To recover a DML statement that has affected only a subset of the database. See the full explanation below for the reasoning.

Question

You want to recover one or more tablespaces to a point in time older than the rest of the database. Which of the following are the recovery situations in which tablespace Point-in-Time Recovery (TSPITR) should be used? Each correct answer represents a part of the solution. Choose all that apply.

Options

  • ATo recover a tablespace that contains rollback segments.
  • BTo recover a table that has become logically corrupted.
  • CTo recover a DML statement that has affected only a subset of the database.
  • DTo recover a tablespace on a very large database.

How the community answered

(29 responses)
  • A
    79% (23)
  • D
    21% (6)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice