- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
41.
Which of the following files must be present on the Oracle server to start a nondefault
Oracle listener?
- A.listener.ora
- B.lsnrctl.ora
- C.sqlnet.ora
- D.tnsnames.ora
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The listener is the process that manages incoming connection requests. The listener .ora file is used to configure the listener and must be configured to start a nondefault listener. The sqlnet.ora file is an optional client- and server-side file. The tnsnames.ora file is used for doing local naming resolution. There is no such file as lsnrctl.ora. You do not need the listener.ora file to start a default listener on port 1521. |
42.
Which of the following is the correct way to start a listener called LISTENER?
- A.lsnrctl startup listener
- B.lsnrctl start
- C.netca start
- D.netmgr start listener
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Because the default listener name is LISTENER, simply enter lsnrctl start. The name LISTENER is assumed to be the listener to start in this case. |
43.
When dynamic service registration is used, you will not see the service listed in which
of the following files where it would normally be located?
- A.sqlnet.ora
- B.tnsnames.ora
- C.listener.ora
- D.None of the above
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| When services are dynamically registered with the listener, their information is not present in the listener.ora file. |
44.
Connection Manager provides which of the following?
- A.Multiplexing
- B.Cross-protocol connectivity
- C.Network access control
- D.All of the above
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| Connection Manager is a middleware solution that provides for the multiplexing of connections, cross-protocol connectivity, and network access control. All the answers describe Connection Manager. |
45.
Which is a requirement for using host naming?
- A.You must use tnsnames.ora on the client.
- B.You must be using TCP/IP.
- C.You must have an OID present.
- D.You must have a sqlnet.ora file present on the client.
- E.None of the above.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| Host naming is typically used in small installations that have few Oracle databases. This is an attractive option when you want to minimize client-side configuration. TCP/IP is a requirement when you use host naming. |
|
|
||||||||||||||||||||||||||||
