JDBC - Basic

Print the objectives

Take the exam   Take a beta test

This exam is based on the ability to write basic JDBC code. It includes the basic Java objects used in JDBC. SQL and database concepts are out of scope since they are tested in a separate exam.
  Released  Beta  Frozen  

General  2 questions

  • Know what JDBC stands for and what its purpose is
  • Identify the differences between the four driver types
  • Differentiate between the vendor neutral API and the vendor implementation
 14 135 52
Add a question
Beta questions
 

Connection  2 questions

  • Use and differentiate between DriverManager and DataSource
  • Write JDBC code involving a Connection
 18 11 42
Add a question
Beta questions
 

Statement

  
 

Types of Statements  1 question

State the differences between:
  • Statement
  • PreparedStatement
  • CallableStatement
 12 54 21
Add a question
Beta questions
 

Statement uses  3 questions

Write code that sets parameters and uses:
  • Statement
  • PreparedStatement
  • CallableStatement
 33 7 46
Add a question
Beta questions
 

ResultSet  3 questions

Write code that:
  • uses the different ways of retrieving data from a ResultSet
  • handles nulls
 35 22 49
Add a question
Beta questions
 

Misc  3 questions

  • Understand how autocommit works (good understanding of transactions is out of scope).
  • Close resources appropriately.
  • Understand the purpose of SQLExceptions including how to access the error codes and SQL states.
  • Be aware of common JDBC errors such as having multiple result sets open within a statement at the same time
 15 0 42
Add a question
Beta questions
 

Exam information

  • 18 minutes
  • 14 questions (608)
  • 80% required
  • +3 √
  • - 4  points
  • 15 day delay
  • status: released

Controls

Top contributors