Home » Other » Training & Certification » Network OCP Questions!
Network OCP Questions! [message #102488] Tue, 25 June 2002 00:00 Go to next message
Dilip
Messages: 12
Registered: January 2002
Junior Member
Read them and you'll pass definetly...

1Z0-026
*******
1. When using the host naming connection method, what are the required configuration files and where are they located?

Only the name of the host is required to establish a connection when using the host naming method. This eliminates the need for a tnsnames.ora file. The server only needs an active listener. The sqlnet.ora file must exist on the client and the listener.ora file must exist on the server.

2. You are evaluating different connection methods prior to implementing a networking architecture. All of the machines, including the server, have TCP/IP installed. Which connection method will you most likely choose if you are interested in making user configuration as easy as possible?

To use host naming, TCP/IP must be installed on both the client and the server. Host naming does not require a tnsnames.ora file and needs only minimal configuration compared to the other connection methods. The need to understand Oracle Names administration procedures is eliminated.

3. You received this error:

ORA-12545: TNS:name lookup failure

What should you do to resolve the problem?

The error ORA-12545 is returned when a client-side error occurs. This message is received when the user is unable to contact the listener on the remote node. To resolve this error, verify that the ADDRESS parameter in the tnsnames.ora file or the listener.ora file is correct, and verify that the listener on the remote node has been started.

4. Evaluate this variable and its value:

Names.directory_path = (TNSNAMES, HOSTNAME)

Which statement is true?

The information specified through the Net8 Assistant interface will populate the NAMES.DIRECTORY_PATH parameter with values in the sqlnet.ora file. By entering TNSNAMES then HOSTNAMES, local naming will be the first resolution method and host naming will be the second.

5. You are configuring local naming using the Net8 Assistant. You chose TNSNAMES as your method. What is the next step?

When configuring local naming using the Net8 Assistant, you will choose a connection method, specify a service name, choose a protocol, specify the host name and port, and specify the SID.

6. The connect descriptor in the tnsnames.ora file contains a network address. What is mapped to this address?

The local naming method resolves service names across networks running different protocols. The user only needs to provide the service name. This service name is mapped to the network address contained in a connect descriptor stored in the tnsnames.ora file.

7. You are configuring local naming using the Net8 Assistant. What is the first step?

When configuring local naming using the Net8 Assistant you will choose a connection method, specify a service name, choose a protocol, specify the host name and port, and specify the SID.

8. What is the Net8 Assistant?

The Net8 Assistant is a tool used to create and configure multiple components of Net8 such as listeners, database services, client profiles, region databases, and Names servers. It can be used to enable logging and tracing for listeners.

9. You want to have the option to use the host naming, local naming, and Oracle Names connection methods. Which entry in your sqlnet.ora file will enable this?

The sqlnet.ora file parameter used to identify connection methods is NAMES.DIRECTORY_PATH and the values to be used are HOSTNAME for host naming, TNSNAMES for local naming, and ONAMES for Oracle Names. These methods will be accessed in the order listed.

10. You are configuring local naming using the Net8 Assistant. You entered the SID you plan to connect to. What is the next step?

When configuring local naming using the Net8 Assistant, you will choose a connection method, specify a service name, choose a protocol, specify the host name and port, and specify the SID. You will then test the connection.

11. You created a new service name using the Oracle Service Name Wizard and realized that you entered the wrong SID. How can you correct the error?

You can modify an existing service name by selecting Modify after activating the Oracle Service Name Wizard.

12. Which connection method does not support Oracle Connection Manager features?

Oracle Connection Manager features are not supported with the host naming connection method. Host naming is used in a two-tier environment while Oracle Connection Manager is used in a three-tier environment.

13. You entered your username, password, and connect string to access a remote server from your client machine. The connect string matches the value of the GLOBAL_DBNAME parameter. Which connection method are you using?

The host naming method uses the GLOBAL_DBNAME parameter in the listener.ora file. The host name value specified for the listener.ora GLOBAL_DBNAME parameter and the connect string you enter must match exactly. The host name will be resolved using DNS, NIS, or a centrally maintained TCP/IP host file.

14. Which statement about the host naming method is true?

The host naming method requires minimal user configuration. The user only needs to provide the name of the host when establishing a connection. The need to create and maintain local names configuration files and the need to understand Oracle Names administration procedures is eliminated by the host naming method. TCP/IP must be installed on both the server and client machines for the host naming method. Only one database can be specified in a connect string when using the host naming method.

15. You are configuring your network connectivity in a very straightforward manner by having client machines connect directly to server listeners using the actual listener addresses. You are also using multiple protocols. Which connection method are you using to resolve service name addresses?

Local naming uses the straightforward method of connecting by placing service addresses in the tnsnames.ora file. This allows the client to connect directly to a server. Local naming supports multiple protocols.

16. Which client-side configuration files are configured when implementing the local naming method using the Net8 Assistant?

The tnsnames.ora and sqlnet.ora files are required on the client when using the local naming connection method. You must make sure that TNSNAMES is a selected m

17. Which tnsnames.ora file component describes the location of a network listener and the system identifier of the database the user is trying to connect to?

The local naming method resolves service names across networks running different protocols. The user only needs to provide the service name. This service name is mapped to the network address contained in a connect descriptor stored in the tnsnames.ora file. The connect descriptor is a network connection destination description. A connect descriptor identifies the network listener location and database SID that is to be connected to.

18. Evaluate this command:

SQL> connect spwag/samp789@order-sun.us.work.com

What is the SID_NAME value?

The host naming method uses the GLOBAL_DBNAME parameter in the listener.ora file. The host name value specified for the listener.ora GLOBAL_DBNAME parameter and the connect string you enter must match exactly. The host name will be resolved using DNS, NIS, or a centrally maintained TCP/IP host file.

This is the syntax for a connection request:
SQL> connect username/password@service_name

19. You are receiving this error:

ORA-12154: TNS:could not resolve service name

What could cause this error?

The error ORA-12154 is returned due to a client-side problem. The connect descriptor could not be located in the tnsnames.ora file. After checking that the connect descriptor is specified as it should be, check to see if there is a duplicate tnsnames.ora or sqlnet.ora file that is being utilized by mistake.

20. You are configuring local naming using the Net8 Assistant. You created a service name using the Oracle Service Name Wizard. What is the next step?

When configuring local naming using the Net8 Assistant, you will choose a connection method, specify a service name, choose a protocol, specify the host name and port, and specify the SID.

21. You are using the Net8 Assistant to configure local naming on the client. Select the ______ folder to verify that the TNSNAMES method is the selected method.

Use the Net8 Assistant to configure local naming on the client. Use the Profile folder to enable local naming by selecting the TNSNAMES method to resolve service names. Client profile information is stored in the sqlnet.ora file.

22. You used the Net8 Assistant to configure local naming. Which information must the client user know to be able to connect?

The local naming method resolves service names across networks running different protocols. The user only needs to provide the service name. This service name is mapped to the network address contained in a connect descriptor stored in the tnsnames.ora file.

23. You are using the local naming connection method. What is the ultimate destination of the address in your tnsnames.ora file?

The tnsnames.ora file contains the addresses a user needs to connect to a particular listener on a particular node using a specified database.

24. You are using the Net8 Assistant to configure local naming on the client. Select the ______ folder to configure a service name.

After selecting TNSNAMES as the method to resolve a service name, create a service name by selecting the Service Names folder and then selecting Edit --> Create. When a service name is created, the Net8 Assistant will start the Oracle Service Name Wizard to add, modify, delete, and test service names.

25. From which connection methods can you choose when using the Net8 Assistant?

The Net8 Assistant gives you the option of using any of the following connection methods: host naming (HOSTNAMES), local naming (TNSNAMES), Oracle Names (ONAMES), Cell Directory Services (CDS), Netware Directory Service (NDS), and Network Information Service (NIS).

26. You configured your machine for local naming using the Net8 Assistant. You tested your connection using the Test Service activated from the Service Name Wizard and it was successful. What should you do next?

After a connection has been successfully tested and configuration is complete, you must save your work by choosing File --> Save Network Configuration.

27. In which file would you set the FAILOVER and LOAD_BALANCE parameters to enable client load balancing and failover?

Load balancing and failover can be enabled by setting the FAILOVER and LOAD_BALANCE parameters in the tnsnames.ora file. Connection load balancing evenly distributes the active connections among the instances and dispatchers for the same service. When a client requests a connection, a listener is randomly selected from the list of listeners in the tnsnames.ora file. If the selected listener is not available, client load balancing and failover allows the listener to failover to the next available listener.

28. Which two statements about client load balancing and failover features are true?

When a client requests a connection, a listener is randomly selected from the list of listeners in the tnsnames.ora file. If the selected listener is not available, client load balancing and failover allows the listener to failover to the next available listener. Load balancing and failover can be enabled by setting the FAILOVER and LOAD_BALANCE parameters in the tnsnames.ora file. Connection load balancing is only available in a multithreaded server environment. Connection load balancing allows balancing of the load at the dispatcher and node levels.

29. The ______ file contains client information about host naming.

The host naming method requires TCP/IP to be installed on the client machine. The client information is stored on the client in the sqlnet.ora file.

30. Which file, used with the host naming connection method, would contain this line?

NAMES.DIRECTORY_PATH = (HOSTNAME)

Only the name of the host is required to establish a connection when using the host naming method. This eliminates the need for a tnsnames.ora file. The server only needs an active listener. The sqlnet.ora file must exist on the client and the listener.ora file must exist on the server. The NAMES.DIRECTORY_PATH parameter is in the sqlnet.ora file.

31. You are configuring local naming using the Net8 Assistant. You just entered a host name and port number. What is the next step?

When configuring local naming using the Net8 Assistant, you will choose a connection method, specify a service name, choose a protocol, specify the host name and port, and specify the SID. You will then test the connection.

32. You want Net8 to resolve service names using the local naming method first and the host naming method second. What should you enter in the Selected Methods field of the Methods tab in the Net8 Assistant?

The information specified through the Net8 Assistant interface will populate the NAMES.DIRECTORY_PATH parameter with values in the sqlnet.ora file. By entering TNSNAMES then HOSTNAMES, local naming will be the first resolution method and host naming will be the second.

33. Which connection method uses the tnsnames.ora file?

The tnsnames.ora file contains the addresses a user needs to connect to a particular listener on a particular node using a specified database. Local naming requires a local tnsnames.ora file on the client and the TNSNAMES method must be identified in the sqlnet.ora file.

34. You are configuring local naming using the Net8 Assistant. The defined network protocol is TCP/IP. What is the next step?

When configuring local naming using the Net8 Assistant for TCP/IP, you will choose a connection method, specify a service name, choose a protocol, specify the host name and port, and specify the SID. When using other protocols, the port number is not used.

35. Which connection method can Domain Name Services (DNS) to resolve a connect descriptor, requires that TCP/IP be installed on the server machine, and that a listener process be started on port 1521?

Which connection method can Domain Name Services (DNS) to resolve a connect descriptor, requires that TCP/IP be installed on the server machine, and that a listener process be started on port 1521?

36. You are using the host naming connection method and have entered this connect string from your client:

SQL> connect scott/tiger@selftest120

Which file contains this hostname?

The host naming method uses the GLOBAL_DBNAME parameter in the listener.ora file. The host name value specified for the listener.ora GLOBAL_DBNAME parameter and the connect string you enter must match exactly. The host name will be resolved using DNS, NIS, or a centrally maintained TCP/IP host file.

37. Which three statements about the host naming method are true?

When using host naming, the host name is resolved through an IP address translation mechanism. These mechanisms include Domain Name Services (DNS), Network Information Services (NIS), or a centrally maintained TCP/IP host file. TCP/IP, Net8, and the TCP/IP protocol adapter must be installed on both the client and server machines when using host naming. Oracle Connection Manager features are not supported through the host naming method.

38. Which connection method and corresponding configuration file uses this parameter?

GLOBAL_DBNAME =

A listener process must include the GLOBAL_DBNAME parameter. The GLOBAL_DBNAME parameter in the listener.ora file represents the global database name (hostname). The value of this parameter must exactly match the connect string entered by the user.

39. Which connection method removes the need for both the tnsnames.ora and names.ora files?

The host naming method eliminates the need to maintain the tnsnames.ora local names configuration file. The sqlnet.ora file is the only client file required for host naming. The server side requires the listener.ora file. Local naming requires the sqlnet.ora and tnsnames.ora files on the client. When using a Names server, the names.ora file is used.

40 You are using the host naming method. Evaluate this command:

SQL> connect samp/spw128@prod1-sun.us.work.com

What is the GLOBAL_DBNAME value?

The host naming method uses the GLOBAL_DBNAME parameter in the listener.ora file. The host name value specified for the listener.ora GLOBAL_DBNAME parameter and the connect string you enter must match exactly. The host name will be resolved using DNS, NIS, or a centrally maintained TCP/IP host file.

This is the syntax for a connection request:
SQL> connect username/password@service_name

41. How can you determine if a Names server is up and running on an NT machine?

The Names Control utility PING command will determine whether a Names server is up and running. The PING command returns the amount of time it took to connect to a Names server and an acknowledgement.

42. The Names Control utility PING command will determine whether a Names server is up and running. The PING command returns the amount of time it took to connect to a Names server and an acknowledgement.

Use the STOP command at the operating system prompt in a Windows NT environment to stop a Names server. The Names Control utility prompt in a Windows NT or a UNIX environment is NAMESCTL.

43. Which Names Control utility command is used to discover Names servers on the network?

The REORDER_NS command creates the file that lists the local Names servers and their addresses. This is completed by using the discovery process. This Names Control utility command finds existing Names servers in the local region, issues a PING command to determine the length of time for the Names servers to respond, and then creates a list of the Names servers sorted by response time.

44. You are using the Names Wizard to configure a region Names server. You selected the "Names server is not first in its region" button, and then clicked the "Discover Names server in the region" button. Why might the second of these steps take extra time to complete?

To discover Names servers in the network region, Names servers are contacted by using the address specified in the sqlnet.ora file, an existing Names server list, or a well-known Names server. When a Names server is found, a query is sent for all the Names servers in the local region. This operation may require some time to complete.

45. Which two files must be configured on the client and/or the Names server when implementing the centralized naming connection method? (Choose two.)

To configure centralized naming, the names.ora file on the Names server must be configured as well as the sqlnet.ora file on the client. The names.ora file for the Names server and the sqlnet.ora file can be configured using the Net8 Assistant or by manually editing the file.

46. Which step must be taken just prior to configuring a Names server's region database parameters?

A region database is a repository for Names server information. Prior to configuring a Names server database parameters, it must be started and the Names server initialization script must be run. The namesini.sql script creates tables within the schema of the region database. For NT machines, issue this command at the SQL prompt:
SQL> @$ORACLE_HOMEnetworknamesnamesini.sql
For UNIX machines, issue this command at the SQL prompt:
SQL> @$ORACLE_HOME/network/names/namesini.sql

47. You are configuring a new Names server using the Net8 Assistant. At which point is the names.ora file created?

When creating and configuring a Names server using the Net8 Assistant, the final task is to click the Finish button to complete the basic configuration. At this time a names.ora file is created with default values.

48. How does Oracle Names resolve client connect requests?

When a service name is resolved to an address, the mechanism is called name resolution. Oracle resolves service names to connection strings using local naming, host naming, external naming, or Oracle Names. When Oracle Names is used, the Names server is contacted for the address. The Names server resolves the service name and then sends the address back to the client. The names.ora file is stored on the Names server.

49. You added service names to a region database manually using the Net8 Assistant. Which method would achieve the same results?

Service names can be manually added to a region database using Net8 Assistant. Restart the Names server, select Manage Data from the pull-down menu, and click the Add button. Enter the service name, host name and port, verify that the SID, protocol, and server type are correct, and click Execute.

Service names can be read from an existing tnsnames.ora file. Use the LOAD command with the explicit path and file name of the tnsnames.ora file.

50. Which parameter in the sqlnet.ora file is used to specify the naming method(s) for centralized naming?

The NAME.DIRECTORY_PATH parameter could be set to TNSNAMES, HOSTNAME, or ONAMES. For Oracle Names, select the ONAMES method. Use the Net8 Assistant to choose the naming method for Oracle Names or manually edit the NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file.

51. When configuring a region database, which four values are required? (Choose four.)

Use the Net8 Assistant to configure a region database by selecting the Configure Server from the pull-down menu for the appropriate Names server. Select the Database tab, and click the Region Database button. Enter the host name and port number of the listener that is running on the machine that is configured as the region database. Enter the SID of the database that is to store the region information. Enter the username and password for the Names user that will connect to the new region database.

52. You are configuring a region database using the Net8 Assistant and would like to use a service name that already exists in another tnsnames.ora file. How can you do this?

Service names can be manually added to a region database using Net8 Assistant. Restart the Names server, select Manage Data from the pull-down menu, and click the add button. Enter the service name, host name and port, verify that the SID, protocol, and server type are correct, and click Execute.

53. You want the server to check the administrative region, immediately reloading database service names, aliases, and global database links if any data changes are found. Which Names Control utility command will you use?

The Names Control utility RELOAD command is used to immediately reload any database service names, aliases, and global database links that have been updated in the administrative region.

54. NT hangs as you attempt to start the Names server using the Net8 Assistant. What should you do to start the Names server to view status information?

Start the Names server using the NAMESCTL utility and the START command. Execute the STATUS command to view the status information for the Names server. You could start the Names server through the Control Panel rather than the Names Control utility, but you would not be able to retrieve status information.

55. What are the basic tasks required to implement centralized naming?

Use the Names Wizard, activated from the Net8 Assistant, to create and configure the Names server, review the names.ora file to make sure that it is configured correctly, and start up the Names server to make sure it works. The names.ora file can also be edited manually.

56. Which command can be used to activate a Names server using the Names Control utility?

Start the Names server using the NAMESCTL utility and the START command. Execute the STATUS command to view the status information for the Names server. You could start the Names server through the Control Panel rather than the Names Control utility, but you would not be able to retrieve status information.

57. You are using the Net8 Assistant to configure the client profile for centralized naming. Which value will you enter into the Selected Methods field located in the Methods tab?

The NAME.DIRECTORY_PATH parameter could be set to TNSNAMES, HOSTNAME, or ONAMES. For Oracle Names, select the ONAMES method. Use the Net8 Assistant to choose the naming method for Oracle Names or manually edit the NAMES.DIRECTORY_PATH parameter in the sqlnet.ora file.

58. What is a region database?

A region database is a repository for Names server information. Prior to configuring a Names server database parameters, it must be started and the Names server initialization script must be run. The namesini.sql script creates tables within the schema of the region database. For NT machines, issue this command at the SQL prompt:
SQL> @$ORACLE_HOMEnetworknamesnamesini.sql
For UNIX machines, issue this command at the SQL prompt:
SQL> @$ORACLE_HOME/network/names/namesini.sql

59. When the Names server is shut down, service names are written to which file?

When adding a service name using the Net8 Assistant, select Manage Data from the pull-down menu. Click the Add button, and enter the service name for the Names server. Verify that the SID, protocol, and server type values are correct, and click Execute. When the Names server is shut down, service names are written to the ckpreg.ora file. This file is located in the ORACLE_HOMEnetworknames directory on NT and in the ORACLE_HOME/network/names directory on UNIX. When deleting a Names server on NT, this file must be deleted.

60. How does the Names Control Utility determine the time it takes to reach each Names server during the discovery process?

This Names Control utility command finds existing Names servers in the local region, issues a PING command to determine the length of time for the Names servers to respond, and then creates a list of the Names servers sorted by response time.

61. Your network environment has a region database. You want to know how many region data reload check failures there have been, if any. How can you access this information?

Issue the STATUS command from the Names Control utility to receive a detailed report on an assortment of information concerning a particular Names server. The information includes the names and locations of the names.ora, trace, and log files.

62. What is required to implement centralized naming?

The Names server is configured by editing the names.ora file, and the Names client profile is configured by editing the sqlnet.ora file. These files may be configured with the Net8 Assistant or by manually editing the file.

63. When connecting from a client directly to a server, the service name maps directly to a connect descriptor. Which three Oracle methods can be used to resolve the connect descriptor? (Choose three.)

When connecting to a server, the listener process is responsible for detecting and routing the incoming requests to their proper destination. A process must be listening for incoming requests on the server in order for a client to connect to the server.

A service name can be resolved through host naming, local naming, or Oracle Names. Host naming resolves a service name using the sqlnet.ora file. Local naming resolves a service name using the tnsnames.ora file. Oracle Names resolves a service name using the sqlnet.ora file and an Oracle Names server.

64. You are using native naming parameters while connecting from client to server. Which configuration file stores the native naming parameter values?

The sqlnet.ora file contains client profile information. The client profile includes optional diagnostic parameters, client information about Oracle Names, and other optional parameters. The optional parameters include native naming and security. The sqlnet.ora file is used by all clients and servers on the network. The default location of the file can be specified using the TNS_ADMIN environment variable.

The sqlnet.ora file is used by all the clients and servers on the network. It stores client profile information. If Oracle Names is used, it stores client information for this names resolution method. It also stores diagnostic parameters and other optional parameters such as native naming and security.

65. When connecting from a client directly to a server, what happens after the address of the process is passed to the client-side process?

A listener process must be listening for incoming requests on the server-side for a client to connect to the server. When connecting to a server, these steps are used by all connections:

1. A connection request is initiated. A username, password, and service name are provided.
2. The service name is resolved to a connection string. The service name maps directly to a connect descriptor.
3. A request is sent to the listener on the server-side. The listener receives the request and determines where to direct the request.
4. The listener spawns a new process or redirects the connection to an existing process.
5. The address of the process is given to the client-side process. The client then communicates directly with the server-side process for the duration of the session.

66. Which situation is the OPA Net8 stack layer responsible for resolving?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The OPA layer is responsible for mapping TNS functions to industry-standard protocols used in a client-server connection.

67. While connecting from your client to a server, the connect descriptor was resolved with local naming. Which configuration file was used?

When connecting to a server, the listener process is responsible for detecting and routing the incoming requests to their proper destination. A process must be listening for incoming requests on the server in order for a client to connect to a server.

A service name can be resolved through Host naming, Local naming, or Oracle Names. Host naming resolves a service name using the sqlnet.ora file. Local naming resolves a service name using the tnsnames.ora file. Oracle Names resolves a service name using the sqlnet.ora file and an Oracle Names server.

The tnsnames.ora file contains the names and addresses of services on the network. Both clients and distributed servers use this file to identify destination servers.

68. When connecting from a client directly to a server, what happens after a request is sent to the listener?

A listener process must be listening for incoming requests on the server-side for a client to connect to a server. When connecting to a server, these steps are used by all connections:

1. A connection request is initiated. A username, password, and service name is provided.
2. The service name is resolved to a connection string. The service name maps directly to a connect descriptor.
3. A request is sent to the listener on the server-side. The listener receives the request and determines where to direct the request.
4. The listener spawns a new process or redirects the connection to an existing process.
5. The address of the process is give to the client-side process. The client then communicates directly with the server-side process for the duration of the session.

69. Which server stack communication layer is used in place of OCI when using distributed transactions?

An Oracle server-server distributed transaction passes data information through these layers:

1. Server (server)
2. Network Program Interface (NPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The NPI layer is used when two servers communicate to complete a distributed transaction. The layers are the same as in the client-server scenario, except that there is no client application.

70. While connecting from your client directly to a server, the connect descriptor was resolved with host naming. Which configuration file was used?

When connecting to a server, the listener process is responsible for detecting and routing the incoming requests to their proper destination. A process must be listening for incoming requests on the server in order for a client to connect to the server.

A service name can be resolved through host naming, local naming, or Oracle Names. Host naming resolves a service name using the sqlnet.ora file. Local naming resolves a service name using the tnsnames.ora file. Oracle Names resolves a service name using the sqlnet.ora file and an Oracle Names server.

The sqlnet.ora file is used by all the clients and servers on the network. It stores client profile information. If Oracle Names is used, it stores client information for this names resolution method. It also stores diagnostic parameters and other optional parameters such as native naming and security.

71. Which statement about the Dead Connection Detection feature is NOT true?

The Dead Connection Detection feature allows Net8 to identify connections that have been left hanging by an abnormal termination of a client. When an abnormal termination is detected, the broken connection's uncommitted transactions are rolled back and its locks are released. This feature minimizes the waste of resources. Set the SQLNET.EXPIRE_TIME parameter to enable this feature.

72. Which situation is the Two Task Common Net8 stack layer responsible for resolving?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The Two Task Common layer is responsible for character set and data type conversions between different character sets or formats on the client and server. This layer performs conversion only when required by a connection. The Two Task Common layer evaluates the differences and determines whether conversions are required for the two computers to communicate.

73. Which situation is the TNS Net8 stack layer responsible for resolving?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The TNS layer provides generic interface-standard protocols. It resolves all generic machine-level issues including whether one or more protocols are involved in the connection and how to handle interrupts between the client and server.

74. For which task is the Protocol Net8 stack layer responsible?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The Protocol layer is responsible for transmitting the data from the client machine to the server machine. The data is passed to the server-side protocol adapter.

75. Which server process detects connect requests?

When connecting to a server, the listener process is responsible for detecting and routing the incoming requests to their proper destination. A process must be listening for incoming requests on the server in order for a client to connect to the server.

76. Which file contains client profile information when using Oracle Names?

The sqlnet.ora file contains client profile information. The client profile includes optional diagnostic parameters, client information about Oracle Names, and other optional parameters. The sqlnet.ora file is used by all clients and servers on the network. The default location of the file can be specified using the TNS_ADMIN environment variable.

77. You are running a form on a client PC and plan to fetch rows from a remote database. Which Net8 stack layer is used to define the call to the server?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The OCI code contains the information needed to initiate a SQL dialogue between the client and the server. The OCI code define the calls to the server for these tasks: parse SQL statements; open cursors; bind variables; execute SQL; fetch data; and close cursors.

78. Evaluate this connect string:

scott/tiger@db1

In this connect string, what is a service name?

When connecting to a server, a user or program resolves the service name to a connection string. A service name is an alias for a destination address and maps directly to a connect descriptor. It follows the user name and password in a connect string and looks like this:
@DB1.

79. A user has shut down their PC without properly exiting the application they were using. Which Net8 feature can detect this abnormal connection?

The Dead Connection Detection feature allows Net8 to identify connections that have been left hanging by an abnormal termination of a client. When an abnormal termination is detected, the broken connection's uncommitted transactions are rolled back and its locks are released. This feature minimizes the waste of resources.

80. For which task is the OCI Net8 stack responsible?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The OCI code contains the information needed to initiate a SQL dialogue between the client and the server. The OCI code define the calls to the server for these tasks: parse SQL statements; open cursors; bind variables; execute SQL; fetch data; and close cursors.

81. Through which Net8 stack layer are database operations passed to the server from a client application?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The OCI code contains the information needed to initiate a SQL dialogue between the client and the server. The OCI code define the calls to the server for these tasks: parse SQL statements; open cursors; bind variables; execute SQL; fetch data; and close cursors.

82. Which configuration file contains the names and addresses of services on the network?

The tnsnames.ora file contains the names and addresses of services on the network. Both clients and distributed servers use the tnsnames.ora file to identify destination servers. The default location for this file can be specified using the TNS_ADMIN environment variable.

83. Which stack communication layer resolves SQL statements after pressing the save button in your client form?

An Oracle client-server transaction passes data information through these layers:

1. Application (client) / Server (server)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The server layer is responsible for receiving requests from the client OCI code and resolving the SQL statements on behalf of the client application. The resulting data is passed to the OPI layer.

84. What are the six layers in the client Net8 stack?

The six stack communication layers are client application, Oracle Call Interface or User Program Interface, Two Task Common, Transparent Network Substrate, Oracle Protocol Adaptors, and network specific protocols. Each layer of the stack is responsible for one or more specific tasks to perform a client-server transaction.

85. Which two statements about connection breaks are true?

Inband breaks are transmitted as part of the regular data traffic between the client and server using the normal protocol read and write functions. Outband breaks are faster than inband breaks because the break message is sent using urgent data messages. From the server perspective, inband breaks use messages that are simply queued and outband breaks use messages that cause signals which take load off the server and can break faster.

86. Which server Net8 stack layer responds to client OCI layer fetch requests?

An Oracle client-server transaction passes data information through these layers:

1. Application (client) / Server (server)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The OPI layer is the server compliment to the client OCI layer. The OPI layer is responsible for responding to each of the messages sent by the OCI.

87. When connecting from a client directly to a server, what happens after the service name has been resolved?

A listener process must be listening for incoming requests on the server-side for a client to connect to the server. When connecting to a server, these steps are used by all connections:

1. A connection request is initiated. A username, password, and service name are provided.
2. The service name is resolved to a connection string. The service name maps directly to a connect descriptor.
3. A request is sent to the listener on the server-side. The listener receives the request and determines where to direct the request.
4. The listener spawns a new process or redirects the connection to an existing process.
5. The address of the process is given to the client-side process. The client then communicates directly with the server-side process for the duration of the session.

88. What is needed for a client to connect directly to a server?

When connecting to a server, the listener process is responsible for detecting and routing the incoming requests to their proper destination. A process must be listening for incoming requests on the server in order for a client to connect to the server.

89. You are entering and saving data to a remote database server from your client application. Which Net8 layer enables the parsing of your SQL statements?

An Oracle client-server transaction passes data information through these layers:

1. Application (client)
2. Oracle Call Interface (OCI) or Oracle Program Interface (OPI)
3. Two Task Common
4. Transparent Network Substrate (TNS)
5. Oracle protocol adapters (OPA)
6. Network-specific protocols

The OCI code contains the information needed to initiate a SQL dialogue between the client and the server. The OCI code define the calls to the server for these tasks: parse SQL statements; open cursors; bind variables; execute SQL; fetch data; and close cursors.

90. When connecting from a client directly to a server, what happens after the listener determines where to direct the client request?

A listener process must be listening for incoming requests on the server side for a client to connect to the server. When connecting to a server, these steps are used by all connections:

1. A connection request is initiated. A username, password, and service name are provided.
2. The service name is resolved to a connection string. The service name maps directly to a connect descriptor.
3. A request is sent to the listener on the server-side. The listener receives the request and determines where to direct the request.
4. The listener spawns a new process or redirects the connection to an existing process.
5. The address of the process is given to the client-side process. The client then communicates directly with the server-side process for the duration of the session.

91. What are the first two steps in connecting from a client directly to a server?

A listener process must be listening for incoming requests on the server-side for a client to connect to the server. When connecting to a server, these steps are used by all connections:

1. A connection request is initiated. A username, password, and service name are provided.
2. The service name is resolved to a connection string. The service name maps directly to a connect descriptor.
3. A request is sent to the listener on the server-side. The listener receives the request and determines where to direct the request.
4. The listener spawns a new process or redirects the connection to an existing process.
5. The address of the process is given to the client-side process. The client then communicates directly with the server-side process for the duration of the session.

92. You are evaluating different architecture configurations. You want to reduce the time and cost spent maintaining the server names and locations on all the different nodes by your system administrators. Which connection method would best resolve this requirement?

You are evaluating different architecture configurations. You want to reduce the time and cost spent maintaining the server names and locations on all the different nodes by your system administrators. Which connection method would best resolve this requirement?

93. Which statement about the hierarchical domain naming model is true?

All the names for the objects in a domain must be unique. To name objects in a domain, you can use the flat naming model or the hierarchical naming model. The hierarchical naming model enables the distribution of network administration responsibilities. This method allows the domain hierarchy to be extended to any number of levels. The hierarchical model contains unique names for each domain, but permits names to be repeated across domains. This method is commonly used in large organizations. The flat naming model is the most commonly used naming model.

94. How does host naming resolve a service name to a connect string?

Host naming uses the name of the actual machine on which the database resides to establish a connection to the service. Local naming uses a tnsnames.ora file to look up service names. Centralized naming uses Oracle Names to maintain a central storage of network service addresses. External naming uses various third-party name resolution mechanisms.

95. Which connection method maintains consistency between all nodes, reduces administration costs when configuration changes are required quickly, and can work alongside Connection Manager?

By using the names.ora file on the Names server, the need to maintain multiple configuration files (tnsnames.ora for example) is eliminated. This reduces administration costs and maintains consistency when changes to the configuration must be made because the change is made in one place. Centralized naming also works with Connection Manager.

96. The ______ domain naming model enables the distribution of network administrative capabilities.

All the names for the objects in a domain must be unique. To name objects in a domain, you can use the flat naming model or the hierarchical naming model. The hierarchical naming model enables the distribution of network administration responsibilities. This model contains unique names for each domain, but permits names to be repeated across domains. This method is commonly used in large organizations.

97. How is an address resolved by Oracle Names?

Oracle Names uses a Names server to resolve a service name client request by translating the service to a connect string. The client is configured to use a Names server to resolve the service name. Host naming uses the name of the actual machine on which the database resides to establish a connection to the service. Local naming uses a tnsnames.ora file to look up service names. Centralized naming uses Oracle Names to maintain a central storage of network service addresses. External naming uses various third-party name resolution mechanisms.

98. Which statement about Oracle Names Directory Objects is true?

A Community is a group of Net8 network clients and servers using the same industry-standard protocol. Oracle recommends one Names server per community.

Each administrative region includes one or more domains and one or more Names servers. Each region has a single repository database.

There are two domain naming models for Oracle Names Directory Objects. The flat model consists of a single domain and is used when the entire network is centrally administered. The hierarchical model enables distribution of network administration responsibilities.

99. When would it be most appropriate to use a hierarchical domain naming model?

All the names for the objects in a domain must be unique. To name objects in a domain, you can use the flat naming model or the hierarchical naming model. The hierarchical naming model enables the distribution of network administration responsibilities. This model contains unique names for each domain, but permits names to be repeated across domains. This method is commonly used in large organizations.

100. What are three benefits of using centralized naming?

Administration tasks are reduced when addresses are stored on one server node. Server names and locations are defined only once, and server address changes are made in one place.

101. Which statement about centralized naming is true?

Centralized naming uses Oracle Names. It is a Names service that maintains a central storage of network service addresses. The centralized naming method reduces administrative burdens for network environments that are not dynamically configurable. Centralized naming reduces redundancy because server address changes are made in one place.

102. Which is a characteristic of centralized naming?

Centralized naming uses a Names server to simply administrative tasks because the names and locations of servers only need to be defined once. Increased efficiency is achieved by using centralized naming because server addresses are stored on one or more Oracle Names server nodes. This eliminates the need to store the addresses on every node. Redundancy is eliminated because server address changes are made in one place. Using a Names server facilitates server location transparency by allowing the client to use a symbolic service name for the server location.

103. Which two statements about a Names Directory Administrative region are true?

An administrative region is an organizational entity for administering Net8 network components. Each region includes one or more domains and one or more Names servers. All the connect information is stored in a single repository. Each region may have multiple servers and clients.

104. Which three statements about Oracle Names are true?

Oracle Names uses a Names server to resolve service names. Oracle Names stores a list of global database links. Oracle Names stores the names and addresses of the Names servers. Clients are configured to use a Names server to resolve service names. The names and listener addresses of all the Connection Managers on the network are stored by Oracle Names.

105. A connection is being processed in a multithreaded server configuration. What occurs after the request is picked up for processing from the request queue by a shared server?

The steps of request processing are as follows:

1) A connection request is sent to a dispatcher from a user.
2) The request is placed in the SGA request queue by the dispatcher.
3) The request is picked up for processing from the request queue by a shared server.
4) A response is placed in the calling dispatcher's response queue.
5) The dispatcher retrieves the response from its queue.
6) The response is returned to the user from the dispatcher.

