This is in Transdumper format.All the best for the exams


1. What do you need to do to configure
centralized naming?
A. Create a dedicated Names listener.
B. Create and configure the Names server.
C. Add the region database to the sqlnet.ora
file.
D. Delete all tnsnames.ora files on client machines.

Answer: B

2. What does the CONNECTION attribute specify when enabling connection
pooling?
A. maximum number of network connections for each dispatcher
B. average number of network connections for each dispatcher
C. maximum
number of network connections for each shared server
D. average number of network connections for each shared server

Answer: A

3. The
listener audit trail provides information about every client connection request. Which additional
information about the client is NOT provided?
A.
client user ID
B. database username
C. network protocol
D. client host(platform)

Answer: B

4. Which parameter can you set to enable the
dead connection detection feature?
A. SQLNET.EXPIRE_TIME
B. TNSNAMES.EXPIRE_TIME
C. SQLNET.MONITOR_CONNECTION
D.
TNSNAMES.MONITOR_CONNECTION

Answer: A

5. You are configuring local naming using Net8 Assistant and want the tnsnames.ora file read for
resolution before
the host file is read. Which file can you manually edit to change the ordering of the method of resolution?
A. sqlnet.ora
B.
tnsnames.ora
C. names.ora
D. init.ora
E. config,ora
F. listener.ora

Answer: A

6. Which two statements are true regarding initial shared
server processes? (Choose two.)
A. If initial server processes are idle, they get deallocated.
B. It is best to estimate more initial server
processes than fewer.
C. You can change the minimum number of shared server processes dynamically.
D. Initial server processes all get allocated
when starting up the instance and database.

Answer: B , C

7. You want to configure a Names server to use cache replication. Which Net8
Assistant option button would you
select?
A. "Don't use a region database"
B. "Configure Cache Replication"
C. "Discover Names Servers in
the region"
D. "Names Server is not first in its region"

Answer: A

8. When configuring Connection Manager for connection concentration,
which file will contain the attribute
MULTIPLEX or MUL?
A. init.ora
B. cman.ora
C. sqlnet.ora
D. tnsnames.ora
Answer: A

9. What is the
listener name when you start the listener without specifying an argument?
A. list
B. listener
C. listener_name
D. the same as the instance
name

Answer: B

10. You are configuring Connection Manager for connection concentration. Which section of the cman.ora file
contains the
listening address for the CWGW Connection Manager process?
A. CMAN
B. CMAN_RULES
C. CMAN_ADMIN
D. CMAN_PROFILE

Answer: A

11. How many
region databases ban be configured in a single administrative region of an Oracle directory object?
A. one
B. two
C. four
D.
unlimited

Answer: A

12. What are the three characteristics of a listener? (Choose three.)
A. The listener can only listen to one
database.
B. The listener can listen on multiple protocols.
C. The default name for the listener is LISTEN.ORA.
D. Multiple listeners can listen
on behalf of a single database.
E. The name of the listener must be unique on the machine where it resides.

Answer: B , D , E

13. What is one
responsibility of a listener?
A. routing outgoing traffic
B. detecting lost connections
C. detecting incoming requests
D. passing statements and
result tables

Answer: C

14. Which folder would you choose in the Net8 Assistant tool to change the naming method?
A. Profile
B.
Configuration
C. Service Names
D. Oracle Names Servers

Answer: A

15. A site is having intermittent problems with user losing connections to
an Oracle instance, running on a UNIX
server. Each user runs the client application on his or her own Windows NT client. Some preliminary diagnosis
is
done with no success. The DBA then decides to enable Net8 tracing and sets the tracing level to SUPPORT on one of
the client nodes experiencing
the problem.
Which statement best describes the result of the DBA's action?
A. Trace information for all users is enabled.
B. Trace information
for only active users is enabled.
C. Trace information applicable for customer support staff is enabled.
D. Trace information for all users listed
in the Net8 configuration file is enabled.

Answer: C

16. How many request queues are present in a multithreaded server environment?
A. One
per system
B. One per database
C. One per listener
D. One per dispatcher

Answer: B

17. If you are using host naming, which component(s)
need to be installed?
A. Net8 on the server and the client machine.
B. TCP/IP and Net8 only on the client machine.
C. TCP/IP and Net8 only on the
server machine.
D. TCP/IP and Net8 only on the server and the client machine.

Answer: D

18. Which statement about Net8 tracing is true?
A.
Tracing is always enabled for Net8 connections.
B. Trace files can only be created on the database server.
C. Trace files contain less detailed
information than log file
D. Because tracing caused overhead for every session, it should not used only when necessary to resolve
an
error.

Answer: D

19. A DBA has determined that he or she can Telnet from a client to the database server but is unable to connect
using
Net8. Which utility should be used next to determine connectivity to an Oracle service on the server?
A. NETSTAT
B. TNSPING
C. LSNRCTRL
D.
ADAPTERS

Answer: B

20. Which two methods could you use to add service names to a region database? (Choose two.)
A. manually add them using
Net8 Assistant
B. restart the service names with the new region database
C. download them from another Names server using Net8 Assistant
D. load
them from a file using the Net8 Assistant Names server section
E. add new service names to the Net8 Assistant Names NetService names
section

