Trace Files   «Prev  Next»

Trace files - Quiz

The answers you selected are indicated below, along with the text that explains the correct answers.

1. Which of the following trace files is associated with an Oracle session?
Please select the best answer.
  A. ora_11253.trc
  B. dbwr_1224_vnr1.trc
  C. smon_22928_vnr1.trc
  D. p001_1272_vnr1.trc

2. You are on an unfamiliar server and are looking for a trace file after a system crash. Where would you look?
Please select the best answer.
  A. The user_dump_dest directory
  B. The init.ora directory
  C. The background_dump_dest directory
  D. The $ORACLE_HOME/rdbms/log directory

3. Which is a valid way to enable a session trace?
Please select all the correct answers.
  A. Use the "alter session set events" command.
  B. oradebug
  C. Use dbms_system.enable_trace
  D. Use tkprof to force a trace dump

4. Who would be the most likely user for a trace file titled smon_1234_tom.trc?
Please select the best answer.
  A. The DBA
  B. A Oracle developer
  C. A UNIX systems administrator
  D. Oracle Technical support