106. Which initialization file parameter is used to activate specific dispatcher characteristics?

To configure a multithreaded server, edit the initialization parameter file for the instance. The MTS parameters include MTS_SERVICE, MTS_DISPATCHERS, MTS_MAX_DISPATCHERS, MTS_SERVERS, and MTS_MAX_SERVERS. In most environments, only the MTS_SERVERS and MTS_DISPATCHERS parameters need to be altered from their default values. The MTS_DISPATCHERS parameter enables the specification of attributes such as protocol, network address, network description, listener, and service.

107. How are connection requests processed in the request queue of an MTS configuration?

In a multithreaded server environment, a user sends a request to its dispatcher. The dispatcher places the request into the request queue in the SGA. All of the dispatchers share one request queue. A shared server picks up the request and processes the request. Requests are processed on a first in, first out basis.

108. Which init.ora MTS_DISPATCHERS parameter attribute, used to enable connection pooling, should be set to a lower value than the number specified for the SESSIONS attribute?

The connection pooling feature allows for the maximization of the number of physical network connections to a multithreaded server (MTS). The SESSIONS attribute defines the number of user processes per dispatcher and CONNECTION defines the maximum number of connections against the database through a dispatcher. The difference between the two values specifies how many sessions can be in a waiting state for processing a request.

109. Which file is used to configure a multithreaded server?

To configure a multithreaded server, edit the initialization parameter file for the instance. The MTS parameters include MTS_SERVICE, MTS_DISPATCHERS, MTS_MAX_DISPATCHERS, MTS_SERVERS, and MTS_MAX_SERVERS. In most environments, only the MTS_SERVERS and MTS_DISPATCHERS parameters need to be altered from their default values.

110. You are configuring an MTS environment and have set the MTS_SERVERS parameter to 4 in the init.ora file. You have not added any additional servers. How do servers become deallocated?

The MTS_SERVERS parameter sets the number of initial servers. Initial servers always stay allocated even when idle. Additional servers become deallocated when they are idle for too long a period.

111. Which two parameters are usually modified when configuring the init.ora file for an MTS server?

To configure a multithreaded server, edit the initialization parameter file for the instance. The MTS parameters include MTS_SERVICE, MTS_DISPATCHERS, MTS_MAX_DISPATCHERS, MTS_SERVERS, and MTS_MAX_SERVERS. In most environments, only the MTS_SERVERS and MTS_DISPATCHERS parameters need to be altered from their default values. MTS_SERVERS defines the initial number of shared servers started and MTS_DISPATCHERS defines the initial number of dispatchers for a given protocol.

112. Which command will change the minimum number of shared server processes?

