# 1. (1Z0-032q15) Which of the following is the correct line that specifies the connection to be made via TCP port 1521 to a server named transserver? A. (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=transserver)(PORT=1521))) B. (DESCRIPTION= (ADDRESS=(tcp:1521)(HOST=transserver))) C. (DESCRIPTION= (ADDRESS:(tcp:1521)(HOST=transserver))) D. (DESCRIPTION= (ADDRESS=(tcp)(HOST=transserver)(PORT=1521))) A # 2. (1Z0-032q5) Which of the following correctly describe the Oracle Connection Manager in 9i (Choose all that apply)? A. It reduces the demand on resources needed to maintain multiple network sessions between processes B. It is an Oracle Net Services component C. It allows an increase in the number of network sessions that a server can handle D. It enables multiple client network sessions to be multiplexed ABCD # 3. (1Z0-032q16) You are setting up the connect descriptor. You want to connect only to the sales1 instance of the database. Which of the following lines should be added? A. (INSTANCE_NAME:sales1) B. (INSTANCENAME: "sales1") C. (INSTANCE_NAME:='sales1') D. (INSTANCE_NAME=sales1) E. (INSTANCE=sales1) D # 4. (1Z0-032q22) Through the use of the net service name, which of the following represents the correct mapping of a net service name called sales to a connect descriptor?
A.
B.
C.
D.
sales= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=salesserver)(PORT=1821)) (CONNECT_DATA= (SERVICENAME:sales.myms.com))) sales= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=salesserver)(PORT=1821)) (CONNECT_DATA= (SERVICE_NAME=sales.myms.com))) sales= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=salesserver)(PORT=1821)) (CONNECT_DATA= (SERVICE_NAME:"sales.myms.com"))) sales= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=salesserver)(PORT=1821)) (CONNECT_DATA=sales.myms.com))
B # 5. (1Z0-032q1) What 9i component acts as the data courier for the client application and the 9i database server? A. Net 9 B. Net 8 C. Oracle HTTP D. Apache Net E. Oracle Net F. Shared Server E # 6. (1Z0-032q2) What is the component of 9i's Oracle Net that establishes and maintains database connections from the network? A. Oracle Net foundation layer B. JDBC Driver C. JDBC API D. Oracle protocol support A
# 7. (1Z0-032q3) What 9i features give your existing applications the chance to scale up without the need for making any changes to the applications themselves? A. Shared Server B. Apache Net C. Oracle Net D. Oracle HTTP E. Net 9 F. Connection pooling G. Net 8 A # 8. (1Z0-032q6) With Oracle Connection Manager, filtering rules allow the administrator to restrict specific client access based on which of the following criteria (Choose all that apply)? A. Destination database service names B. Source host names for clients C. Client use of Oracle Advanced Security D. Destination host names for servers ABCD # 9. (1Z0-032q37) In 9i, profiles are stored in what file (CASE SENSITIVE fill in the blank): sqlnet.ora # 10. (1Z0-032q4) What 9i feature enables the database server to timeout an idle session and use the connection for servicing the others? A. Oracle Net B. Apache Net C. Shared Server D. Connection pooling E. Net 8 F. Net 9 G. Oracle HTTP D # 1. (1Z0-032q12) The 9i's Net Configuration Assistant allows you to configure which of the following (Choose all that apply)? A. Naming methods B. Database names C. Directory server usage D. Listeners E. Init parameters
ACD # 2. (1Z0-032q18) Which of the following provides runtime failover for your 9i environment? A. Shared Server B. Oracle Net C. TAF D. Connection pooling E. Oracle HTTP F. Listener C # 3. (1Z0-032q8) Oracle Protocol Support resides on which layer of the client? A. Right above the Oracle Net Foundation Layer B. Right below the application layer C. Right below the network protocol D. Right above the application layer E. Right above the network protocol layer E # 4. (1Z0-032q14) A connect descriptor can be used to provide which of the following information? A. the location of the database B. the port to use C. the connection filter D. the protocol to use E. the name of the database service ABDE # 5. (1Z0-032q9) Oracle Net Foundation Layer resides on which layer of the server? A. Right above the RDBMS layer B. Right above the network protocol C. Right below the network protocol D. Right below the Oracle Protocol Support Layer E. Right below the RDBMS layer E # 6. (1Z0-032q11) What Oracle 9i process brokers client requests on the server side?
A. Listener B. Connection pooling C. Oracle Net D. TAF E. Shared Server F. Oracle HTTP A # 7. (1Z0-032q17) Which of the following are the possible actions of the listener when a client request is received (Choose all that apply)? A. Spawns a dedicated server process for the client connection. B. Handle the connection directly. C. Hands the connect request to a dispatcher. D. Sends a redirect message back to the client with the location of the corresponding server process. ACD # 8. (1Z0-032q13) How do you change the value of SERVICE_NAMES parameter dynamically when the database is running? A. You must first stop the database B. use the SQL statement ALTER DATABASE C. You must edit the init file while the instance is not running D. use the SQL statement ALTER SYSTEM E. use the SQL statement ALTER TABLE D # 9. (1Z0-032q10) The Oracle Net foundation layer uses Oracle protocol support for communicating with the industry-standard network protocols. Which of the following protocols are supported (Choose all that apply)? A. TCP/IP B. Named Pipes C. VI D. TCP/IP with SSL E. LU6.2 ABCDE # 10. (1Z0-032q7) You are configuring centralized authentication in your Oracle9i environment. You want to provide secure authentication that can accommodate single sign-on. Which of the following third-party services can you deploy (Choose all that apply)?
A. RADIUS B. Distributed Computing Environment C. Kerberos D. Secure Sockets Layer E. CyberSafe ABCDE