WGU D330 Exam 41 Questions with Verified
Answers
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 - CORRECT ANSWER A. listener.ora
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.
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 - CORRECT ANSWER B. lsnrctl start
,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.
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 - CORRECT ANSWER C. listener.ora
When services are dynamically registered with the listener, their information is
not present in the listener.ora file
Connection Manager provides which of the following?
A. Multiplexing
B. Cross-protocol connectivity
C. Network access control
D. All of the above - CORRECT ANSWER D. All of the above
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.
, 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. - CORRECT ANSWER B. You must be using TCP/IP.
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
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.
Answers
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 - CORRECT ANSWER A. listener.ora
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.
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 - CORRECT ANSWER B. lsnrctl start
,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.
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 - CORRECT ANSWER C. listener.ora
When services are dynamically registered with the listener, their information is
not present in the listener.ora file
Connection Manager provides which of the following?
A. Multiplexing
B. Cross-protocol connectivity
C. Network access control
D. All of the above - CORRECT ANSWER D. All of the above
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.
, 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. - CORRECT ANSWER B. You must be using TCP/IP.
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
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.
