All the following are reasons to configure the server using Shared Server except:
Overall memory utilization is reduced.
The system is predominantly used for decision support with large result sets returned.
The system is predominantly used for small transactions with many users.
The number of idle connections on the server is reduced.
Which of the following is true about Shared Server?
Dedicated connections cannot be made when Shared Server is configured.
It is recommended that index rebuilds be performed when connected via Shared Server.
The database can be started when connected via Shared Server.
The database cannot be stopped when connected via Shared Server.
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?
(SERVER=DEDICATED)
(CONNECT=DEDICATED)
(INSTANCE=DEDICATED)
(MULTITRHEADED=FALSE)
None of the above
In which of the following files would you find the Shared Server configuration parameters?
listener.ora
mts.ora
init.ora
tnsnames.ora
sqlnet.ora
Which of the following is a component of Shared Server?
Shared user processes
Checkpoint processes
Dispatcher processes
Dedicated server processes
You want to put the database in Shared Server mode. Which of the following files will you modify?
tnsnames.ora
cman.ora
names.ora
init.ora
What choice in the Oracle Net Manager allows for the configuration of Shared Server?
Local
Service Naming
Listeners
Profile
None of the above
You want two TCP/IP dispatchers and one IPC dispatcher to start when the instance is started. Which of the following lines will accomplish this?
dispatchers=(protocol=tcp)(dispatchers=2)(protocol=IPC) (dispatchers=1)dispatchers=(protocol=tcp)(dispatchers=2) (protocol=IPC)(dispatchers=1)
dispatchers="(protocol=tcp)(dispatchers=2)(protocol=IPC)(dispatchers=1)"
dispatchers_start=(protocol=tcp)(dispatchers=2)(protocol=IPC) (dispatchers=1)
dispatchers_start=(pro=tcp)(dis=2)(pro=IPC)(dis=1)
What is the name of the piece of shared memory that client connections are bound to during communications via Shared Server?
Program Global Area
System Global Area
Virtual Circuit
Database Buffer Cache
None of the above
What is the first step that the dispatcher performs after it receives a request from the user?
Pass the request to a shared server.
Place the request in a request queue in the PGA.
Place the request in a request queue in the SGA.
Process the request.
When configured in Shared Server mode, which of the following is contained in the PGA?
Cursor state
Sort information
User session data
Stack space
None of the above
Which of the following is false about shared servers?
Which of the following is not a step in the processing of a Shared Server request?
Shared servers pass information back to the client process.
Dispatchers place information in a request queue.
Users pass requests to a dispatcher.
The dispatcher picks up completed requests from its response queue.
None of the above.
When you are configuring Shared Server, which initialization parameter would you likely need to modify?
DB_CACHE_SIZE
DB_BLOCK_BUFFERS
LARGE_POOL_SIZE
BUFFER_SIZE
None of the above
Which of the following is false about request queues?
They reside in the SGA.
They are shared by all the dispatchers.
Each dispatcher has its own request queue.
The shared server processes remove requests from the request queue.
You want to gather information about users connected via Shared Server connections. Which of the following is the view that contains this information?
V$USERS
V$QUEUE
V$SESS_STATS
V$CIRCUIT
None of the above
What is the process that notifies the listener after a database connection is established?
SMON
DBWR
PMON
LGWR
You want to gather performance and tuning-related information for the shared server processes. You should start by querying which of the following views?
V$USERS
V$CIRCUIT
V$SHARED_SERVER_MONITOR
V$SESS_STATS
Which command can you execute to get details about the number of sessions connected via Shared Server?
lsnrctl sessions
lsnrctl conn
lsnrctl status
lsnrctl services
None of the above