Managing Oracle Database Processes MCQs
Managing Oracle Database Processes MCQs
Our team has conducted extensive research to compile a set of Managing Oracle Database Processes MCQs. We encourage you to test your Managing Oracle Database Processes knowledge by answering these multiple-choice questions provided below.
Simply scroll down to begin!
1: 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?
A. True
B. False
2: In Monitoring Shared Server which contains information for tuning shared server?
A. V$SHARED_SERVER_MONITOR
B. V$SHARED_POOL_RESERVED
C. V$CIRCUIT
D. V$SHARED_SERVER
3: In Oracle Database Background which process of one instance can perform Instance recovery for other instances that have failed?
A. System Monitor
B. Log writer
C. Checkpoint
D. Process Monitor
4: In DISPATCHERS Initialization Parameter Attributes which Specify the network description of the endpoint on which the dispatchers listen, including the network protocol address?
A. ADDRESS
B. DESCRIPTION
C. Protocol
D. All
5: 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?
A. A dedicated server And A shared server
B. A dedicated server
C. None
D. A shared server
6: In the DISPATCHERS Initialization Parameter Attributes which specify the service names the dispatchers register with the listeners?
A. MULTIPLEX
B. LISTENER
C. Service
D. CONNECTIONS
7: The PMON (process monitor) background process can terminate shared servers below the value specified by SHARED_SERVERS?
A. True
B. False
8: Which are the examples of setting the DISPATCHERS initialization parameter?
A. Forcing the IP Address Used for Dispatchers
B. All
C. Typical
D. Forcing the Port Used by Dispatchers
9: 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?
A. SHARED_SERVERS
B. SHARED_SERVER_SESSIONS
C. MAX_SHARED_SERVERS
D. MAX_DISPATCHERS
10: 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?
A. Connection pooling
B. Session multiplexing
C. Session
D. None
11: The column definition of number(7, 4) indicates a precision of ____.
A. 7
B. 4
C. 11
D. 3
12: In the odbc architecture, a(n) _____ is in charge of managing all database connections.
A. Driver manager
B. Core
C. RDO
D. None of these
List of Managing Oracle Databa...
Available in:
Managing Oracle Database Processes MCQs
