Q. The general purpose of the Data Access Object (DAO) pattern is to avoid these logic related problems by separating data access logic from business logic and presentation logic.

View solution

Q. To access the database with JDBC:-

View solution

Q. Standard interface defined by the JDBC specification that factories Connection instances.

View solution

Q. Data source implementations provided by different vendors and projects.

View solution

Q. Spring also provides several convenient but less powerful data source implementations.

View solution

Q. SingleConnectionDataSource (a DriverManagerDataSource subclass). As its name indicates, this maintains only a single connection.

View solution

Q. Which DataSource is not stable in MultiThreaded Environment?

View solution

Q. Class which declares a number of overloaded update() template methods to control the overall update process.

View solution

Q. You implement this interface to override the statement creation task.

View solution

Q. When implementing the PreparedStatementCreator interface, you will get the database connection as the createPreparedStatement() method’s argument.

View solution

Q. It is better to implement the PreparedStatementCreator interface and other callback interfaces as inner classes if they are used within one method only.

View solution

Q. PreparedStatementSetter, as its name indicates, create a PreparedStatement object on this connection the parameter as well as binding task of the overall update process.

View solution

Q. The JdbcTemplate class offers template method for batch update operations.

View solution

Q. The primary interface that allows you to process the current row of the result set.

View solution

Q. RowCallbackHandler purpose is to map a single row of the result set to a customized object.

View solution

Q. Method of RowMapper interface in which, you have to construct the object that represents a row and return it as the method’s return value.

View solution

Q. RowMapper implementation which can automatically map a row to a new instance of the specified class.

View solution

Q. Method which provides list of maps.

View solution

Q. Spring JDBC framework offers a convenient class, to simplify your DAO implementation.

View solution

Q. The org.springframework.jdbc.core.support.JdbcDaoSupport class has a setDataSource() method and a setJdbcTemplate() method.

View solution