MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 6 Mcqs, each offering curated multiple-choice questions to sharpen your Oracle (MCQ) questions and answers knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
What specifies the service names and the dispatchers register with the listeners inthe DISPATCHERS Initialization Parameter Attributes ? |
| A. | LISTENER |
| B. | SERVICE |
| C. | CONNECTIONS |
| D. | MULTIPLEX |
| Answer» C. CONNECTIONS | |
| 2. |
Which are the examples of setting the DISPATCHERS initialization parameter? |
| A. | Typical |
| B. | Forcing the Port Used by Dispatchers |
| C. | Forcing the IP Address Used for Dispatchers |
| D. | All mentioned above |
| Answer» E. | |
| 3. |
Which process of one instance can perform Instance recovery for other instances that have failed in Oracle Database Background ? |
| A. | Log Writer |
| B. | System Monitor |
| C. | Process Monitor |
| D. | Checkpoint |
| Answer» C. Process Monitor | |
| 4. |
Which parameter specifies the maximum number of shared servers that can be automatically created by PMON? |
| A. | MAX_DISPATCHERS |
| B. | MAX_SHARED_SERVERS |
| C. | SHARED_SERVER_SESSIONS |
| D. | SHARED_SERVERS |
| Answer» C. SHARED_SERVER_SESSIONS | |
| 5. |
What contains information for tuning shared server in a Monitoring Shared Server? |
| A. | V$SHARED_SERVER |
| B. | V$CIRCUIT |
| C. | V$SHARED_SERVER_MONITOR |
| D. | V$SHARED_POOL_RESERVED |
| Answer» D. V$SHARED_POOL_RESERVED | |
| 6. |
Which can service multiple user processes in a Oracle Database which creates server processes to handle the requests of user processes Connected to an instance of a server process? |
| A. | A dedicated server |
| B. | A shared server |
| C. | Both A & B |
| D. | None of the above |
| Answer» C. Both A & B | |