Logging | Tracing   « Prev  Next »

 

Oracle Logging and Tracing - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1. What is the first thing that you should do when an end-user cannot connect to a server?
Please select the best answer.
  A. Check the local tnsnames.ora file.
  B. Look up the error number provided to the end-user.
  C. Try to ping the server.
  D. Check the listener.

2. Which of the following statements is true about ADMIN and SUPPORT level trace files?
Please select the best answer.
  A. Trace files are automatically generated and are very useful for diagnosing common connection problems.
  B. Trace files are relatively small and can be kept as a record of Net8 connections.
  C. Trace files are very useful ONLY if Oracle auditing is also used.
  D. Trace files are large and space consuming and should only be used in rare cases.

3. You receive a report from dozens of end-users, all complaining that they cannot connect to the server. What log file should you check first?
Please select the best answer.
  A. sqlnet.log
  B. listener.log
  C. tnsnames.log
  D. alert.log

4. Which of the following trace component can be started without re-starting the database or the listener?
Please select the best answer.
  A. listener trace
  B. server trace
  C. sqlnet trace
  D. names trace

5. Which of the following level parameters for Oracle tracing will provide the highest level of detail about a connection?
Please select the best answer.
  A. USER
  B. ADMIN
  C. OFF
  D. TRACE

6. You have forgotten the location of your listener log files. Which of the following commands represents the best way to determine their location?
Please select the best answer.
  A. Server manager – show parameters dump
  B. Run tnsping
  C. Run the "lsnrctl stat" command
  D. Check tnsnames.ora