Answers to Review Questions - OCP: Oracle Database 12c Administrator Certified Professional - page 677

7. B. Option A is incorrect because reduced MTTR is an advantage of BMR. Option C is
incorrect because the data files' remaining online is an advantage of BMR. Since A and
C are advantages, D is also incorrect.
8. E. Option A is correct because if you attempt to analyze a table or index that has a cor-
rupt block, the ANALYZE command will indicate it. Option B is correct because the dbv
command (DB Verify utility) is used to verify the data-structure integrity of an offline
data file. DB Verify will let you know if the data file fails the integrity check. Option C
is correct unless you have used DBMS_REPAIR.SKIP_CORRUPT_BLOCKS to permit queries
to skip corrupt blocks. D is correct because the RMAN BACKUP command will detect
corruption by default.
9. A, C. Option B is incorrect because logical corruptions are not repairable by
BMR. Option D is incorrect because you must use a level 0 or full backup for the
restore. Option E is incorrect because ARCHIVELOG mode is a requirement for BMR.
10. B, C. Option A is incorrect because the syntax is wrong. Option D is incorrect because
BLOCK doesn't belong. B is how you recover all corrupt blocks listed in V$DATABASE_BLOCK_
CORRUPTION . C is the correct syntax to recover just the one block that you've identified
as corrupt.
11. D. Option A is incorrect because there is no direct link on the Software And Support
home page to the SQL Advisors. You use either sequence B or C to get to the SQL
Advisors and to the Automatic SQL Tuning Advisor page; from there, you can see
the results of the most recent Automatic SQL Tuning Advisor task.
12. D. Options A, B, and C are not valid choices when creating a SQL tuning set. During
the filter options step, the DBA can choose the SQL attributes, the operator, and the
values to use as filter conditions.
13. A. Option B is incorrect because there is no Manual Tuning Task Results option. C is
incorrect because there is no Manual SQL Tuning Advisors option.
14. A. Option B is incorrect because the manual SQL Tuning Advisor task does not tune
the SQL statements. C is incorrect for the same reason.
15. E. All of the options are correct. The SQL Access Advisor recommends indexing,
partitioning, and materialized view changes to improve performance.
16. B. Option A is incorrect because SQL Access Advisor recommendations are not auto-
matically implemented. Option C is incorrect because the DBA can choose which recom-
mendations to schedule and implement from the task result set. D is incorrect because the
recommendations are not automatically scheduled for implementation.
17. C. The correct sequence is capture, preprocess, replay, analyze.