Java Database Connectivity Competency (Intermediate Level)

  • 20m
  • 20 questions
The Java Database Connectivity Competency (Intermediate Level) benchmark measures your ability to recognize the features of ResultSets and use JDBC to implement batch executions and transactions. You will be evaluated on your skills in implementing different forms of connected and disconnected RowSets and working with BLOB and CLOB data using JDBC. Learners who score high on this benchmark demonstrate that they have the skills to work with ResultSets, query batches, and RowSets and execute stored procedures in JDBC.

Topics covered

  • apply a Predicate instance to a FilteredRowSet to get it to include only data that fulfils the condition defined in the Predicate
  • combine the optimizations of batch executions and batch updates
  • describe how the auto-commit feature may prevent queries from running as a transaction
  • download image files from a SQL table into your file system
  • execute stored procedures that return values and retrieve the outputs generated
  • identify potential issues when trying to modify a read-only ResultSet
  • load large image files into a SQL table using JDBC
  • manipulate the contents of a CachedRowSet and push the updates to the underlying database table
  • perform a partial rollback by implementing Savepoints in a Java app
  • perform scrolling and navigation over the contents of a JdbcRowSet
  • recall how a WebRowSet records modifications to its contents
  • recognize the limitations of a TYPE_FORWARD_ONLY ResultSet
  • recognize the limitations of working with a disconnected RowSet such as a CachedRowSet
  • recognize the types of updates that can be performed on a FilteredRowSet
  • refresh the contents of a ResultSet while iterating over its contents
  • remove data from a SQL table by performing deletes from a ResultSet
  • scroll through a ResultSet to access data in various locations
  • update the contents of a SQL table through a JoinRowSet
  • use JDBC to run stored procedures that use the same parameter to process inputs and outputs
  • use JDBC to upload and download text data to and from a database