Unformatted text preview: r
than 2K bytes.
C: The utility CAN verify data files for a database with any DB_BLOCK_SIZE less than
or equal to 4K bytes.
D: The utility CAN verify data files for a database with any DB_BLOCK_SIZE less than
or equal to 8K bytes.
Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 659-661
Chapter 14: database Failure and Recovery
What are two causes of a user process failure? (Choose two)
A. A table is accidentally truncated.
B. The user issues an abnormal interrupt.
C. There is a logic error in the application.
D. The application program receives an addressing exception.
E. There is a head crash on the disk containing a database file.
Answer: A, C
If a table was accidentally truncated or there was a logic error in the application, it can
cause a user process failure. If a user process terminates, then the process monitor
(PMON) background process intervenes, which saves the DBA some time and effort.
PMON is here to handle automatic process recovery for the database: when PMON
detects the process failure, PMON rolls back the failed process and releases lock...
View Full Document
This document was uploaded on 03/08/2014.
- Fall '09