Oracle Database 12c: Installation and Administration — Question 208

Which three statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled In
UNIX? (Choose three.)

Answer options

• A. Thread creation must be routed through a dispatcher process
• B. The local listener may spawn a now process and have that new process create a thread
• C. Each Oracle process runs an SCMN thread.
• D. Each multithreaded Oracle process has an SCMN thread.
• E. The local listener may pass the request to an existing process which in turn will create a thread.

Correct answer: A, D, E

Explanation

Option A is correct because in a multithreaded architecture, thread management is typically handled via a dispatcher. Option D is also correct, as each multithreaded Oracle process indeed has an SCMN thread to manage session communication. Option E is true as well, since the local listener can forward connection requests to existing processes that can create threads. Options B and C are incorrect; B is misleading about spawning a new process and C inaccurately states that every Oracle process runs an SCMN thread.