7.8. Answers to Review Questions

  1. A. Most block corruption is caused by human error introducing bugs with new hardware, software, or firmware changes.

  2. D. Monitoring the ALERT.LOG and associated trace files is the best method for detecting block corruption in the database.

  3. B. If the ANALYZE command is being run by a DBA account, you need to prefix the table name with the schema owner.

  4. B. The ANALYZE command determines which object has corrupted indexes or tables, because the command returns an error if the statement does not process completely. The ANALYZE command does not identify which block is corrupt.

  5. C. The DBVERIFY utility uses the term pages instead of blocks. The DBVERIFY utility determines the amount of corrupt pages in a datafile.

  6. B. The ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial