OCA-12-Uderstanding Oracle Network Architecture

Jamonero Blanco
Quiz by Jamonero Blanco, updated more than 1 year ago
Jamonero Blanco
Created by Jamonero Blanco almost 4 years ago
28
2

Description

OCA OCA Quiz on OCA-12-Uderstanding Oracle Network Architecture, created by Jamonero Blanco on 01/30/2017.
Tags

Resource summary

Question 1

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

Question 2

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

Question 3

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

Question 4

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

Question 5

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

Question 6

Question
6. Which statements regarding Database Resident Connection Pooling (DRCP) are true? (Choose two.)
Answer
  • 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.

Question 7

Question
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.
Answer
  • 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.

Question 8

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

Question 9

Question
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.)
Answer
  • 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

Question 10

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

Question 11

Question
11. Which of the following is true about Shared Server?
Answer
  • 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.

Question 12

Question
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?
Answer
  • A. (SERVER=DEDICATED)
  • B. (CONNECT=DEDICATED)
  • C. (INSTANCE=DEDICATED)
  • D. (MULTITHREADED=FALSE)
  • E. None of the above

Question 13

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

Question 14

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

Question 15

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

Question 16

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

Question 17

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

Question 18

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

Question 19

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

Question 20

Question
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.
Answer
  • 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.
Show full summary Hide full summary

Similar

Ciencia Abierta en la UNC
Mario Pizzi
ROUND & TRUNC [DATES]
Adrian Mora
Prueba de Aptitud Académica - Lenguaje
Teresa Nadal
FREQUENCY TABLES: MODE, MEDIAN AND MEAN
Elliot O'Leary
HISTOGRAMS
Elliot O'Leary
RESOLUCIÓN 2626
Maria Jose Lozano
SISTEMAS Y RELACIONES
cecy menchaca
mi mapa conceptual
Manuela Gomez
Enfermedades cerebrales
EDUARDO JOSELO BARRAGAN VERDEZOTO
Conceptos Generales De Robótica
Debora Chavarria
LEY ORGÁNICA DE LA CULTURA
Genesis Quishpe