Answer: A , C

21. Which statement regarding the logging and tracing of Net8 is true?
A. Loggin cannot be disabled on clients.
B.
There are four levels of logging that can be set.
C. Tracing can take up significant disk space but has little impact on performance.
D. There is
no way to prevent new trace data from being appended to the same file with each new session.

Answer: A

22. Which three types of data is stored
by Oracle Names?(Choose three.)
A. list of available protocols
B. list of global database links
C. names and addresses of Name servers
D. list
of registered dispatchers and addresses
E. names and listener addresses of all Connection Managers on the network

Answer: B , C , E

23. Which
statement is true about turning off the listener audit trail?
A. A listener control utility command must be issued.
B. An environment variable
must be set before starting the listener.
C. A listener configuration parameter must be set in the listener.ora file.
D. The listener audit trail
feature can never be turned off. It is always switched on by default.

Answer: D

24. Which naming method simplifies administrative tasks when
configuration changes need to be made available to
all clients immediately?
A. host naming
B. local naming
C. service naming
D. centralized
naming

Answer: D

25. Given two data encryption algrorithms, which one would be more secure?
A. The one with the longer key length.
B. The
one with the shorter key length.
C. The one with the more complicated hash function.
D. The one with the less commonly known encryption
algorithm.

Answer: A

26. Someone manages to read packages sent over the network. What does this compromise?
A. data privacy
B. data
integrity
C. data ambiguity
D. data authorization

Answer: A

27. Net8 Assistant can be used to configure a region database to be used by a
Names server. Which two methods
can be used to populate the database? (Choose two.)
A. Service names can be read from an existing names.ora
file.
B. Service names can be read from an existing tnsnames.ora file.
C. Service names can be loaded by issuing the NAMESCTL>reload command.
D.
Service names can be loaded dynamically when the Names server is restared.
E. Service names can be manually entered by using the the NAMESCTL>load
tnsnames command.

Answer: B , D

28. Which task is recommended before you stop the listener?
A. Shut down the instance.
B. Disconnect all
database users.
C. Make a backup of your database.
D. Send a warning message to all network users.

Answer: D

29. Which statement is
true?
A. A connect descriptor maps to a service name.
B. A service name maps a connect descriptor.
C. A connect descriptor translates into only
one service name.
D. A connect descriptor is an enrty unrelated to a service name.

Answer: B

30. Which naming model allows the domain to be
extened to any number of levels?
A. flat
B. global
C. region
D. hierarchical

Answer: D

31. A DBA has installed and configured Net8 for
TCP/IP on the client and server, but is still unable to connect
from a Windows NT worksation, using SQL*Plus, to an Oracle instance running on a
remote UNIX server.
However, there are no problems when using FTP between the two nodes. What action next taken by the DBA could
make progress
toward diagnosing the problem?
A. attemping the PING the server from the client
B. checking to see if the DNS configuraiton is correct
C.
connecting by using the Net8 Assistant Test Connection feature
D. checking to see if the tnsping process is running on the server

Answer:
C

32. Which three attributes can be set when specifying the MTS_DISPATCHERS parameter? (Choose three.)
A. preferred naming method
B. number of
shared server processes
C. initial number of dispatcher processes
D. maximum number of dispatcher processes
E. maximum number of sessions for
each dispatcher
F. maximum number of connections for each dispatcher

Answer: C , E , F

33. How the DBA determines the location of the
listener log file?
A. view the init.ora file
B. issue the SHOW LISTENER command
C. issue the SHOW LOG_DIRECTORY command
D. query the dynamic
performance view v$listener

Answer: C

34. Which two parameters can be specified for client load balancing? (Choose two.)
A. FAILOVER
B.
LOAD_BALANCE
C. LOAD_BALANCING
D. ENABLE_FAILOVER
E. ENABLE_LOAD_BALANCE

Answer: A , B

35. Which NAMESCTL command can be used to manually
force Names server discovery?
A. FLUSH
B. RELOAD
C. REORDER_NS
D. DISCOVER_NS
E. START_CLIENT_CACHE

Answer: C

36. Which two are features
of Connection Manager? (Choose two.)
A. connection exchange
B. connection resolution
C. connection multiplexing
D. connection crosslinking
E.
protocol transformation
F. multiprotocol interchange capability

Answer: D , F

38. You created a new listener using Net8 Assistant and now
need to assigng it to the PROD database. Using
Database Services, which additional information is required?
A. global database name, Oracle home
directory, and SID
B. SID
C. global database name
D. global database name and SID

Answer: A

39. You set up MTS for the PROD database, which
uses multiple listeners to handle requests. Which LSNRCTL
command you issue for each listener to verify the dispatchers have registered with all
listeners used by the
database?
A. DISPATCHERS
B. SHOW ALL
C. SERVICES
D. SHOW SERVICES
E. SHOW DISPATCHERS

Answer: C

40. When is a
request sent to a listener?
A. after every call
B. before every call
C. after name resolution
D. before name resolution

Answer: C

---