Upgrade to Oracle Database 12c — Question 34

Which two statements are true when the listener handles connection requests to an Oracle 12c database instance with multithreaded architecture enabled in
UNIX?

Answer options

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

Correct answer: A, D

Explanation

Option A is correct as the local listener can indeed direct requests to existing processes that can create threads. Option D is also correct because thread creation in a multithreaded environment typically involves a dispatcher process. Options B and C are incorrect because not every multithreaded Oracle process has an SCMN thread, and not all Oracle processes run an SCMN thread.