C the utility can verify data files for a database

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

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 QUESTION 105: 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 Explanation: 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

Ask a homework question - tutors are online