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

Your database interface 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?

Your database interface 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?

A.
User process

B.
Server process

C.
System Monitor (SMON)

D.
Process Monitor (PMON)

E.
Checkpoint process (CKPT)



Leave a Reply 2

Your email address will not be published. Required fields are marked *


iimax

iimax

user process –> server process.