JAVA PROGRAMMING USING JDBC
This test is designed for Java developers to test their understanding and proficiency in the use of Java
JDBC (Java Database Connectivity) technology to establish communication between a Java application
and a relational database.
The Secure Evaluation Mode and Remote versions of this test will contain a
minimum of 39 questions and will require a typical time of 46 minutes.
The Secure Interview Mode and
QwikChek versionswill provide as many questions as the test taker can answer within an approximate 29
minute time limit.
The CoreChek version will contain 27 questions and will require a typical time of 32
Following is a description of each sub-topic on the test:
Connecting to Databases using JDBC determines the level of expertise in using JDBC resources from
traditional Java applications, J2EE applications, and Java applets. Core
Managing Transactions using JDBC checks knowledge of transaction management in Java applications.
Distributed Transactions using JDBC and JTA evaluates ability to manage transactions in distributed
application environments such as J2EE using JDBC and the Java Transaction API (JTA). Core
Retrieving Data from the Database Using JDBC tests skills and expertise in using JDBC data retrieval
Updating Data in the Database using JDBC tests skills and expertise in using JDBC data updating
Optimizing Database Access and Update using JDBC assesses the ability to develop efficient JDBC
Using Stored Procedures checks ability to develop applications that use Statement, PreparedStatement
and CallableStatement to access stored procedures. Core
Building Database Independent Applications tests ability to develop applications that can run robustly
with any database management system.
DataSource Objects to Manage Database Connections evaluates knowledge of JDBC DataSource for use in
managing database connections. Core
Using SQL5 with JDBC assesses knowledge and expertise in using the SQL5 support defined in the JDBC
SQL Statements tests expertise in manipulating relational data with SQL using the JDBC API. Core
Using Resultsets and Rowsets evaluates knowledge and experience with using the JDBC ResultSet and
RowSet objects. Core
Writing JDBC Drivers tests ability to implement the APIs defined in java.sql and javax.sql. Core