In the odbc architecture, a(n) _____ is in charge of managing all database connections.
Answer
Correct Answer:
Driver manager
Note: This Question is unanswered, help us to find answer for this one
The column definition of number(7, 4) indicates a precision of ____.
Answer
Correct Answer:
7
Note: This Question is unanswered, help us to find answer for this one
For even better resource management, shared server can be configured for which that lets a dispatcher support more users by enabling the database server to time-out protocol connections and to use those connections to service an active session?
Answer
Correct Answer:
Connection pooling
Note: This Question is unanswered, help us to find answer for this one
In Initialization Parameters for Shared Server which Specifies the initial number of shared servers to start and the minimum number of shared servers to keep, this is the only required parameter for using shared servers?
Answer
Correct Answer:
SHARED_SERVERS
Note: This Question is unanswered, help us to find answer for this one
Which are the examples of setting the DISPATCHERS initialization parameter?
Answer
Correct Answer:
All
Note: This Question is unanswered, help us to find answer for this one
The PMON (process monitor) background process can terminate shared servers below the value specified by SHARED_SERVERS?
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
In the DISPATCHERS Initialization Parameter Attributes which specify the service names the dispatchers register with the listeners?
Answer
Correct Answer:
Service
Note: This Question is unanswered, help us to find answer for this one
Oracle Database creates server processes to handle the requests of user processes Connected to an instance a server process which can service multiple user processes?
Answer
Correct Answer:
A shared server
Note: This Question is unanswered, help us to find answer for this one
In DISPATCHERS Initialization Parameter Attributes which Specify the network description of the endpoint on which the dispatchers listen, including the network protocol address?
Answer
Correct Answer:
DESCRIPTION
Note: This Question is unanswered, help us to find answer for this one
In Oracle Database Background which process of one instance can perform Instance recovery for other instances that have failed?
Answer
Correct Answer:
System Monitor
Note: This Question is unanswered, help us to find answer for this one
In Monitoring Shared Server which contains information for tuning shared server?
Answer
Correct Answer:
V$SHARED_SERVER_MONITOR
Note: This Question is unanswered, help us to find answer for this one
A session is INACTIVE when it is making a SQL call to Oracle Database. A session is ACTIVE if it is not making a SQL call to the database?
Answer
Correct Answer:
False
Note: This Question is unanswered, help us to find answer for this one
