Reading...
Play button
Play button
Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
20 Cards in this Set
- Front
- Back
|
1. All of the following are examples of networking architectures except which one?
A. Client/server. B. n-tier. C. Single-tier. D. Two-tier. E. All the above are examples of network architectures. |
1. E. All these are examples of network connectivity configurations. Networking can be as simple as a dumb terminal connected directly to a server
via a serial connection. It can also be as complex as an n-tier architecture that involves clients, middleware, the Internet, and database servers. |
|
|
2. Which of the following files must be present on the Oracle server to start a nondefault Oracle listener?
A. listener.ora B. lsnrctl.ora C. sqlnet.ora D. tnsnames.ora |
2. A. The listener is the process that manages incoming connection requests. The listener.ora file is used to configure the listener and must be configured to start a nondefault listener. The sqlnet.ora file is an optional client- and server-side file. The tnsnames.ora file is used for doing local naming resolution. There is no such file as lsnrctl.ora. You do not need the listener.ora file to start a default listener on port 1521.
|
|
|
3. Which of the following is the correct way to start a listener called LISTENER?
A.lsnrctl startup listener B.lsnrctl start C.listener start D.listener start listener |
3. B. Because the default listener name is LISTENER, simply enter lsnrctl start. The name LISTENER is assumed to be the listener to start in this case.
|
|
|
4. When dynamic service registration is used, you will not see the service listed in which of the following files where it would normally be located?
A. sqlnet.ora B. tnsnames.ora C. listener.ora D. None of the above |
4. C. When services are dynamically registered with the listener, their information is not present in the listener.ora file.
|
|
|
5. What are the ways in which a client can resolve a net service name? (Choose all that apply.)
A. Local naming B. Host naming C. Easy Connect D. Oracle Global Naming E. All the above |
5. A, B, C. Oracle uses service names in networks in much the same way it uses synonyms in the database. Service names provide location transparency and hide the
complexity of connect string information. You can configure Oracle Net to connect in several ways, including host naming, local naming, OID, and Oracle Easy Connect. Oracle Global Naming is not a valid Oracle option. |
|
|
6. Connection Manager provides which of the following?
A. Multiplexing B. Cross-protocol connectivity C. Network access control D. All the above |
6. D. Connection Manager is a middleware solution that provides for the multiplexing of connections, cross-protocol connectivity, and network access control. All the answers describe Connection Manager.
|
|
|
7. Which is a requirement for using host naming?
A. You must use tnsnames.ora on the client. B. You must be using TCP/IP. C. You must have an OID present. D. You must have a sqlnet.ora file present on the client. E. None of the above. |
7. B. Host naming is typically used in small installations that have few Oracle Databases. This is an attractive option when you want to minimize client-side configuration. TCP/IP is a requirement when you use host naming.
|
|
|
8. Which of the following statements about tnsnames.ora is false?
A. It is used to resolve an Oracle service name. B. It can exist on the client. C. It is used for local naming. D. It does not support TCP/IP. |
8. D. A tnsnames.ora file is configured when you want to use local naming, and it typically exists on the client workstation. It is also used to resolve a service name. The tnsnames.ora file used in local naming does indeed support TCP/IP.
|
|
|
9. A client receives the following error message:
"ORA-12154 TNS:could not resolve the connect identifier specified" Which of the following could be possible causes of the error? (Choose all that apply.) A. The listener is not running on the Oracle server. B. The user entered an invalid net service name. C. The user supplied the correct net service name, but the net service name is misspelled in the tnsnames.ora on the client file. D. The listener is not configured to listen for this service. |
9. B, C. Supplying a net service name that is not contained in the tnsnames.ora file can cause this error. Problems with the tnsnames.ora file can cause this error too. Listener problems will not cause this error.
|
|
|
10. What portion of the tnsnames.ora file specifies the name or IP address of the server where the listener process is listening?
A. CONNECT_DATA B. PORT C. SERVICE_NAME D. HOST |
10. D. The HOST portion specifies the name of the server to contact. CONNECT_DATA specifies the database service to connect to. The PORT portion specifies the location where the listener is listening on the HOST. Option C, SERVICE_NAME, is the name of the actual database service.
|
|
|
11. A client wants to connect to the database dbprod.com located on the dbprod.com server to a nondefault port using Oracle Easy Connect. Which of the following connect strings is the best choice for the client use?
A.CONNECT scott/tiger@dbprod.com:1522 B.CONNECT scott/tiger@1521:dbprod.com/dbprod.com C.CONNECT scott/tiger@dbprod.com/1522:dbprod.com D.CONNECT scott/tiger@dbprod.com:1521/dbprod.com E.CONNECT scott/tiger@dbprod.com:1522/dbprod.com |
11. A. The correct syntax to use with the Oracle Easy Connect method when you are connecting to a non-URL location is connect username/password@host:port/service_name. If the service name and the host are identical, you do not have to include the service name. If the port is any port other than the default port of 1521, it
must be specified. Because you want to connect to a nondefault port where the database name and the hostname are the same, the best answer is A. |
|
|
12. All the following are reasons to configure the server using Shared Server except which one?
A. Overall memory utilization is reduced. B. The system is predominantly used for decision support with large result sets returned. C. The system is predominantly used for small transactions with many users. D. The number of idle connections on the server is reduced. |
12. B. Shared Server is a scalability option of Oracle. It provides a way to increase the number of supported user processes while reducing the overall memory usage. This configuration is well suited to high-volume, small-transaction–oriented systems with many users connected. Because users share processes, the number of overall idle processes is also reduced. It is not well suited for large data retrieval type applications such as decision support.
|
|
|
13. Which of the following is true about Shared Server?
A. Dedicated connections cannot be made when Shared Server is configured. B. It is recommended that index rebuilds be performed when connected via Shared Server. C. The database can be started when connected via Shared Server. D. The database cannot be stopped when connected via Shared Server. |
13. D. Users can still request dedicated connections in a Shared Server configuration. Bequeath and dedicated connections are one and the same. The database cannot be stopped or started by the DBA when connected over a Shared Server connection.
|
|
|
14. The administrator wants to allow a user to connect via a dedicated connection into a database configured in Shared Server mode. Which of the following lines accomplishes this?
A. (SERVER=DEDICATED) B. (CONNECT=DEDICATED) C. (INSTANCE=DEDICATED) D. (MULTITHREADED=FALSE) E. None of the above |
14. A. A user must explicitly request a dedicated connection when a server is configured in Shared Server mode. Otherwise, the user gets a Shared Server connection. The correct parameter is (SERVER=DEDICATED).
|
|
|
15. In which of the following files would you find the Shared Server configuration parameters?
A. listener.ora B. mts.ora C. init.ora D. tnsnames.ora E. sqlnet.ora |
15. C. The Shared Server configuration parameters exist in the init.ora or the SPFILE file on the Oracle Server machine.
|
|
|
16. What is the first step that the dispatcher performs after it receives a request from the user?
A. Pass the request to a shared server. B. Place the request in a request queue in the PGA. C. Place the request in a request queue in the SGA. D. Process the request. |
16. C. Once a dispatcher receives a request from the user process, it places the request on the request queue. Remember that in a Shared Server
environment, a request can be handled by a shared server process. This is made possible by placing the request and user information in the SGA. |
|
|
17. When configured in Shared Server mode, which of the following is contained in the PGA?
A. Cursor state B. Sort information C. User session data D. Stack space E. None of the above |
17. D. A small PGA is maintained even though most of the user-specific information is moved to the SGA (specifically called the UGA in the shared pool or the large pool). The only information left in the reduced PGA is stack space.
|
|
|
18. Which of the following is false about request queues?
A. They reside in the SGA. B. They are shared by all the dispatchers. C. Each dispatcher has its own request queue. D. The shared server processes remove requests from the request queue. |
18. C. Request queues reside in the SGA, and there is one request queue per instance. This is where shared server processes pick up requests that are made by users. Dispatchers have their own response queues, but they share a single request queue.
|
|
|
19. What is the process that notifies the listener after a database connection is established?
A.SMON B. DBWR C. PMON D. LGWR |
19. C. The PMON process notifies the listener after a client connection is established. This is so that the listener can keep track of the number of connections being serviced by each dispatcher.
|
|
|
20. Which command can you execute to get details about the number of sessions connected via Shared Server?
A. lsnrctl sessions B. lsnrctl conn C. lsnrctl status D. lsnrctl services E. None of the above |
20. D. Dispatchers register with listeners so that when a listener redirects a connection to a dispatcher, the listener knows how many active connections the dispatcher is serving. The lsnrctl services command summarizes the number of connections established, connections currently active, and other valuable information regarding Shared Server. The lsnrctl status command summarizes only dispatchers and does not display any details about connections.
|
