Alert Log   «Prev  Next»
 

Alert log Concepts - Quiz

Each question is worth one point. Select the best answer or answers for each question.
1. Which of the following messages would most likely be accompanied by a core dump?
Please select the best answer.
  A. ORA-00600 - Internal error code
  B. ORA-7445 - Exception encountered
  C. ORA-1650 - Cannot extend rollback segment
  D. ORA-1650 Failed to extend object

2. Which of the following is a valid way to find the location of an alert log on a server?
Please select the best answer.
  A. Enter SQL*Plus and query the V$LOG_DEST view
  B. Find background_dump_dest in the init.ora file
  C. Go to $ORACLE_HOME/rdbms.log

3. Which of the following alert log messages would you want to check for on a regular basis?
Please select all the correct answers.
  A. ORA-600 - Internal error code
  B. Database startup messages
  C. Database log switch messages
  D. ORA-7445 - Exception encountered
4. Which of the following messages indicate that an update task should be fixed to perform more frequent COMMIT processing? Please select the best answer.
  A. ORA-600 - Internal error code
  B. ORA-1650 - Failed to extend object
  C. ORA-1650 - Failed to extend rollback segment
  D. ORA-1578 - Oracle data block corrupted