Log Trace Files - Quiz Explanation
The correct answers are indicated below, along with text that explains the correct answers.
1.
Which of the following best describes the purpose of the Oracle trace files?
Please select the best answer.
A.
They are referenced by the DBA to get details about a problem.
B.
They contain information about normal database statistics.
C.
They contain database startup and shutdown information and are used as an audit trail.
D.
They are used by application developers to debug their SQL statements.
The correct answer is A.
The Oracle trace files are referenced by the DBA to get details about a problem. B is incorrect because trace files only report abnormal conditions. C is incorrect because it is the alert logs that contain database startup and stop information. D is incorrect because application developers have no interest in trace files, nor are trace files used to debug SQL statements.
2.
Which of the following files is modified to change the location of the listener trace files?
Please select the best answer.
A.
sqlnet.ora
B.
listener.ora
C.
cman.ora
D.
init.ora
The correct answer is B.
The listener.ora file is modified to change the location of the listener trace files, because the listener.ora file contains the location for the listener trace files. A is incorrect because sqlnet.ora is used for Net8 connection parameters. C is incorrect because cman.ora is used for connection parameters. D is incorrect because init.ora is used to configure the database server.