45.You are working on an Oracle Database 10g database that operates in the ARCHIVELOG mode. At 06:00 p.m., you discovered that a table in the SYSTEM tablespace that does not belong to the data dictionary was dropped at 03:00 p.m.What would you do to recover the table?
A. perform point-in-time recovery to recover the table
B. recover the table by using the Flashback Table feature
C. restore the entire database from the most recent backup and open it
D. use the Flashback Transaction Query feature to identify the relevant SQL statement and use it to undrop the table
Answer:A
46.A data file became corrupted in your database due to bad sectors on the disk. Because of corruption, you lost all the important tables in that data file.Which method would you use for recovery?
A. flash back all the tables in the data file, one by one
B. restore the data file to a new location and perform a media recovery
C. flash back the database; there is no need to restore the data file
D. restore the data file from the most recent backup and flash back the database
Answer:B
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