Your database instance is running. A user, SCOTT, starts a SQL*Plus session, and issues the following query; SQL>SELECT * FROM sales:

Which process would retrieve the result from the database and return it to the client program?

Question

Your database instance is running. A user, SCOTT, starts a SQL*Plus session, and issues the following query; SQL>SELECT * FROM sales:

Which process would retrieve the result from the database and return it to the client program?

Accepted Answer

A. user process

Answer

B. server process

Answer

C. System Monitor (SMON)

Answer

D. Process Monitor (PMON)

Answer

E. Checkpoint process (CKPT)

Your database instance is running. A user, SCOTT, starts a SQLPlus session, and issues the following query; SQL>SELECT FROM sales: Which process would retrieve the result from the database and…