- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
46.
Which statements regarding Database Resident Connection Pooling (DRCP) are true?
(Choose two.)
- A.When a DRCP pooled server connection is made by an application, it is equivalent to a dedicated server connection.
- B.When a database has DRCP enabled, all connections default to a pooled connection unless DEDICATED server is explicitly specified in the connect string.
- C.When an application using the DRCP connection disconnects, the server connection (process) is handed off to the broker.
- D.When using the Oracle Net Easy Connect method, it is not possible to utilize DRCP.
- Answer & Explanation
- Report
Answer : [A, C]
Explanation :
Explanation :
| Even if DRCP is enabled in the database, the client or application connection must always request a pooled connection using SERVER=POOLED in connect syntax. To use Easy Connect and DRCP, the syntax is host:port/service_name:POOLED. |
47.
A client receives the following error message:
"ORA-12154 TNS:could not resolve the connect identifier specified"
Which of the following could be possible causes of the error? Choose all that apply.
"ORA-12154 TNS:could not resolve the connect identifier specified"
Which of the following could be possible causes of the error? Choose all that apply.
- A.The listener is not running on the Oracle server.
- B.The user entered an invalid net service name.
- C.The user supplied the correct net service name, but the net service name is misspelled in the tnsnames.ora file on the client file.
- D.The listener is not configured to listen for this service.
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
| Supplying a net service name that is not contained in the tnsnames.ora file can cause this error. Problems with the tnsnames.ora file can cause this error, too. Listener problems will not cause this error. |
48.
What portion of the tnsnames.ora file specifies the name or IP address of the server
where the listener process is listening?
- A.CONNECT_DATA
- B.SERVER
- C.SERVICE_NAME
- D.HOST
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The HOST portion specifies the name of the server to contact. CONNECT_DATA specifies the database service to connect to. The PORT portion specifies the location where the listener is listening on the HOST. Option C, SERVICE_NAME, is the name of the actual database service. |
49.
A client wants to connect to the database service dbprod.com located on the dbprod.com
server through a nondefault port (1522) using Oracle Easy Connect. Which of the following
connect strings are the choices for the client to use? (Choose two.)
- A.CONNECT scott/tiger@dbprod.com:1522
- B.CONNECT scott/tiger@1522:dbprod.com/dbprod.com
- C.CONNECT scott/tiger@//dbprod.com/1522:dbprod.com
- D.CONNECT scott/tiger@dbprod.com:1522/dbprod.com
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
| The correct syntax to use with the Oracle Easy Connect method when you are connecting to a non-URL location is connect username/password@host:port/ service_name. If the service name and the host are identical, you do not have to include the service name. If the port is any port other than the default port of 1521, it must be specified. Because you want to connect to a nondefault port where the database name and the hostname are the same, the best answer is A, but D is also correct. |
50.
All of the following are reasons to configure the server using Shared Server except which one?
- A.Overall memory utilization is reduced.
- B.The system is predominantly used for decision support with large result sets returned.
- C.The system is predominantly used for small transactions with many users.
- D.The number of idle connections on the server is reduced
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Shared Server is a scalability option of Oracle. It provides a way to increase the number of supported user processes while reducing the overall memory usage. This configuration is well suited to high-volume, small-transaction-oriented systems with many users connected. Because users share processes, the number of overall idle processes is also reduced. It is not well suited for large data-retrieval-type applications such as decision support. |
|
|
||||||||||||||||||||||||||||
