nerdexam
Oracle

1Z0-032 · Question #23

In your test database, users complain that they are getting the following error while executing a query on the ORDERS table: ERROR at line 1: ORA-00942: table or view does not exist Oracle 1Z0-032…

The correct answer is C. Time-Based incomplete database recovery. See the full explanation below for the reasoning.

Question

In your test database, users complain that they are getting the following error while executing a query on the ORDERS table:

ERROR at line 1:

ORA-00942: table or view does not exist Oracle 1Z0-032 Exam While investigating the reason, you find that the table has been dropped accidentally. You do not have any logical backup of the ORDERS table, but you performed a closed database backup two days back and your database is running in ARCHIVELOG mode. Which type of recovery would you perform to recover the ORDERS table?

Options

  • AOpen Database complete recovery
  • BClosed Database complete recovery
  • CTime-Based incomplete database recovery
  • DDatabase recovery using backup control file

How the community answered

(24 responses)
  • A
    13% (3)
  • B
    4% (1)
  • C
    75% (18)
  • D
    8% (2)

Community Discussion

No community discussion yet for this question.

Full 1Z0-032 Practice