ocp读书笔记.docVIP

401.Which of the following are correct about block media recovery? (Choose all that apply.) A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_ CORRUPTION. B. Logical corruptions are repairable by BMR. C. Physical corruptions are repairable by BMR. D. RMAN can use any backup for a BMR restore. E. ARCHIVELOG mode is not required if you have both a full and incremental backup for restore. Answer: AC 402.While querying the EMPLOYEES table, you receive an ORA-01578 message indicating block corruption in File# 1201 and Block# 1968. You analyze the table and the corruption is verified. Which RMAN command do you use to perform BMR and repair the corrupt block? A. RECOVER FILE=1201 BLOCK=1968; B. RECOVER CORRUPTION LIST; C. RECOVER DATAFILE 1201 BLOCK 1968; D. RECOVER BLOCK CORRUPTION LIST; E. None of the above Answer: BC 403.To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence should you follow? A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning Advisor B. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor C. EM Database home page, Software and Support, Support Workbench, Advisor Central, SQL Advisors, Automatic SQL Tuning Advisor D. Either B or C E. All of the above Answer: D 404.When creating a SQL tuning set, which of the following steps allows the DBA to reduce the size of the SQL set by selecting specific operators and values? A. Filter versions B. Filter loads C. Filter tasks D. Filter options Answer: D 405.To view the results of a manual SQL Tuning Advisor task, which steps should the DBA take? A. From the Advisor Central home page, select the tuning task from the Advisor Tasks section. B. From Advisor Central, choose SQL Advisors, SQL Tuning Advisors, Manual Tuning Task Results. C. From Advisor Central, choose SQL Advisors, Manual SQL Tuning Advisors, Tuning Task Results. D. Either B or C. Answer: A 406.Which