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 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