39.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?
A. You must recover all data files to the required system change number (SCN).
B. You must recover all data files, except those that are offline, to the required SCN .
C. You must recover all data files belonging to the USERS tablespace to the required SCN.
D. You cannot recover all data files because segment space management is performed manually for the undo tablespace.
Answer:B
40.You are using Oracle Database 10g. Which statement regarding an incomplete recovery is true?
A. You do not need to restore all the data files.
B. You do not need to open the database with the RESETLOGS operation.
C. You do not need to perform a full backup after the RESETLOGS operation.
D. You do not need to recover all the data files to the same system change number (SCN).
Answer:C
High quality and Value for the 1Z0-043 Exam.
Testpassport Practice Exams for oracle database 10g:administration ii 1Z0-043 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.
100% Guarantee to Pass Your 10g DBA exam and get your 10g DBA Certification.
We guarantee your success in the first attempt. If you do not pass the 1Z0-043 exam (oracle database 10g:administration ii) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free. TestPassport will help you to pass the 1Z0-043 exam. TestPassport 1Z0-043 contains 134 questions, multiple choice answers.
Powered By