Copy and Edit

OCA-12-Uderstanding Oracle Network Architecture

Description

OCA OCA Quiz on OCA-12-Uderstanding Oracle Network Architecture, created by Jamonero Blanco on 30/01/2017.
Jamonero Blanco
Quiz by Jamonero Blanco, updated more than 1 year ago
Jamonero Blanco
Created by Jamonero Blanco about 7 years ago
63
2
0

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

Want to create your own Quizzes for free with GoConqr? Learn more.

Similar

Ciencia Abierta en la UNC
Mario Pizzi
ROUND & TRUNC [DATES]
Adrian Mora
British Empire
chloeeatsalot
Women in Nazi Germany - Flashcards
Louisa Wania
Meriya Pinales & Malika Hurt
hurtmalika
National 5 English - Close reading question types
VEJackson
Structure of the League of Nations
saskiamitchell.19
Chemistry Rates of Reaction Revision
11mzroser
Animal Farm CONTEXT
Lydia Richards2113
OCR A-Level Computer Science from 2015 - Chapter 8 (Applications Generation)
Tyrone Muriithi
Diseño de Software
Verny Fernandez
Browse Library