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 ? amaximum number of network connections for each dispatcher (*) baverage number of network connections for each dispatcher cmaximum number of network connections for each shared server daverage 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 ? aclient user ID bdatabase username (*) work protocol dclient host (platform) How can the DBA determine the location of the listener log file View the initora 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 listernerora 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 dont remember the detail) ( I dont 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 |