When the load is too great, users may have to wait too long for a connection. If the load is consistently high, start new dispatcher processes to route user requests without waiting. New dispatchers can be started until MTS_MAX_DISPATCHERS is reached. If the load is consistently low, reduce the number of dispatchers. Use the ALTER SYSTEM command to remove dispatchers to the value in MTS_DISPATCHERS. The syntax for the SQL command is ALTER SYSTEM SET MTS_SERVERS=value.

113. You want multiple user processes to share a number of server processes. Which configuration will you use?

A multithreaded server configuration allows for the support of more users by sharing server processes. Rather than waiting for specific users to issue requests, any server can process incoming requests. For example, 100 users could share 10 server processes.

114. Which two factors should be considered when determining how many shared server processes are needed?

The MTS_SERVERS parameter specifies the number of shared servers initially started. The number of shared server processes should be determined by how many users will be connecting and how much processing each will require.

115. Your MTS system is experiencing too much overhead. What can you do to correct the problem?

The MTS_SERVERS parameter specifies the number of shared servers initially started. There may be unnecessary overhead in your multithreaded server (MTS) environment if the initial number of servers is set too high. It is best to estimate fewer initial shared server processes.

116. Where is user session data held when using a multithreaded server configuration?

In a dedicated server environment, user session data is stored in the PGA. In a multithreaded server environment, user session data is stored in the SGA. The change in PGA and SGA is transparent to users.

