7.7. Review Questions

  1. What activity is responsible for causing most block corruption?

    1. Human errors that introduce bugs caused by hardware, software, or firmware

    2. Memory errors written to disk

    3. Random I/O errors written to disk

    4. A bad transaction that updates many tables

  2. What is the most common way of detecting block corruption in the database?

    1. Monitoring the operating system log files

    2. Monitoring the application log files

    3. Monitoring the ALERT.LOG database log

    4. Monitoring the ALERT.LOG and associated trace files

  3. What is the correct command to analyze the EMPLOYEE table in the schema owned by user TEST?

    1. ANALYZE INDEX EMPLOYEE VALIDATE STRUCTURE

    2. ANALYZE TABLE TEST.EMPLOYEE VALIDATE STRUCTURE

    3. ANALYZE TABLE EMPLOYEE VALIDATE STRUCTURE

    4. ANALYZE INDEX TEST.EMPLOYEE

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.