Hi
this is my
braindump on Jan
test
Most questions are from here
I just mention some !
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
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 (*)
work protocol
d
client host (platform)
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
How can the DBA change the location of the listener log file
edit the listerner
ora
set log_directory
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
tricky questions ( I don
t remember the detail)
( I don
t know the answer)
How many processes are present in request queue in MTS
(a)
system
(b)
database
(c)
listener
(d)
dispatcher
I choose d (Note: this is a request queue)
How many processes are present in response queue in MTS
(a)
system
(b)
database
(c)
listener
(d)
dispatcher
I choose d (note: This is a response queue)
Hope to be helpful to u
linray
我這樣選擇
題 好象沒有v$listener視圖
題我選B
From:http://tw.wingwit.com/Article/program/Oracle/201311/16910.html
