1z0-026考试回忆

　　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% suclearcase/" target="_blank" >ccess .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
　　
　　

原文转自：http://www.ltesting.net