1Z0-026 - Oracle8i: Network Administration
Go back to Oracle
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?
The listener has been created but the Database Services setup needs to be completed.
Which two methods could you use to add service names to a region database? (Choose two)
Restart the service names with the new region database.
Load them from another file using the Net8 Assistant Names Server section.
How is the host name resolved using the host naming method?
Through IP address translation mechanism.
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?
Protocol and number of dispatchers.
Which folder would you use in the Net8 Assistant Tool to change the naming method?
What are three characteristics of a listener? (Choose three)
The default name for listener is LISTENER.ORA.
Multiple listeners can listen on behalf of a single database.
The name of the listener must be unique on the machine where it resides.
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?
Connecting by using the Net8 Assistant Test Connection feature.
When is the bequeath session used by default?
When there are no prespawned server processes in a dedicated server environment.
Which two statements describe the MTS_MAX_SERVERS initialization parameter? (Choose two)
MTS_MAX_SERVERS specifies the number of shared server processes that can run simultaneously.
Shared server processes should be monitored to determine an ideal setting for MTS_MAX_SERVERS parameter.
How can the DBA determine the location of the listener log file?
Issue the SHOW LOG_DIRECTORY command.
Oracle resolves service names to connection strings by using several methods. One of these methods is host naming. Which statement defines this method?
The host naming method uses the name of the machine to establish the connection instead of the tnsnames.ora file.
What is the primary function of the OPA layer of the Net8 communication stack?
Maps TNS functions to industry standard protocol used in the client server connection.
Which three types of data are stored by Oracle names? (Choose three)
List of global database links.
Names and addresses of Names Server.
Names and listener addresses of all Connection Managers on the network.
Which two elements are necessary in an Oracle names directory administrative region? (Choose two)
One or more domains.
One or more dispatchers.
When would a client NOT be connected to a dispatcher in a multithreaded server environment?
The client requested a dedicated server.
What does the connection attribute specify when enabling connection pooling?
Maximum number of network connections for each dispatcher.
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?
Tracing should be enabled only for the duration of a process producing an error you are trying to resolve.
Given two data encryption algorithms, which one would be more secure?
The one with longer key length.
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?
BY queering the V$DISPATCHER dynamic performance view.
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)
Placing a request in the request queue.
Updating the listener with new LOAD values.
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?
After name resolution.
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)
A client must not request a dedicated server.
There must be an idle dispatcher available for the client.
Which is the benefit of the Oracle Advanced Security option?
Enables encrypted transmission of data.
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?
Checking to see of a local connection can be made to the database.
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)
Service names can be read from an existing tnsnames.ora file.
Service names can be loaded by issuing the NAMESCTL>reload command.
Which statement is true about turning off the listener audit trail?
The listener audit trail feature can never be turned off. It is always switched on by default.
Which domain naming model would be used to permit names to be repeated across different domains?
Which statement regarding network security is false?
Authorization permits a user to access the Internet through the company firewall.
Which statement is true when resolving addresses with Oracle Names?
The Names server resolves a service name client request by translating the service name to a connect string.
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?
Address for the CMGW process.
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?
Connecting by using the Net8 Assistant Test Connection feature.