Multiple choice

The files that are created when an oracle background process encounters an exception are _______.

  1. redo files

  2. exec files

  3. control files

  4. trace files
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

When an Oracle background process encounters an exception or error, it writes diagnostic information to trace files in the user_dump_dest or background_dump_dest directory. These trace files contain error details, stack traces, and context information useful for troubleshooting database issues.

Keep practicing — related questions