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)- A13% (3)
- B4% (1)
- C75% (18)
- D8% (2)
Community Discussion
No community discussion yet for this question.