vennai
1z0-026
5
Hi all,
My score was 45/59. I think in oracle ocp 8i NETWORK is the easiest exam. most of the questions are simple and striaght forward. if u have ILT means 100% success .these are the some of the sample questions
1) How to you find invalid connections ? or Which key words were used
to
find invalid connection ?
1) *Sqlnet.Expire_time
2) Sqlnet.Authentication etc
2) Following are properties of a Listener ? (Choose 3)
a) * A listerner can listen for more than one database
b) *Listerner can listen on multiple protocol
c) *Multiple listerners can listen for a single database
3)Fill in the blanks
Max number of Prespanwned server process are defined by --------
Ans: Prespawn_Max
4) Thers was a question in LSNRCTL ? Learn about key word Service ?
5) In Host Naming how will you issue a command if Global_DBName =
wwwed51-sun.us.oracle.com and SID = TS8 ?
Ans : sqlplus username/password@wwed151-sun
6) Which parameter is specified in Server and Client in Local Naming
method
? (i don't know the answer)
1) protocol
2)database alias
3) sqlnet.ora
4)tnsnames.ora
7)Fill in the blanks
You can enable load balacing in client side using paramer
____________
Ans : Load_Balance = on
8)How many region database you can have in Administrative region ?
1
9)Which statement about Hierarchical domain name is right ?
Ans : Contains unique names for each domain but permits names to be
repeated across domains.
10)Which command is used to discover Names server on the network ?
Ans : Reorder_NS
11) Subsequent connection request to same service name is fater if
client_side_cache is enabled beacuse cache contains?
Ans: Connection information
12)What does this command namesini.ora do ? (i don't know the answer)
1) Configure region Database
2) Reset Name server
13) How do you addd service names to Region database ?
Please see 6-19 Adding Service Names in OracleDBA course material
14)
No of dispatchers = CEIL ( Max number of concurrent sessions /
Connections
per dispatcher
Using above formala there was a question like there aree 900
sessions
and 225 diptchers , no of dispatchers = 4
15) One question about MTS_Dispatcher which one is true about
MTS_dispather
Ans : There are 4 choices and 2 of them are right.
16) How do you achieve scalability in Connection Manager ?
Connection concentration
17) Where do u have listening address of Configuraton Manafer
Ans : CMAN
18) Learn about key words in Network access protocol ?
SRC,DST, SRV, ACT
19)How do you enable connection through connection Manager ?
Source_route =yes
20) Trouble shooting check list one question ? (page 9-4,9-5)
21)Configure trace information with 'Support' key word ?
Support - Tracing information applicable for customer support
22) Listerner Audit trail contains following infor , which one is false
a) * database alias
b) Client request
c) User id, as well as platform , protocol and s/w
23) Audit trails feature is switched ON by default, there is no way
turn it
off
24) For Enhanced user authentication what other things you can use ?
Ans : Token Cards, Biometrics, Kerbros , Raddius
1-When is the request made to the listener
a-after the call
b-before the call
c-*-after the service name is resolved
d-before the service name is resolved
2-what is true about the net service name
a-*-connect descriptor maps to a service name
b-service name maps to a connect descriptor
3-what are the three part of file related to
connection manager
a-cman.ora
b-*-cman
c-*-cman_rules
d-*-cman_profile
4-what is true about the the listener
a-*-detects incoming calls
b-sends back the results
5-what configuring the profile, what file is
created/modified
-sqlnet.ora
6.what view would be queried to tune MTS
v$MTS
7-A client and server have TCP/IP installed. Which
name solving method
is most likely to be used:
-hostnaming
8-what are the benefits of using hostnaming method
-less administrative work regarding the
configuration
of client
9-what parameters should be configured for listener
tracing
*-trace_level_listener
*-trace_file_listener
*-trace_directory_listener
10.what parameter is configured for prespawned
processes
-*- prespawn_max
11.where is MTS configured mostly
-*init.ora file
12.when using localnaming method what file is
configured
a-names.ora
b-cman.ora
c-*-tnsnames.ora
13.where is names_preferred_server parameter found
a-tnsnames.ora
b-*sqlnet.ora
14.how many request queues are there when using
Multithreaded server
a-*1
b-2
15.what is true about CONNECTION when configuring
connection pooling
a-is the maximum of session to a dispatcher
b-*-is the number of connection that can work
against
a dispatcher
16.what is the benefit of using names server
-*-centalized naming
17. the data is being read while being trasported in
the network. Whoch
feature of Advanced security is broken
*-a-data privacy
b-data integrity
c-data authorization
18.which are the user authentication methods
a-RC4
b-*-token card
c-*-biometric
19.what are the benefits of using connection manager
a-*-connection multiplexing
b-*-using multiple protocols
c-*-network access
20-if you choose to use the hostnaming method what
folder of Net8 can
be used
a-listener
b-*-profile
c-name server
21-what file would have the encryption parameters
a-tnsnames.ora
b-listener.ora
c-*-sqlnet.ora
d-names.ora
22.which two paramters are configured in client load
balancing
a-*-failover
b-*-load_balance
c-load_balancing
23.when configuring the names server for cache
replications which
option do you choose
a-"use a region database"
b-*-"Don't use a region database"
c-name server is first in its region
d-discover names server in this region
