Oracle
1Z0-043 · Question #74
1Z0-043 Question #74: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-043 to reveal the answer and full explanation for question #74. The question stem and answer options stay visible for context.
Question
Your database operates in ARCHIVELOG mode. User-managed consistent backups are performed every Sunday night. On Tuesday, client A drops a table at 8:00 a.m.as follows: SQL> DROP TABLE cust_ord PURGE; Table dropped. Client B executes a query at 9:00 a.m.on the same table as follows: SQL> SELECT * FROM cust_ord SELECT * FROM cust_ord * ERROR at line 1: ORA-00942: table or view does not exist Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?
Options
- Aretrieve the table by using the flashback feature
- Brestore all the data files from last Sunday's backup and then perform a time-based recovery
- Crestore all the data files from last Sunday's backup and then perform a log sequence recovery
- Drestore all the data files from last Sunday's backup and then perform a cancel-based recovery
- Erestore from last Sunday's backup only data files that belong to the tablespace in which the table
Unlock 1Z0-043 to see the answer
You've previewed enough free 1Z0-043 questions. Unlock 1Z0-043 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.