Copiar y Editar

OCA-12-Uderstanding Oracle Network Architecture

Descripción

OCA OCA Test sobre OCA-12-Uderstanding Oracle Network Architecture, creado por Jamonero Blanco el 30/01/2017.
Jamonero Blanco
Test por Jamonero Blanco, actualizado hace más de 1 año
Jamonero Blanco
Creado por Jamonero Blanco hace más de 7 años
64
2
0

Resumen del Recurso

Pregunta 1

Pregunta
1. Which of the following files must be present on the Oracle server to start a nondefault Oracle listener?
Respuesta
  • A. listener.ora
  • B. lsnrctl.ora
  • C. sqlnet.ora
  • D. tnsnames.ora

Pregunta 2

Pregunta
2. Which of the following is the correct way to start a listener called LISTENER ?
Respuesta
  • A. lsnrctl startup listener
  • B. lsnrctl start
  • C. netca start
  • D. netmgr start listener

Pregunta 3

Pregunta
3. 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?
Respuesta
  • A. sqlnet.ora
  • B. tnsnames.ora
  • C. listener.ora
  • D. None of the above

Pregunta 4

Pregunta
4. Connection Manager provides which of the following?
Respuesta
  • A. Multiplexing
  • B. Cross-protocol connectivity
  • C. Network access control
  • D. All of the above

Pregunta 5

Pregunta
5. Which is a requirement for using host naming?
Respuesta
  • 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.

Pregunta 6

Pregunta
6. Which statements regarding Database Resident Connection Pooling (DRCP) are true? (Choose two.)
Respuesta
  • A. When a DRCP pooled server connection is made by an application, it is equivalent to a dedicated server connection.
  • B. When a database has DRCP enabled, all connections default to a pooled connec- tion unless DEDICATED server is explicitly specified in the connect string.
  • C. When an application using the DRCP connection disconnects, the server connec- tion (process) is handed off to the broker.
  • D. When using the Oracle Net Easy Connect method, it is not possible to utilize DRCP.

Pregunta 7

Pregunta
7. 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.
Respuesta
  • 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 mis- spelled in the tnsnames.ora file on the client file.
  • D. The listener is not configured to listen for this service.

Pregunta 8

Pregunta
8. What portion of the tnsnames.ora file specifies the name or IP address of the server where the listener process is listening?
Respuesta
  • A. CONNECT_DATA
  • B. SERVER
  • C. SERVICE_NAME
  • D. HOST

Pregunta 9

Pregunta
9. A client wants to connect to the database service dbprod.com located on the dbprod.com server through a nondefault port (1522) using Oracle Easy Connect. Which of the fol- lowing connect strings are the choices for the client to use? (Choose two.)
Respuesta
  • A. CONNECT scott/tiger@dbprod.com:1522
  • B. CONNECT scott/tiger@1522:dbprod.com/dbprod.com
  • C. CONNECT scott/tiger@//dbprod.com/1522:dbprod.com
  • D. CONNECT scott/tiger@dbprod.com:1522/dbprod.com

Pregunta 10

Pregunta
10. All of the following are reasons to configure the server using Shared Server except which one?
Respuesta
  • 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.

Pregunta 11

Pregunta
11. Which of the following is true about Shared Server?
Respuesta
  • A. Dedicated connections cannot be made when Shared Server is configured.
  • B. It is recommended that DSS type batch jobs 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.

Pregunta 12

Pregunta
12. 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 options accomplishes this?
Respuesta
  • A. (SERVER=DEDICATED)
  • B. (CONNECT=DEDICATED)
  • C. (INSTANCE=DEDICATED)
  • D. (MULTITHREADED=FALSE)
  • E. None of the above

Pregunta 13

Pregunta
13. In which of the following files would you find the Shared Server configuration parameters?
Respuesta
  • A. listener.ora
  • B. mts.ora
  • C. init.ora
  • D. tnsnames.ora
  • E. sqlnet.ora

Pregunta 14

Pregunta
14. What is the first step that the dispatcher performs after it receives a request from the user?
Respuesta
  • 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.

Pregunta 15

Pregunta
15. When configured in Shared Server mode, which of the following is contained in the PGA?
Respuesta
  • A. Cursor state
  • B. Sort information
  • C. User session data
  • D. Stack space
  • E. None of the above

Pregunta 16

Pregunta
16. Which of the following is false about request queues?
Respuesta
  • 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.

Pregunta 17

Pregunta
17. What is the process that notifies the listener after a database connection is established?
Respuesta
  • A. SMON
  • B. PMON
  • C. LREG
  • D. LGWR

Pregunta 18

Pregunta
18. Which network architecture connection uses session memory from the SGA?
Respuesta
  • A. Dedicated Server
  • B. Shared Server
  • C. Database Resident Connection Pooling
  • D. All of the above

Pregunta 19

Pregunta
19. Communication between two Oracle databases is configured using:
Respuesta
  • A. Database Resident Connection Pooling
  • B. Database link
  • C. Connection Manager
  • D. Oracle Net Manager

Pregunta 20

Pregunta
20. DBA user MIKE ran the SQL statement CREATE DATABASE LINK SCOTT.SALES_LINK .BJS.COM CONNECT TO SALES_INT IDENTIFIED BY SALESPWD1 USING 'ocasvr:1522/ ocadb' . Choose the option that is true.
Respuesta
  • A. Use of 'ocasvr:1522/ocadb' is invalid in database link definition.
  • B. A private database link is created under user MIKE.
  • C. A private database link is created under user SCOTT.
  • D. If the SALES_INT user does not exist or its password is not SALESPWD1 , the database link will not be created.
Mostrar resumen completo Ocultar resumen completo

¿Quieres crear tus propios Tests gratis con GoConqr? Más información.

Similar

Ciencia Abierta en la UNC
Mario Pizzi
ROUND & TRUNC [DATES]
Adrian Mora
Listenings para el FCE
Diego Santos
Dinamica de Grupos
Monica Espinoza
Etapas de la Historia de España
Alba B
Introducción a la Anatomia
Brayan Heriberto Rodriguez Guzman
¿CUÁNTOS INSTRUMENTOS CONOCES?
Estrella Roba Rodríguez
Ley Orgánica de la Administración Pública Federal.
Miguel Guizar
Prehistoria de la humanidad.
Katherine Forero
Introducción a los Derechos Humanos
Fernanda Tellechea
Unidad III - Dibujo de Conjunto
Mariana Cardozo
Explorar la Librería