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 NAMESCTLstatus is givem
27)what the command will result by giving NAMESCTLflush
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: Accepting 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/