4.8. Review Questions

  1. All of the following are examples of networking architectures except:

    1. Client/server

    2. N-tier

    3. Single-tier

    4. Two-tier

    5. All the above are examples of network architectures.

  2. You manage one non-Oracle database and several Oracle databases. An application needs to access the non-Oracle database as if it were part of the Oracle databases. What tool allows you to do this? (Choose the best answer.)

    1. Oracle Advanced Security

    2. Oracle Connection Manager

    3. Heterogeneous Services

    4. Oracle Net

    5. None of the above

  3. Which of the following is true about Oracle Net?

    1. It is not an option included in the Oracle Enterprise installation.

    2. It works only on TCP/IP platforms.

    3. It has the ability to communicate with non-Oracle data sources.

    4. It is never installed directly on a client workstation.

  4. You want to centrally administer all the Oracle network services in a large Oracle 10g installation that runs many network services. Which of the following facilities would best provide this functionality at minimal cost?

    1. Advanced Security

    2. Heterogeneous Services

    3. Oracle Shared Server

    4. Oracle Internet Directory

  5. Which of the following files must be present on the Oracle server to start a non-default Oracle listener?

    1. listener.ora

    2. lsnrctl.ora

    3. sqlnet.ora

    4. tnsnames.ora

  6. Which of the following is the correct way to start the default listener?

    1. lsnrctl startup listener

    2. lsnrctl start

    3. listener start

    4. listener start listener

  7. Which of the following parameters sets the number of seconds a server process waits to get a valid client request?

    1. connect_waittime_listener_name

    2. connect_wait_listener_name

    3. timeout_listener_name

    4. inbound_connect_timeout_listener_name

  8. When dynamic service registration is used, you will not see the service listed in which of the following files where it would normally be located?

    1. sqlnet.ora

    2. tnsnames.ora

    3. listener.ora

    4. None of the above

  9. You have just made changes to the listener.ora file for the listener called listener1 using Oracle Net Manager. Which of the following commands or combinations of commands would you use to put the changes into effect with the least amount of client disruption?

    1. lsnrctl stop listener1 followed by lsnrctl start listener1

    2. lsrnctl restart listener1

    3. lsnrctl reload listener1

    4. lsnrctl reload

  10. What is the default name of the process that makes external calls via Oracle Net?

    1. lsnrctl

    2. external

    3. extproc

    4. procext

  11. What are the ways in which a client can resolve a net service name? (Choose all that apply.)

    1. Localnaming

    2. Hostnaming

    3. Easy Connect Naming

    4. Oracle Global Naming

    5. All the above

  12. Connection Manager provides which of the following?

    1. Multiplexing

    2. Cross-protocol connectivity

    3. Network access control

    4. All the above

  13. Which is a requirement for using hostnaming?

    1. You must use tnsnames.ora on the client.

    2. You must be using TCP/IP.

    3. You must have an OID present.

    4. You must have a sqlnet.ora file present on the client.

    5. None of the above.

  14. To which of the choices below does the following statement apply? "Prevents direct communication between a client outside the corporate network and applications inside the corporate network."

    1. Proxy-based firewalls

    2. Filter-based firewalls

    3. Both types of firewalls

    4. Neither type of firewall

  15. Which of the following statements about tnsnames.ora is false?

    1. It is used to resolve an Oracle service name.

    2. It can exist on the client.

    3. It is used for localnaming.

    4. It does not support the TCP/IP protocol

  16. You manage a large network of servers with many Oracle10g instances configured on each server. The company would like to centralize the Oracle services into a common location for ease of maintenance. Which of the following would be the best choice for centralized naming services?

    1. Oracle Easy Connect Naming

    2. Localnaming

    3. Oracle Names Server

    4. Oracle Internet Directory

  17. A client receives the following error message:

    "ORA-12154 TNS:could not resolve the connect identifier
   specified"

    Which of the following could be possible causes of the error? (Choose all that apply.)

    1. The listener is not running on the Oracle server.

    2. The user entered an invalid net service name.

    3. The user supplied the correct net service name, but the net service name is misspelled in the tnsnames.ora file.

    4. The listener is not configured to listen for this service.

  18. What portion of the tnsnames.ora file specifies the name or IP address of the server where the listener process is listening?

    1. CONNECT_DATA

    2. PORT

    3. SERVICE_NAME

    4. HOST

  19. Which of the following is the utility that you can use to test the network connections across TCP/IP?

    1. trcasst

    2. lsnrctl

    3. namesctl

    4. ping

    5. None of the above

  20. A client wants to connect to the database dbprod.com located on the dbprod.com server to a non-default port using Oracle Easy Connect. Which of the following connect strings is the best choice for the client use?

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset