43.You are working on Oracle Database 10g, which is in ARCHIVELOG mode. All the archived log files are intact.In which scenario would performing a recovery require the opening of the database with the RESETLOGS option?
A. loss of a tempfile
B. loss of a system data file
C. loss of one of the control files
D. loss of one of the tablespaces
E. loss of a member from each redo log group
F. loss of the only member of an unarchived redo log group
Answer:F
44.Every Sunday, consistent backups are performed on your database. Because of a user error, you performed an incomplete recovery on Tuesday and opened the database with the RESETLOGS option.A user error occurs again on Thursday, which necessitates an incomplete recovery. Sunday's backup is the most recent backup available. What would you do in this scenario?
A. recovery cannot be performed because a backup was not performed after the last incomplete recovery
B. restore all the files from Sunday's backup, and then perform an incomplete recovery up to the point in time when the user error occurred on Thursday
C. restore all the files from Sunday's backup, and then recover up to the point in time when the RESETLOGS operation was performed on Tuesday
D. restore all the files from Sunday's backup, and open the database to reset the database to the point in time when the backup was performed on Sunday
Answer:B
High quality and Value for the 1Z0-043 Exam.
Killtest 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.
