Question

Oracle server configuration is dedicated for

(a) One server process – Many user processes

(b) Many server processes – One user process

(c) One server process – One user process

(d) Many server processes – Many user processes

This question was addressed to me in an interview.

This interesting question is from Installing Oracle Database 11g and Creating a Database topic in portion Oracle Database 11g Architecture Options of Oracle

Answer 1

Right option is (c) One server process – One user process

The best explanation: Single-process Oracle is a database system in which all Oracle code is executed by one process. Different processes are not used to separate execution of the parts of Oracle and the client application program. Instead, all code of Oracle and the single user’s database application is executed by a single process.