1z0-026考试回忆2002.2.21

　　1) which two methods could you use to add service names to a region database (choose 2)?
　　a) manually add them using net8 assistant
　　b) restart the service names with the new region database
　　c) download them from nemes server using net 8 assistant
　　d) load them from a file using the net 8 assistant names server section
　　e) add new service names to the net 8 assistant names net serviece names section
　　
　　2)listener audit trail provides information about every client connection request.which additon
　　addition information about the client is not provided?
　　a)client user id
　　b) database name
　　c)network protocal
　　d)client host(platform)
　　
　　3) which naming method simplifies administration task
　　a)host naming
　　b)local naming
　　c)service naming
　　d)centralized naming;
　　
　　4) when is a request sent to the listener
　　a) after every call
　　b)before every call
　　c)after name resolution
　　d)before name resoluation
　　
　　5) some one manages to read package send over the network what does this compromise?:
　　a) data privacy
　　b)data integrity
　　c)data ambiquity
　　d) data authorization
　　
　　6) how many request queues are present in a MTS
　　a) one per system
　　b) one per database
　　c) one per listener
　　d) one per dispatcher
　　
　　7) how si the host name resolved using the host naming method
　　a) through sqlnet.ora
　　b) through tnsnames.ora
　　c) through ipaddress transalation mechanism
　　d) through v$hostname dynamic performance view
　　
　　8)which is true?
　　a) a connect descriptor maps to a service name
　　b) a service name maps to a conect descriptor
　　c) a connect discriptor translates into only one service name
　　d) a connect descriptor is an entry unread to a service anme
　　
　　9) local_listener = LSNR1 in init.ora
　　which addition file must reside on the node where LSNR1 listener is running
　　a) sqlnet.ora
　　b) tnsnames.ora
　　c) names.ora
　　d) init.ora
　　e) config.ora
　　ANS: b
　　
　　10) a net 8 client request encryption the net 8 server rejects encryption what happens
　　a) connection fails
　　b) connection hangs
　　c) encryption will be used
　　d) encryption will not be used
　　ANS : d
　　
　　11) command that displays listenere parameter when multiple listeners are used
　　a) show listener
　　b) show parameter
　　c) list listener_name
　　d) show current_listener
　　ANS:d
　　
　　12) 3 parametes would u specify if u used to log the default listener
　　a) logging
　　b)log_file
　　c) log _directory
　　d)logging_listener
　　e)log_file_listener
　　f) log_directory_listener
　　ANS:d,e,f
　　
　　13) enviromental variable to help set up oracle names
　　a) admin_tns
　　b)tns_names
　　c)tns_admin
　　d)names_tns
　　e)names_admin
　　f)admin_names
　　ANS:c
　　
　　14) which parameter will help in detecting dead connection
　　ANS:sqlnet.expire_time
　　
　　15) which layer helps in character set and data type conversions
　　a) oci
　　b)two task common layer
　　c)tns
　　d)opa
　　ANS:b
　　
　　16) when will the bequeath method will be used
　　ANS: if dedicated server doesnot have prespawned server process
　　
　　17) in which file u will specify the parameter PRESPAWN_MAX to set the no of prespawned dedicated servers
　　ANS: listener.ora
　　
　　18)which tab u will choice to enable logging and tracing in net 8 assistant
　　a) profile
　　b)listener
　　c)oracle names servers
　　ANS:profile
　　
　　19) select two parameters to enable connection load balancing
　　a) failover=on
　　b) load_balance=on
　　c) load_balancing=on
　　d)loading_balance = on
　　ANS:a,b
　　
　　20) in host naming method on server
　　
　　global_dbname = wwed151-sun.us.oracle.com and instance name = tst8
　　
　　how u will give the connect string
　　
　　a) connect username/password@tst8
　　b) connect username/passoword@wwed151-sun
　　ANS: b
　　
　　21) what is the differenc between inband and outband
　　
　　23) which naming model allows domain hierarchy to be extended to any number of levels
　　a) flat
　　b) hierachical
　　c)host naming
　　ANS:b
　　
　　24) which command at NAMESCTL to do names server discovery
　　ANS:REORDER_NS
　　
　　25)what r the two methods that u will be chosing to add service names after configring the regional database
　　ANS:ADD service names using net 8 assistant
　　:LOAD command to load the existing from tnsnames.ora
　　26) what information will u see when NAMESCTL>status is givem
　　
　　27)what the command will result by giving NAMESCTL>flush
　　
　　28) which is true in MTS
　　a) each dispatcher has one response queue
　　b) one responce queue for all dispatchers
　　c) one responce quere per system
　　ANS:b
　　
　　29) in which file u will specify pool = on to enable pooling
　　a)init.ora
　　b)tnsnames.ora
　　c)sqlnet.ora
　　d)names.ora
　　ANS:a
　　
　　30) what is the difference between connections and sessions
　　31) what is the default value of TICK
　　ANS:10 seconds
　　
　　32) in which section of cman.ora u will specify the listening address for the connection manager
　　a)cman
　　b)cman_rules
　　c)cman_profile
　　ANS:a
　　33) in which file u will specify mul=on to use connection concentration pooling
　　ANS: init.ora
　　
　　34) in which file u will specify USE_CMAN to force the session to use connection manager
　　a)init.ora
　　b)sqlnet.ora
　　c)tnsnames.ora
　　d)names.ora
　　ANS:b
　　-----------
　　1. You need to stop Oracle Intelligent Agent. What command should you issue using
　　LSNRCTL ability?
　　A: dbsnmp_stop
　　
　　2. What is the main configuration file that is regenerating each time Oracle Intelligent Agent is started?
　　A: snmpro.ora
　　
　　3. You are using Net8i and OEM to run Intelligent Agent. What is one of the many tasks the Intelligent Agent is responsible for?
　　A: Aclearcase/" target="_blank" >ccepting agent or events
　　
　　4 Which configuration file contains the database services discovered by the listener when the Oracle Intelligent Agent is started?
　　A: services.ora
　　
　　5. What is the second configuration file containing listener information used by the Oracle Intelligent Agent?
　　A: snmp_rw.ora
　　
　　6. Why should you consider setting up an Intelligent Agent for use with OEM in your Net8i en-vironment?
　　A: Manage jobs and events in your network environment
　　
　　Tnsnames/ Which Files
　　
　　
　　7. You are configuring local naming for the client and want to view the addresses that you set up. In what file is this information stored?
　　A: tnsnames.ora
　　
　　8. You configure local naming using Net8i Assistant and now you want to alter the default board number from 1521 to 1575. What client site file would you have to edit?
　　A: tnsnames.ora
　　
　　10. The product database has been renamed to TEST. What client file reflects this
　　change found connecting request to be accepted for the test database?
　　A: tnsnames.ora
　　11. You are analyzing the log file for the cause of TNS errors. Which file contains this information?
　　A: sqlnet.log
　　
　　12 In which file is the configuration information for the client profile login stored?
　　A: sqlnet.ora
　　
　　13 You are configuring your environment for Multiple Protocol Interchange, in which the clients use TCP/IP and CMAN to connect to the server using SPX/IPX. Which parameter should be included in the tnsnames.ora to allow this connection?
　　A: SOURCE_ROUTE
　　
　　

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