Logging | Tracing   « Prev  Next »

Oracle 26ai Logging and Tracing - Quiz

6 questions, one point each. Select one answer per question.
1. What is the best first step when a user reports a connection failure?
Select one answer.
  A. Edit every tnsnames.ora file on the machine immediately.
  B. Capture the exact error, time, client/application and target connection details.
  C. Restart the database before collecting evidence.
  D. Assume the password is wrong because other users can connect.

2. How should detailed ADMIN or SUPPORT tracing normally be used?
Select one answer.
  A. Enable it everywhere permanently because it has no cost.
  B. Treat it as a small, complete replacement for all event logs.
  C. Enable it only if database auditing is also active.
  D. Scope it to the investigation, monitor output volume, and restore prior settings after capture.

3. Many clients fail to connect through the same listener. Which evidence is especially relevant to inspect early?
Select one answer.
  A. Only the last successful client sqlnet.log from another week.
  B. The intended listener's status, service handlers and logs for the failure window.
  C. A hypothetical tnsnames.log that must exist for every alias.
  D. Only the database redo log member names.

4. Which Listener Control command changes the current listener's trace level at runtime?
Select one answer.
  A. SET TRC_LEVEL ADMIN
  B. DROP DATABASE
  C. ALTER USER TRACE
  D. TNSPING ADMIN

5. Which named Oracle Net trace level provides the most detailed support diagnostics?
Select one answer.
  A. USER
  B. ADMIN
  C. OFF
  D. SUPPORT

6. Which command reports the active listener status, including its Listener Log File location?
Select one answer.
  A. SHOW PARAMETER USER_DUMP_DEST in any database session.
  B. TNSPING alone.
  C. lsnrctl status LISTENER, substituting the intended listener name.
  D. Read tnsnames.ora without contacting the listener.