117. When configuring an MTS server, which initialization file parameter attribute is used to define the number of dispatchers to be started?

To configure a multithreaded server, edit the initialization parameter file for the instance. The MTS parameters include MTS_SERVICE, MTS_DISPATCHERS, MTS_MAX_DISPATCHERS, MTS_SERVERS, and MTS_MAX_SERVERS. In most environments, only the MTS_SERVERS and MTS_DISPATCHERS parameters need to be altered from their default values. The MTS_DISPATCHERS parameter DISPATCHERS attribute is used to specify the initial number of dispatchers when configuring a multithreaded server (MTS) environment.

118. After reviewing dispatcher load information in the V$CIRCUIT and V$DISPATCHER views, and checking the value of the MTS_MAX_DISPATCHERS parameter, you added several dispatchers. What was the initial problem that caused you to take this action?

The V$CIRCUIT and V$DISPATCHER views are used to monitor dispatcher loads. When the load is too great, users may have to wait too long for a connection. If the load is consistently high, start new dispatcher processes to route user requests without waiting. New dispatchers can be started until MTS_MAX_DISPATCHERS is reached. If the load is consistently low, reduce the number of dispatchers. Use the ALTER SYSTEM command to remove dispatchers to the value in MTS_DISPATCHERS.

119. Which configuration file is used to configure connection pooling in an MTS environment?

