Database Administrator (DBA) Question:

Download Job Interview Questions and Answers PDF

What is a trace file and how is it created?

Database Administrator (DBA) Interview Question
Database Administrator (DBA) Interview Question

Answer:

Each server and background process can write an associated trace file. When an internal error is detected by a process or user process, it dumps information about the error to its trace. This can be used for tuning the database.

Download Database Administrator (DBA) Interview Questions And Answers PDF

Previous QuestionNext Question
What are the responsibilities of a Database Administrator?What is a database profile?