WHICH OF THE FOLLOWING STATEMENTS ABOUT SHARED SERVERS ARE TRUE

11. Which of the following statements about shared servers are true? (Choose the

PA R T I

best answer.)

A. All statements in a multistatement transaction will be executed by the

same server.

B. If one statement updates multiple rows, the work may be shared across

several servers.

C. The number of shared servers is fixed by the SHARED_SERVERS parameter.

D. Oracle will spawn additional shared servers on demand.

Self Test Answers