Logging | Tracing   « Prev  Next »

Oracle 26ai Log and Trace Files - Quiz

5 questions, one point each. Select one answer per question.
1. What is the purpose of an Oracle Net trace file?
Select one answer.
  A. Provide detailed network-operation diagnostics for investigating a connection problem.
  B. Replace the backup copies of database datafiles.
  C. Serve as the database security audit policy.
  D. Contain only abnormal events and never normal protocol activity.

2. Which statement correctly describes listener diagnostic locations?
Select one answer.
  A. They are always controlled by the database USER_DUMP_DEST parameter.
  B. They depend on listener diagnostic configuration and ADR mode; legacy trace-directory settings do not override ADR paths.
  C. They are determined by the client tnsnames.ora alias name.
  D. They are always the same directory as the application executable.

3. Which named trace level requests administrative diagnostic detail?
Select one answer.
  A. SUPPORT
  B. USER
  C. ADMIN
  D. OFF

4. Which value can help correlate an Oracle Net connection across component logs and traces?
Select one answer.
  A. The database block size.
  B. CONNECTION_ID, where present in the diagnostic records.
  C. The quiz question number.
  D. The trace file size alone.

5. Which input is required for the documented Trace Assistant workflow?
Select one answer.
  A. A support-level (16) Oracle Net trace captured with ADR disabled for the relevant component.
  B. Only the database alert log, with no network trace.
  C. An OFF-level trace with no recorded activity.
  D. Any SQL script, regardless of its content.