《11gOCP-1Z0-053.206道》.pdf

1Z0-053 Oracle Database 11g: Administration II Exam A QUESTION 1 What are the prerequisites for performing flashback transactions? (Choose all that apply) A. Supplemental log must be enabled B. Supplemental log must be enabled for the primary key C. Undo retention guarantee for the database must be configured D. ”EXECUTE “ permission on the DBMS_FLASHBACK package must be granted to the user Answer: ABD Explanation/Reference: Section: Flashback Operations Configuration /30/Oracle-11g-Flashback-Transaction-in-OEM-LogMiner-Interface.html /books?id=14ZH0eZV6G8Cpg=PA123lpg=PA123dq=flashback+transaction +prerequisitesource=blots=brh9_V- 4Wzsig=4PvpL2uM1xTf2eKkpoKKmaI8RkYhl=enei=ZSL8TKq0KIugsQOZ7ZT3DQsa=Xoi=book_result ct=resultresnum=2ved=0CB0Q6AEwAQ#v=onepageqf=false QUESTION 2 Your production database is running in archivelog mode and you are using recovery manager (RMAN) with recovery catalog to perform the database backup at regular intervals. When you attempt to restart the database instance after a regular maintenance task on Sunday, the database fails to open displaying the message that the data file belonging to the users tablespace are corrupted. The steps to recover the damaged data files are follows: 1. Mount the database 2. Open the database 3. Recover the data file 4. Restore the data file 5. Make the data file offline 6. Make the data file online Which option identifies the correct sequence that you must use to recover the data files? A. 2, 4, 3 B. 1, 4, 3, 2 C. 2, 5, 4, 3, 6 D. 5, 2, 4, 3, 6 E. 1, 5, 4, 3, 6, 2 Answer: E Explanation/Reference: Section: Backup, Recovery Recovery Manager (RMAN) /ora/rman_recover.html Steps for Media Recovery: 1. Mount or open the database. Mount the database when performing whole database recovery, or open the database when performing online tablespace recovery. 2. To perform incomplete recovery, use the SET UNTIL command to specify the time, SCN, or