The connection pooling feature allows for the maximization of the number of physical network connections to a multithreaded server (MTS). The MTS_DISPATCHERS parameter in the init.ora file is used to configure connection pooling in a multithreaded server (MTS) environment.

120. Which protocol is used for dispatchers when using an MTS configuration in an NT environment?

TCP/IP is the only protocol that can be used when configuring a multithreaded server (MTS) in an NT environment.

121. What is a result of this command?

ALTER SYSTEM SET MTS_DISPATCHERS='(PROTOCOL=TCP)(DISPATCHERS=5)';

To configure a multithreaded server, edit the initialization parameter file for the instance. The MTS parameters include MTS_SERVICE, MTS_DISPATCHERS, MTS_MAX_DISPATCHERS, MTS_SERVERS, and MTS_MAX_SERVERS. In most environments, only the MTS_SERVERS and MTS_DISPATCHERS parameters need to be altered from their default values. The PROTOCOL attribute of the MTS_DISPATCHER parameter specifies which protocol is to be used by a dispatcher. In this case, it is TCP/IP. The DISPATCHERS attribute specifies the initial number of dispatchers started.

122. Which init.ora parameter, when set to 0, can be used to temporarily disable a multithreaded server?

The MTS_SERVERS parameter specifies the number of shared servers initially started. The default value of the MTS_SERVERS parameter is 0 which does not start any shared servers. If a nonzero value is altered and set to 0 using the ALTER SYSTEM command while the servers are running, they will be terminated temporarily when they become idle.

123. Which database view provides information on MTS connections made through servers and dispatchers?

The V$CIRCUIT view holds information concerning virtual circuits which are connections through servers and dispatchers to the database.

The V$MTS view is used for tuning purposes in your multithreaded server environment and contains information such as the maximum number of servers started. V$SESSION lists session information for each current session. V$SHARED_SERVER contains information on the shared server processes. V$DISPATCHER provides information on the dispatcher processes.

124. The current number of sessions for a dispatcher is less than the maximum configured when a connection request comes in. How is the session request handled when connection pooling is enabled in an MTS environment?

When a connection request is received, it is handled immediately if the maximum number of sessions for a dispatcher are less than configured. If not, the session waits for the dispatcher to temporarily disconnect an idle connection, and then establishes a connection for the session.

125. Which view can be used in conjunction with other views to provide relevant information before reconfiguring a multithreaded server for tuning purposes?

The V$MTS view is used for tuning purposes in your multithreaded server environment and contains information such as the maximum number of servers started.

V$QUEUE contains information on the multithreaded message queues. V$SESSION lists session information for each current session. V$CIRCUIT contains information about virtual circuits. V$SHARED_SERVER contains information on the shared server processes.

126. Which LSNRCTL command would you use to validate the dispatchers registered with the listeners?

The SERVICES command verifies dispatchers registered with the listener at database startup.

127. A connection is being processed in a multithreaded server configuration. What happens after a response is placed on the calling dispatcher's response queue by a shared server and before the response is returned to the user from the dispatcher?

The steps of request processing are as follows:

1) A connection request is sent to a dispatcher from a user.
2) The request is placed in the SGA request queue by the dispatcher.
3) The request is picked up for processing from the request queue by a shared server.
4) A response is placed in the calling dispatcher's response queue.
5) The dispatcher retrieves the response from its queue.
6) The response is returned to the user from the dispatcher.

128. Which init.ora parameter is used to enable connection pooling?

The connection pooling feature allows for the maximization of the number of physical network connections to a multithreaded server (MTS). To enable connection pooling, use the POOL attribute of the MTS_DISPATCHERS initialization parameter. Use the CONNECTION attribute to set the maximum number of network connections for each dispatcher.

129. Connection pooling has been enabled, and you wish to set the waiting period to 50 seconds for a connection when all dispatchers are busy. On your platform, tick is set to 10 seconds. Which parameter, attribute, and value will you use to accomplish this?

The connection pooling feature allows for the maximization of the number of physical network connections to a multithreaded server (MTS). To enable connection pooling, use the POOL attribute of the MTS_DISPATCHERS initialization parameter. Use the CONNECTION attribute to set the maximum number of network connections for each dispatcher. TICKS is the MTS_DISPATCHERS parameter used to specify the waiting period of 50 (5 x10 = 50 seconds).

130. The maximum number of concurrent sessions for your server is estimated to be 200 and the connections per dispatcher is 10. What should the MTS_MAX_DISPATCHERS parameter be set to?

To configure a multithreaded server, edit the initialization parameter file for the instance. The MTS parameters include MTS_SERVICE, MTS_DISPATCHERS, MTS_MAX_DISPATCHERS, MTS_SERVERS, and MTS_MAX_SERVERS. In most environments, only the MTS_SERVERS and MTS_DISPATCHERS parameters need to be altered from their default values. The formula used to estimate the maximum number of dispatchers is:

maximum number of
concurrent sessions
MTS_MAX_DISPATCHERS = ------------------------------------------
connections per dispatcher

131. A connection is being processed in a multithreaded server configuration. What is the first step in this process?

The steps of request processing are as follows:

1) A connection request is sent to a dispatcher from a user.
2) The request is placed in the SGA request queue by the dispatcher.
3) The request is picked up for processing from the request queue by a shared server.
4) A response is placed in the calling dispatcher's response queue.
5) The dispatcher retrieves the response from its queue.
6) The response is returned to the user from the dispatcher.

132. A connection is being processed in a multithreaded server configuration. What happens once a request is placed in the SGA request queue?

The steps of request processing are as follows:

1) A connection request is sent to a dispatcher from a user.
2) The request is placed in the SGA request queue by the dispatcher.
3) The request is picked up for processing from the request queue by a shared server.
4) A response is placed in the calling dispatcher's response queue.
5) The dispatcher retrieves the response from its queue.
6) The response is returned to the user from the dispatcher.

133. You want a configuration that can handle an increase in the number of users, reduce memory usage and system overhead, and achieve load balancing. Which type of configuration will you choose?

In a multithreaded server environment, server processes are shared among user processes. In a dedicated server environment, each user requires a dedicated server connection. Memory usage in a multithreaded server configuration is reduced because the number of server processes required is reduced. This enables greater scalability and helps with load balancing.

134. You have an MTS configured network where many clients use "high idle/search time" applications. Which resource utilization feature should you use?

Messaging applications, OLAP, and many other client applications that have a high idle/search time and can afford a wait time for connection are good candidates for connection pooling. To enable connection pooling, use the POOL attribute of the MTS_DISPATCHERS initialization parameter. Use the CONNECTION attribute to set the maximum number of network connections for each dispatcher.

135. Which resource utilization feature is being used when sharing a dispatcher's set of connections among multiple client processes in an MTS environment?

The connection pooling feature allows for the maximization of the number of physical network connections to a multithreaded server (MTS). To enable connection pooling, use the POOL attribute of the MTS_DISPATCHERS initialization parameter. Use the CONNECTION attribute to set the maximum number of network connections for each dispatcher.

136. A dispatcher has reached its maximum load when a connection request is received. How is the session request handled when connection pooling is enabled in an MTS environment?

When a connection request is received it is handled immediately if the maximum number of sessions for a dispatcher are less than configured. If not, the session waits for the dispatcher to temporarily disconnect an idle connection, and then establishes a connection for the session.

137. Which two statements about a multithreaded server environment are true?

