7493472
Beschreibung
Quiz von Jamonero Blanco, aktualisiert more than 1 year ago
|
Erstellt von Jamonero Blanco
vor fast 8 Jahre
|
|
Frage 1
Frage
1. Which of the following files must be present on the Oracle server to start a nondefault
Oracle listener?
Antworten
-
A. listener.ora
-
B. lsnrctl.ora
-
C. sqlnet.ora
-
D. tnsnames.ora
Frage 2
Frage
2. Which of the following is the correct way to start a listener called LISTENER ?
Antworten
-
A. lsnrctl startup listener
-
B. lsnrctl start
-
C. netca start
-
D. netmgr start listener
Frage 3
Frage
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?
Antworten
-
A. sqlnet.ora
-
B. tnsnames.ora
-
C. listener.ora
-
D. None of the above
Frage 4
Frage
4. Connection Manager provides which of the following?
Antworten
-
A. Multiplexing
-
B. Cross-protocol connectivity
-
C. Network access control
-
D. All of the above
Frage 5
Frage
5. Which is a requirement for using host naming?
Antworten
-
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.
Frage 6
Frage
6. Which statements regarding Database Resident Connection Pooling (DRCP) are true?
(Choose two.)
Antworten
-
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.
Frage 7
Frage
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.
Antworten
-
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.
Frage 8
Frage
8. What portion of the tnsnames.ora file specifies the name or IP address of the server
where the listener process is listening?
Antworten
-
A. CONNECT_DATA
-
B. SERVER
-
C. SERVICE_NAME
-
D. HOST
Frage 9
Frage
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.)
Antworten
-
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
Frage 10
Frage
10. All of the following are reasons to configure the server using Shared Server except
which one?
Antworten
-
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.
Frage 11
Frage
11. Which of the following is true about Shared Server?
Antworten
-
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.
Frage 12
Frage
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?
Antworten
-
A. (SERVER=DEDICATED)
-
B. (CONNECT=DEDICATED)
-
C. (INSTANCE=DEDICATED)
-
D. (MULTITHREADED=FALSE)
-
E. None of the above
Frage 13
Frage
13. In which of the following files would you find the Shared Server configuration
parameters?
Antworten
-
A. listener.ora
-
B. mts.ora
-
C. init.ora
-
D. tnsnames.ora
-
E. sqlnet.ora
Frage 14
Frage
14. What is the first step that the dispatcher performs after it receives a request from the user?
Antworten
-
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.
Frage 15
Frage
15. When configured in Shared Server mode, which of the following is contained in the PGA?
Antworten
-
A. Cursor state
-
B. Sort information
-
C. User session data
-
D. Stack space
-
E. None of the above
Frage 16
Frage
16. Which of the following is false about request queues?
Antworten
-
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.
Frage 17
Frage
17. What is the process that notifies the listener after a database connection is established?
Antworten
-
A. SMON
-
B. PMON
-
C. LREG
-
D. LGWR
Frage 18
Frage
18. Which network architecture connection uses session memory from the SGA?
Antworten
-
A. Dedicated Server
-
B. Shared Server
-
C. Database Resident Connection Pooling
-
D. All of the above
Frage 19
Frage
19. Communication between two Oracle databases is configured using:
Antworten
-
A. Database Resident Connection Pooling
-
B. Database link
-
C. Connection Manager
-
D. Oracle Net Manager
Frage 20
Frage
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.
Antworten
-
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.
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.