Oracle Database Administration I — Question 21

Which two statements are true about trace files produced by the Oracle Database server? (Choose two.)

Answer options

• A. They can be written by server processes
• B. Trace files are written to the Fast Recovery Area (FRA)
• C. They can be written by background processes
• D. All trace files contain error information that require contacting Oracle Support
• E. Trace file names are based on the database name concatenated with a sequential number

Correct answer: A, C

Explanation

The correct answers, A and C, are accurate because trace files can indeed be produced by both server and background processes as part of their operations. Options B and E are incorrect as trace files are not necessarily stored in the FRA, and their naming convention does not always include a sequential number based on the database name. Option D is also incorrect since not all trace files contain error information requiring Oracle Support.