Question 3
You are troubleshooting an issue with a WLS data source. However, your attempt to execute a manual test on the connection pool fails when you invoke the testPool() method on the corresponding JDBCDataSourceRuntimeMBean.
Which configuration condition would contribute to the failure of executing the test? (Choose the best answer.)
The TestTableName property is either not set or is set to an invalid SQL statement.
The TestFrequencySeconds property is set to a value greater than 0.
The TestReservedConnections property is enabled.
The ManualTestEnabled property is set to false.
The ConnectionReserveTimeoutSeconds property is set to a value other than -1.
Correct answer: A
Explanation:
testPool tests the connection pool in the data source by reserving and releasing a connection from it. TestTableName is the name of the database table to use when testing physical database connections. This name is required when you specify a Test Frequency and enable Test Reserved Connections, Test Created Connections, and Test Released Connections. Reference: http://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/core/index.html
testPool tests the connection pool in the data source by reserving and releasing a connection from it.
TestTableName is the name of the database table to use when testing physical database connections. This name is required when you specify a Test Frequency and enable Test Reserved Connections, Test Created Connections, and Test Released Connections.
Reference: http://docs.oracle.com/cd/E13222_01/wls/docs100/wlsmbeanref/core/index.html