41.
All the following are reasons to configure the server using Shared Server except:
- A.Overall memory utilization is reduced.
- B.The system is predominantly used for decision support with large result sets returned.
- C.The system is predominantly used for small transactions with many users.
- D.The number of idle connections on the server is reduced.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
Shared Server is a scalability option of Oracle. It provides a way to increase the number of supported user processes while reducing the overall memory usage. This configuration is well suited to high-volume, small-transaction-oriented systems with many users connected. Because users share processes, the number of overall idle processes is also reduced. It is not well suited for large data retrieval type applications such as decision support. |
42.
Which of the following is true about Shared Server?
- A.Dedicated connections cannot be made when Shared Server is configured.
- B.It is recommended that index rebuilds be performed when connected via Shared Server.
- C.The database can be started when connected via Shared Server.
- D.The database cannot be stopped when connected via Shared Server.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
Users can request dedicated connections in a Shared Server configuration. Index rebuilds and data-intensive activities should be performed using dedicated server. The database cannot be started when connecting via Shared Server. So the correct answer is D. |
43.
The administrator wants to allow a user to connect via a dedicated connection into a database
configured in Shared Server mode. Which of the following lines accomplishes this?
- A.(SERVER=DEDICATED)
- B.(CONNECT=DEDICATED)
- C.(INSTANCE=DEDICATED)
- D.(MULTITRHEADED=FALSE)
- E.None of the above
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
A user must explicitly request a dedicated connection when a server is configured in Shared Server mode. Otherwise, the user gets a Shared Server connection. The correct parameter is (SERVER=DEDICATED). |
44.
In which of the following files would you find the Shared Server configuration parameters?
- A.listener.ora
- B.mts.ora
- C.init.ora
- D.tnsnames.ora
- E.sqlnet.ora
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
The Shared Server configuration parameters exist in the init.ora file on the Oracle Server machine. |
45.
Which of the following is a component of Shared Server?
- A.Shared user processes
- B.Checkpoint processes
- C.Dispatcher processes
- D.Dedicated server processes
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
In Shared Server, users connect to a pool of shared resources called dispatchers. A client connects to the listener, and the listener redirects the request to a dispatcher. The dispatchers handle all the user requests for the session. Many users can share dispatchers. |