Hi, this is my 026 braindump on Jan 22' test.
Most questions are from here.
I just mention some !
1.What does the CONNECTION attribute specify when enabling connection pooling ?
a.maximum number of network connections for each dispatcher (*)
b.average number of network connections for each dispatcher.
c.maximum number of network connections for each shared server
d.average number of network connections for each shared server
2.The listener audit trail provides information about every client connection request.
Which additional information about the client is NOT provided ?
a.client user ID
b.database username (*)
c.network protocol
d.client host (platform)
3.How can the DBA determine the location of the listener log file
View the init.ora
Issues the SHOW LISTENER command
Issues the SHOW LOG_DIRECTORY command
Query the v$listener
4..How can the DBA change the location of the listener log file
-- edit the listerner.ora
---set log_directory
5. .What are two advantages when using the host naming method? (Choose two.)
A. No configuration is required.
B. Oracle Connection Manager is supported.
C. It resolves service names across networks running different networks.
D. It eliminates the need to understand Oracle Names administration procedures. (*)
E. It eliminates the need to create and maintain a local names configuration file. (*)
There are 2 tricky questions ( I don’t remember the detail)
( I don't know the answer)
6. How many processes are present in request queue in MTS
(a) 1 system
(b) 1 database
(c) 1 listener
(d) 1 dispatcher
I choose d (Note: this is a request queue)
7. How many processes are present in response queue in MTS
(a) 1 system
(b) 1 database
(c) 1 listener
(d) 1 dispatcher
I choose d (note: This is a response queue)
Hope to be helpful to u
linray
我这样选择
3题 好象没有v$listener视图。
6题我选B
