1Z0-026 - Oracle8i: Network Administration

Go back to Oracle

Example Questions

You execute Net8 Assistant to create a new listener for the PROD database. After defining the name of the listener as LSNprod1, the port address as 1521, and the protocol as TCP/IP, you save and exit. What is the status of the listener you just created? Which two methods could you use to add service names to a region database? (Choose two) How is the host name resolved using the host naming method? Which command displays the listener parameters when multiple listeners are used? In which file is the information that host naming is enabled stored? You setup MTS for the PROD database, which uses multiple listeners to handle requests. Which listener control command can you issue for each listener that the dispatchers have registered with all listeners used by the database? Which attributes(s) is (are) required when setting the MTS_DISPATCHERS parameter? Which folder would you use in the Net8 Assistant Tool to change the naming method? What are three characteristics of a listener? (Choose three) Which names directory object is a group of Net8 network clients and servers using the same industry-standard protocol? A DBA has installed and configured Net8 for TCP/IP on the client and server. But is still unable to connect from a Windows NT Workstation using SQL*Plus to an instance running on a remote UNIX server. However there are no problems when using FTP nodes. What action next taken by the DBA could make progress towards diagnosing the problem? When is the bequeath session used by default? Which two statements describe the MTS_MAX_SERVERS initialization parameter? (Choose two) How can the DBA determine the location of the listener log file? Oracle resolves service names to connection strings by using several methods. One of these methods is host naming. Which statement defines this method? What is the primary function of the OPA layer of the Net8 communication stack? Which three types of data are stored by Oracle names? (Choose three) Which two elements are necessary in an Oracle names directory administrative region? (Choose two) When would a client NOT be connected to a dispatcher in a multithreaded server environment? What does the connection attribute specify when enabling connection pooling? You configured centralized naming using Net8 Assistant. This configuration automatically created the names.ora file on the server. Which client-side file will reflect the resolution method when configured. Which statement about Net8 tracing is true? Given two data encryption algorithms, which one would be more secure? Your system has 900 concurrent users. They connect using TCP/IP and 255 connections per process are supported. How many dispatcher processes should the DBA initially specify? How can the DBA monitor the dispatcher processes? What is the listener name when you start the listener without specifying an argument? The Names server has become unavailable and users still need to access database services on the network. What can be accessed to obtain a current list of recently accessed services? Net8 should first try to resolve the service name according to the local naming method. What is the correct implementation? Which naming method simplifies administrative tasks when configuration changes need to be made available to all clients immediately? You created a listener named LSNR01 and want to assign it a unique log file name. What would be the parameter setting for default file name? Which two are tasks of the dispatcher process? (Choose two) When configuring for Network Access Protocol in which file can you define RULE_LIST parameters? When the Names Server is shutdown the service names are written to the _____________ File located in the ORACLE_HOME \network\names directory on NT or in the ORACLE_HOME/network/names directory on UNIX? When is the request sent to a listener? You are configuring MTS and set the LOCAL_LISTENER parameter in the init.ora to LSNR1. Which additional file must also reside on the node where the LSNR1 listener is running? Someone manages to read packages sent over the network. What does this compromise? Which feature needs to be configured in Connection Manager to enable your system to scale to a large number of users? You are preparing to setup local naming Net8 assistant. What must be established at the client and server level prior to this setup process? In a multithreaded environment which two criteria have to be met for a listener to give a client the address of a dispatcher? (Choose two) Which is the benefit of the Oracle Advanced Security option? A DBA has installed and configured Net8 for TCP/IP on the client and server, but is still unable to connect from a Windows NT workstation, using SQL *Plus, to an Oracle instance running on a remote UNIX server. However, there are no problems when using FTP between the two nodes. What action next taken by the DBA could make progress toward diagnosing the problem? Which naming method would be used when trying to reduce the administrative burden of keeping up with changes to server addresses on a network with a large number of nodes? Net8 Assistant can be used to configure a region database to be used by a Names Server. Which two methods can be used to populate the database with service names? (Choose two) Which statement is true about turning off the listener audit trail? Which domain naming model would be used to permit names to be repeated across different domains? Which statement regarding network security is false? Which statement is true when resolving addresses with Oracle Names? Which NAMESCTL command can be used to manually force Names Server discovery? When configuring the tnsnames.ora file for connection concentration which address is listed first in the description of the service net name? A DBA has installed and configured Net8 TCP/IP on the client and the server but is still unable to connect from Windows NT Workstation using SQL*Plus to an Oracle instance running on a remote UNIX server. However there are no problems when using FTP between two nodes. What actions next taken by the DBA could make progress towards diagnosing the problem?

Study Guides