WGU D330 questions well answered graded A+
passed
1. Which of the following files must be A. listener.ora
present on the Oracle server to start
a nondefault Oracle The listener is the process that manages
listener? incoming connection requests. The listener
.ora file is used to configure the listener and
A. listener.ora
must be configured to start a nondefault listener.
B. lsnrctl.ora The sqlnet.ora file is an optional client- and
C. sqlnet.ora server-side file. The tnsnames.ora file is used
D. tnsnames.ora 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.
2. Which of the following is the correct B. lsnrctl start
way to start a listener called LISTEN-
ER ? D. None of the above
A. lsnrctl startup listener 4. Connection Manager
B. lsnrctl start provides which of the
C. netca start following?
D. netmgr start listener
3. 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
1/
17
,WGU D330 questions well answered graded A+
passed
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.
C. listener.ora
When services are dynamically registered with the
lis- tener, their information is not present in the
listener.ora file
D. All of the above
Connection Manager is a middleware solution
2/
17
, WGU D330 questions well answered graded A+
passed
A. Multiplexing that provides for the multiplexing of
B. Cross-protocol connectivity connections, cross-protocol connectivity, and
C. Network access control network access con- trol. All the answers
D. All of the above describe Connection Manager.
5. Which is a requirement for
using host naming? B. You must be using TCP/IP.
A. You must use Host naming is typically used in small installations
tnsnames.ora on the client. that have few Oracle databases. This is an
B. You must be using TCP/IP. attractive option when you want to minimize
C. You must have an OID client-side configuration. TCP/IP is a requirement
present. when you use host naming
D. You must have a
sqlnet.ora file present on the
client.
E. None of the above.
6. Which statements regarding A. When a DRCP pooled server connection
Data- base Resident is made by an application, it is equivalent to a
Connection Pooling (DRCP) dedicated server connection.
are true? (Choose two.)
C. When an application using the DRCP
A. When a DRCP pooled server connection
con-
nection is made by an application, it disconnects, the server connection
(process) is hand-
is equivalent to a dedicated default to a
server connection.
B. When a database has DRCP
en- abled, all connections
3/
17
passed
1. Which of the following files must be A. listener.ora
present on the Oracle server to start
a nondefault Oracle The listener is the process that manages
listener? incoming connection requests. The listener
.ora file is used to configure the listener and
A. listener.ora
must be configured to start a nondefault listener.
B. lsnrctl.ora The sqlnet.ora file is an optional client- and
C. sqlnet.ora server-side file. The tnsnames.ora file is used
D. tnsnames.ora 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.
2. Which of the following is the correct B. lsnrctl start
way to start a listener called LISTEN-
ER ? D. None of the above
A. lsnrctl startup listener 4. Connection Manager
B. lsnrctl start provides which of the
C. netca start following?
D. netmgr start listener
3. 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
1/
17
,WGU D330 questions well answered graded A+
passed
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.
C. listener.ora
When services are dynamically registered with the
lis- tener, their information is not present in the
listener.ora file
D. All of the above
Connection Manager is a middleware solution
2/
17
, WGU D330 questions well answered graded A+
passed
A. Multiplexing that provides for the multiplexing of
B. Cross-protocol connectivity connections, cross-protocol connectivity, and
C. Network access control network access con- trol. All the answers
D. All of the above describe Connection Manager.
5. Which is a requirement for
using host naming? B. You must be using TCP/IP.
A. You must use Host naming is typically used in small installations
tnsnames.ora on the client. that have few Oracle databases. This is an
B. You must be using TCP/IP. attractive option when you want to minimize
C. You must have an OID client-side configuration. TCP/IP is a requirement
present. when you use host naming
D. You must have a
sqlnet.ora file present on the
client.
E. None of the above.
6. Which statements regarding A. When a DRCP pooled server connection
Data- base Resident is made by an application, it is equivalent to a
Connection Pooling (DRCP) dedicated server connection.
are true? (Choose two.)
C. When an application using the DRCP
A. When a DRCP pooled server connection
con-
nection is made by an application, it disconnects, the server connection
(process) is hand-
is equivalent to a dedicated default to a
server connection.
B. When a database has DRCP
en- abled, all connections
3/
17