In a multithreaded server environment, server processes are shared among user processes. The dispatcher process returns responses to the user. There is one request queue per database in a multithreaded server environment. There is one request queue per dispatcher in a multithreaded server environment. If the user process has the same protocol and the dispatcher process, the listener gives the user process the address of a dispatcher process. If client requests a dedicated server, the listener creates a dedicated server process and connects the user to it.

138. Which MTS_DISPATCHERS attribute can be modified to set a maximum number of connections per dispatcher in an environment configured for connection pooling?

The CONNECTION attribute of the MTS_DISPATCHERS parameter defines the maximum number of connections against the database through a dispatcher. Configure the MTS_DISPATCHERS parameter to enable connection pooling. The MTS_DISPATCHERS attributes include POOL to enable connection pooling, CONNECTION to set the maximum number of network connections, and TICKS to specify the number of 10 second ticks.

139. You need to start more dispatcher processes. Which two limitations must you consider?

If the init.ora file starts dispatchers for a particular protocol(s), you cannot start dispatchers for a different protocol(s) unless you change the init.ora file and restart the database. New dispatchers may be started if their total number does not exceed the value specified by the MTS_MAX_DISPATCHERS parameter.

140. Which MTS parameter has an attribute that is used to specify the network name of an address of a Net8 listener that the dispatcher will register with?

The MTS_DISPATCHERS multithreaded server (MTS) parameter has an ADDRESS attribute used to specify the network name of an address of a Net8 listener that the dispatcher will register with.

141. You have set the init.ora MTS_DISPATCHERS parameter POOL attribute to 'TRUE'. What will be the result?

The connection pooling feature allows for the maximization of the number of physical network connections to a Multithreaded Server (MTS). To enable connection pooling, use the POOL attribute of the MTS_DISPATCHERS initialization parameter. When set to 'TRUE', connection pooling is enabled for both incoming and outgoing network connections.

142. You were trying to connect from a client directly to a server using local naming and received this error:

ORA-12545 TNS:name lookup failure

You have verified that the tnsnames.ora and listener.ora files contain the correct information. What might be the problem?

An Error ORA-12545 occurs when a listener on a remote node cannot be contacted. Verify that the tnsnames.ora and listener.ora files contain the correct address, and verify that the listener on the remote node has been started. Use the STATUS command in the Listener Control Utility to verify the status of the listener. If necessary, use the START command to start the listener.

143. What are the first steps when configuring database services using the Net8 Assistant?

The Net8 Assistant can be used to configure database services. To configure a database service with the Net8 Assistant, select the listener that the service is for, choose Database Services from the pull-down menu, and click the Add Database button. Enter the global database name, Oracle home directory, and the SID.

144. You are creating a listener using the Net8 Assistant and your protocol is TCP/IP. Which information is required when adding an address?

After entering the name of your new listener, you must provide address information. Although the fields vary for the different protocols, the protocol, host, and port are required for a TCP/IP configuration.

145. Which command is used to stop the default listener on a UNIX platform?

Once the Listener Control Utility is started, the command to stop the listener on all platforms is STOP listener_name. To stop the default listener, issue the STOP command without the listener_name argument.

146. Evaluate this command:

LSNRCTL> SHOW CURRENT_LISTENER

If multiple listeners are configured, what is the result of this command?

The Listener Control Utility (LSNRCTL) is used to control the listener. Use the SHOW command to list the value of a listener parameter. The SHOW CURRENT_LISTENER command shows the parameters when multiple listeners are used.

147. You want to add a service to your listener without shutting it down. Which LSNRCTL command will you use?

The RELOAD command shuts down everything but the listener addresses, allowing you to add or change services without actually stopping the listener. The SET command is used to set a listener parameter. The SERVICES command displays detailed information about the services the listener listens for.

148. Which command is used to start the default listener instantly?

The Listener Control Utility (LSNRCTL) is used to control the listener. Use the START command to start the listener from the Listener Control utility. The argument for the START command is the name of the listener. If no listener is specified, the current listener is started. If the current listener is not defined, LISTENER is started by default.

149. You are configuring a database service using the Net8 Assistant. Which information is required when adding a database?

Use the Net8 Assistant to configure database services. Select the Database Services from the pull-down menu. Click the Add Database button. Enter the global database name, Oracle home directory, and the SID.

150. You want to permanently save all changes made using the LSNRCTL SET command right before the listener exits. Which SET command will you use?

Any modifications you have made to the listener using the SET command will automatically become permanent if the SAVE_CONFIG_ON_STOP parameter is set to 'ON' when you stop the listener.

151. In which file must the maximum number of prespawned dedicated server processes be defined?

The maximum number of server processes can be defined using the PRESPAWN_MAX parameter in the listener configuration file. Once the value of PRESPAWN_MAX is reached, the listener stops spawning additional servers.

152. How can a listener(s) assist with the load balancing of a database server?

A listener is a process that listens for incoming connections for one or more databases. To achieve load balancing, multiple listeners can listen for a single database. This allows the client(s) to randomly choose between the active listeners that are sharing the connection request burden. A listener can listen on multiple protocols. LISTENER is the default name of the listener in Net8. The name of the listener must be unique on the machine on which it resides.

153. Which command is used to activate the listener using the Listener Control Utility?

The Listener Control Utility (LSNRCTL) is used to control the listener. Use the START command to start the listener from the Listener Control utility. The argument for the START command is the name of the listener. If no listener is specified, the current listener is started. If the current listener is not defined, LISTENER is started by default.

154. You received this message:

TNS-01169: The listener has not recognized the password

How can you correct the problem?

The Error TNS-01169 occurs when a password has been configured for the listener and you try to stop the listener without first issuing the SET PASSWORD command. You must issue the SET PASSWORD command before stopping the listener. The password command can only be issued from the LSNRCTL prompt.

155. You want to log the default listener. Which three listener.ora parameters should you set?

The listener.ora file is used to configure the listener. The LOG_DIRECTORY_listener_name parameter controls the directory in which the log file is written. The LOG_FILE_listener_name parameter specifies the filename to which the log information is written. The LOGGING_listener_name parameter enables or disables logging. The TRACE_FILE_listener_name parameter sets the name of the trace file. The TRACE_DIRECTORY_listener_name parameter controls the directory in which the trace files are written. The TRACE_LEVEL_listener_name parameter turns tracing off or to a specified level.

156. There are too many connection requests for your listener to handle causing the listener's backlog to overload. Which parameter should you reconfigure to eliminate the problem?

The QUEUESIZE parameter can be reconfigured in either the listener.ora or the names.ora files. Increasing the QUEUESIZE value in the listener.ora or names.ora files will increase the backlog size for the listener. The default value for the QUEUESIZE parameter is 17. This parameter is only valid for TCP/IP and DECnet protocols.

157. Which tool can you use to create and configure a listener?

Use the Net8 Assistant to create and configure listeners, configure database services, and configure listener logging and tracing.

158. You are preparing to stop the listener. What should you do first?

Once the Listener Control Utility is started, the command to stop the listener on all platforms is STOP listener_name. To stop the default listener, issue the STOP command without the listener_name argument. You need only warn potential network users out of courtesy. It is good practice to send a warning message to all network users before stopping a listener.

159. Which two commands close the LSNRCTL Utility?

Which two commands close the LSNRCTL Utility? (Choose two.)

160. A password has been configured and connections to the listener exist. How do you stop the listener?

If a password has been configured for your listener, it must be entered using the SET PASSWORD command at the LSNRCTL prompt prior to stopping the listener. This command does not reset the password, but acts as a login prompt for authentication purposes only.

161. What is used to set the password when stopping a listener?

The Listener Control Utility (LSNRCTL) is used to control the listener. If a password is configured, you must issue the SET PASSWORD command before stopping the listener. The password command can only be issued from the LSNRCTL prompt.

162. How do you create a listener using the Net8 Assistant?

Use the Net8 Assistant to create and configure listeners, configure database services, and configure listener logging and tracing. Create a listener by clicking the Listeners icon, selecting the Create option from the Edit menu, and entering a listener name in the Listener Name field.

163. Which listener.ora parameter turns tracing off or on to a specified level for the default listener?

The listener.ora file is used to configure the listener. The TRACE_LEVEL_listener_name parameter turns tracing off or to a specified level. The TRACE_FILE_listener_name parameter sets the name of the trace file. The TRACE_DIRECTORY_listener_name parameter controls the directory in which the trace files are written.

