Managing Oracle Database Processes MCQ

1. In the odbc architecture, a(n) _____ is in charge of managing all database connections.

2. The column definition of number(7, 4) indicates a precision of ____.

3. 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?

4. 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?

5. Which are the examples of setting the DISPATCHERS initialization parameter?

6. The PMON (process monitor) background process can terminate shared servers below the value specified by SHARED_SERVERS?

7. In the DISPATCHERS Initialization Parameter Attributes which specify the service names the dispatchers register with the listeners?

8. 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?

9. In DISPATCHERS Initialization Parameter Attributes which Specify the network description of the endpoint on which the dispatchers listen, including the network protocol address?

10. In Oracle Database Background which process of one instance can perform Instance recovery for other instances that have failed?

11. In Monitoring Shared Server which contains information for tuning shared server?

12. 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?