164. Which statement about bequeath sessions is true?

A listener responds to a connection request by either spawning a process and bequeathing (passing) the connection or by redirecting the connection to an existing process. The bequeath session method is used by default if the dedicated server does not have prespawned server processes. If a connection cannot pass between two different processes on the same machine, the bequeath method cannot be used. It is transparent to the user whether a bequeath session of a redirect session is used. Tracing can be used to determine which type of session is used.

165. How is logging activated for a particular listener using the Net8 Assistant?

Use the Net8 Assistant to create and configure listeners, configure database services, and configure listener logging and tracing. To enable logging for a particular listener, choose a listener and select General Parameters from the pull-down menu. Click the Logging & Tracing tab, and then click the Logging Enabled button. Enter the path and filename for the log file.

166. You issue this command:

LSNRCTL> START

What is the result?

The Listener Control Utility (LSNRCTL) is used to control the listener. Use the START command to start the listener from the Listener Control utility. The argument for the START command is the name of the listener. If no listener is specified, the current listener is started. If the current listener is not defined, LISTENER is started by default.

167. Why would you set the TRACE_DIRECTORY_LISTENER parameter in the listener.ora file?

The listener.ora file is used to configure the listener. The TRACE_LEVEL_listener_name parameter turns tracing off or to a specified level. The TRACE_FILE_listener_name parameter sets the name of the trace file. The TRACE_DIRECTORY_listener_name parameter controls the directory in which the trace files are written. LISTENER is name of the default listener.

168. Which statement about listeners is true?

A listener is a process that listens for incoming connections for one or more databases. To achieve load balancing, multiple listeners can listen for a single database. A listener can listen on multiple protocols. LISTENER is the default name of the listener in Net8. The name of the listener must be unique on the machine on which it resides.

169. What is the purpose of the LSNRCTL Utility SET PASSWORD command?

The SET PASSWORD command is issued in the Listener Control Utility which sends it to the listener process for authentication only. It acts as a login prompt where the user is required to enter the listener password. Prior to the use of this command, a password must exist in the listener.ora file for the PASSWORDS_<listener_name> configuration parameter.

170. Why would you use the LSNRCTL CHANGE_PASSWORD command?

Use the CHANGE_PASSWORD command to dynamically change the encrypted password of a listener. If a password is configured, you must use the SET PASSWORD command before the listener can be stopped.

171. How can you determine whether the listener spawned a new session or redirected the connection to an existing process?

A listener responds to a connection request by either spawning a process and bequeathing (passing) the connection or by redirecting the connection to an existing process. The bequeath session method is used by default if the dedicated server does not have prespawned server processes. If a connection cannot pass between two different processes on the same machine, the bequeath method cannot be used. It is transparent to the user whether a bequeath session or a redirect session is used. Tracing can be used to determine which type of session is used.

172. You are configuring database services using the Net8 Assistant, and you will be using prespawned servers. Which two pieces of information must be specified after clicking the Configure Prespawned Server button? (Choose two.)

Use the Net8 Assistant to configure database services. Select the Database Services from the pull-down menu. Click the Add Database button. Enter the global database name, Oracle home directory, and the SID. Select whether or not prespawned dedicated servers will be used. If prespawned servers are to be used, click the Configure Prespawned Servers button and set the number of prespawned servers and their timeout values for the supported protocols.

173. What does the listener do after receiving a connection request?

A listener responds to a connection request by either spawning a process and bequeathing (passing) the connection or by redirecting the connection to an existing process. The bequeath session method is used by default if the dedicated server does not have prespawned server processes.

174. Which command dynamically changes the encrypted password of a listener?

Use the CHANGE_PASSWORD command to dynamically change the encrypted password of a listener. If a password is configured, you must use the SET PASSWORD command before the listener can be stopped.

175. You are modifying an existing listener using the Net8 Assistant. How do you make your changes permanent?

Use the Net8 Assistant to create and configure listeners, configure database services, and configure listener logging and tracing. Any changes to the network configuration can be saved by selecting Save Network Configuration from the Net8 Assistant File menu.

176. You need to add a service to your listener without stopping the listener. You then want to update the current listener.ora file with your changes and make a backup of it. Which commands will you use to accomplish this?

The RELOAD command shuts down all but the address of the listener and rereads the listener.ora file. This allows you to add a service without stopping the listener. The SAVE_CONFIG command creates a backup and updates the listener.ora file with your changes.

177. In a multithreaded server, which process updates the listener with new load values?

For a multithreaded server, incoming sessions are redirected by the listener to the dispatcher process unless specified otherwise or if no dispatchers are available. After a request is processed, the listener redirects the client to the network address of the least-used dispatcher. The client disconnects from the listener and connects to the dispatcher address provided by the listener. The dispatcher updates the listener with the new load value.

178. After a connection has been started, the listener waits for a valid connection request for a specific amount of time. Which Listener Control utility SET command is used to specify the amount of time?

The SET CONNECT_TIMEOUT command can be issued from the Listener Control Utility to specify the amount of time the listener will wait for a valid connection request after a connection has been started.

179. Which listener.ora parameter would you set to specify the name of the trace file for the default listener?

The listener.ora file is used to configure the listener. The TRACE_FILE_listener_name parameter sets the name of the trace file. The TRACE_DIRECTORY_listener_name parameter controls the directory in which the trace files are written. The TRACE_LEVEL_listener_name parameter turns tracing off or to a specified level.

180. The listener.ora file contains a TCP address and port used to identify incoming TCP connection requests. Which file on the client defines the corresponding port?

The listener.ora file is used to configure the listener. The file must reside on the machine on which the listener resides. The client uses the address information in the tnsnames.ora file to connect to the listener. The address specifies a port, protocol, and machine address.

181. Which two statements about the listener log or trace files are true? (Choose two.)

Edit the LOG_DIRECTORY_listener_name parameter in the listener.ora file to specify the directory in which the log file is written. Execute the SET TRC_DIRECTORY command in the LSNRCTL utility to set a nondefault location for the trace file or to return the location to the default. Execute the SET LOG_DIRECTORY command in the LSNRCTL utility to set a nondefault location for the log file or to return the location to the default. The Net8 Assistant can be used to configure listener logging and tracing. Use the SET TRC_LEVEL command in the LSNRCTL utility to turn on tracing for the listener.

182. Which command do you enter to start the Listener Control Utility in an NT environment?

The Listener Control Utility (LSNRCTL) is used to control the listener. Start the Listener Control Utility for Oracle8i on a Windows NT system using the LSNRCTL command.
Re: Network OCP Questions! [message #102506 is a reply to message #102488] Sun, 30 June 2002 09:28 Go to previous messageGo to next message
Darling
Messages: 1
Registered: June 2002
Junior Member
Hello Darling!!!!

Thanks for your questions

Bye darling
Re: Network OCP Questions! [message #103010 is a reply to message #102488] Sat, 11 January 2003 13:58 Go to previous messageGo to next message
Dee
Messages: 11
Registered: September 1999
Junior Member
i have a questiion about ocp 026.
the question came out?
in which situation would u us namesini.sql
what is the ansewr?

when setting up a region database or when setting up the first names server of a region?
Re: Network OCP Questions! [message #103096 is a reply to message #102488] Sun, 02 February 2003 20:35 Go to previous messageGo to next message
Prince
Messages: 32
Registered: December 2001
Member
No Message Body
Re: Network OCP Questions! [message #103131 is a reply to message #102488] Thu, 13 February 2003 22:10 Go to previous messageGo to next message
sekhar
Messages: 18
Registered: March 2000
Junior Member
please send 1z0 131 ocp questions
Re: Network OCP Questions! [message #104295 is a reply to message #102488] Sun, 12 September 2004 06:02 Go to previous message
Balkrishna
Messages: 1
Registered: September 2004
Junior Member
Oracle networking questions and answers.

from http://www.orafaq.com/forum/t/38923/0/

[Updated on: Fri, 18 February 2005 23:32]

Report message to a moderator

Previous Topic: DBA OCA or PL/SQL Developer OCA ?
Next Topic: Oracle payroll/hr training and certification
Goto Forum:
  


Current Time: Sun May 31 19:01:47 CDT 2020