JDBC Quiz ( Beginner ) - All Questions

This beginner-level JDBC quiz is designed for learners starting with Java database connectivity. It covers JDBC fundamentals such as drivers, connections, statements, ResultSet, basic CRUD operations, and core concepts commonly asked in entry-level interviews.

Question 1: What does JDBC stand for?

Java Data Binding Connector
Java Database Connectivity
Java DataBase Controller
Java Driver Base Connection

Explanation: JDBC stands for Java Database Connectivity.

Question 2: What is JDBC used for?

Building UI
Connecting Java applications to databases
Compiling Java code
Managing JVM memory

Explanation: JDBC allows Java programs to interact with databases.

Question 3: Which package contains JDBC classes?

java.io
java.net
java.sql
javax.io

Explanation: JDBC classes are present in java.sql package.

Question 4: Which interface represents a database connection?

Statement
Connection
Driver
ResultSet

Explanation: Connection represents a database connection.

Question 5: Which method is used to establish a database connection?

openConnection()
getConnection()
connect()
createConnection()

Explanation: DriverManager.getConnection() establishes a connection.

Question 6: Which class manages JDBC drivers?

Driver
Connection
DriverManager
Statement

Explanation: DriverManager manages database drivers.

Question 7: Which interface is used to execute SQL queries?

Driver
ResultSet
Statement
Connection

Explanation: Statement executes SQL queries.

Question 8: Which method executes a SELECT query?

executeUpdate()
execute()
executeQuery()
runQuery()

Explanation: executeQuery() is used for SELECT queries.

Question 9: Which method executes INSERT, UPDATE, or DELETE queries?

execute()
executeQuery()
executeUpdate()
runUpdate()

Explanation: executeUpdate() handles DML operations.

Question 10: Which object holds the result of a SELECT query?

Statement
ResultSet
Connection
Driver

Explanation: ResultSet stores query results.

Question 11: Which method moves the cursor to the next row in ResultSet?

next()
previous()
move()
get()

Explanation: next() moves the cursor forward.

Question 12: Which interface represents a database driver?

Driver
Statement
Connection
ResultSet

Explanation: Driver interface represents database drivers.

Question 13: Which JDBC component sends SQL to the database?

DriverManager
Connection
Statement
ResultSet

Explanation: Statement sends SQL statements to DB.

Question 14: Which JDBC object is created using Connection?

Driver
Statement
DriverManager
ResultSet

Explanation: Statement is created from Connection.

Question 15: Which JDBC interface supports parameterized queries?

Statement
PreparedStatement
CallableStatement
ResultSet

Explanation: PreparedStatement supports parameters.

Question 16: Why is PreparedStatement preferred over Statement?

Faster compilation
Prevents SQL injection
Uses less memory
Supports only SELECT

Explanation: PreparedStatement prevents SQL injection.

Question 17: Which JDBC interface is used to call stored procedures?

Statement
PreparedStatement
CallableStatement
ResultSet

Explanation: CallableStatement calls stored procedures.

Question 18: Which method is used to close a JDBC connection?

end()
terminate()
close()
stop()

Explanation: close() releases database resources.

Question 19: Which JDBC feature improves performance by reusing queries?

Statement
PreparedStatement
ResultSet
DriverManager

Explanation: PreparedStatement allows query reuse.

Question 20: Which exception is commonly thrown in JDBC?

IOException
SQLException
ClassNotFoundException
RuntimeException

Explanation: SQLException handles database errors.

Question 21: Which JDBC driver type uses native database libraries?

Type 1
Type 2
Type 3
Type 4

Explanation: Type 2 uses native libraries.

Question 22: Which JDBC driver is pure Java and most commonly used?

Type 1
Type 2
Type 3
Type 4

Explanation: Type 4 is pure Java and widely used.

Question 23: Which driver type converts JDBC calls into DB-specific calls?

Type 1
Type 3
Type 4
Type 2

Explanation: Type 2 converts calls using native APIs.

Question 24: Which driver type uses a middleware server?

Type 1
Type 2
Type 3
Type 4

Explanation: Type 3 uses middleware.

Question 25: Which JDBC method executes any SQL statement?

execute()
executeQuery()
executeUpdate()
run()

Explanation: execute() can run any SQL.

Question 26: Which method retrieves column data from ResultSet?

fetch()
getString()
read()
value()

Explanation: getString() retrieves column data.

Question 27: Which indexing starts ResultSet column numbering?

0
1
-1
Depends on DB

Explanation: ResultSet indexing starts from 1.

Question 28: Which JDBC object maintains database session?

Driver
Connection
Statement
ResultSet

Explanation: Connection maintains DB session.

Question 29: Which JDBC feature ensures transaction control?

AutoCommit
ResultSet
Statement
Driver

Explanation: AutoCommit controls transactions.

Question 30: Which method commits a transaction?

save()
commit()
apply()
end()

Explanation: commit() saves transaction changes.

Question 31: Which method rolls back a transaction?

undo()
reset()
rollback()
cancel()

Explanation: rollback() undoes changes.

Question 32: What is default auto-commit mode in JDBC?

true
false
Depends on driver
Disabled

Explanation: Auto-commit is true by default.

Question 33: Which JDBC interface allows scrolling ResultSet?

TYPE_FORWARD_ONLY
TYPE_SCROLL_INSENSITIVE
TYPE_READ_ONLY
TYPE_SIMPLE

Explanation: Scrollable ResultSet allows cursor movement.

Question 34: Which ResultSet type moves only forward?

TYPE_SCROLL_INSENSITIVE
TYPE_SCROLL_SENSITIVE
TYPE_FORWARD_ONLY
TYPE_READ_ONLY

Explanation: TYPE_FORWARD_ONLY moves forward.

Question 35: Which JDBC feature improves security?

Statement
PreparedStatement
ResultSet
DriverManager

Explanation: PreparedStatement prevents SQL injection.

Question 36: Which JDBC object should be closed first?

Connection
ResultSet
Statement
DriverManager

Explanation: ResultSet should be closed first.

Question 37: Which JDBC API supports batch processing?

Statement
PreparedStatement
Both A and B
ResultSet

Explanation: Both Statement and PreparedStatement support batch.

Question 38: Which method adds queries to batch?

addBatch()
addQuery()
batch()
queue()

Explanation: addBatch() adds SQL to batch.

Question 39: Which method executes batch statements?

runBatch()
execute()
executeBatch()
commitBatch()

Explanation: executeBatch() runs batch queries.

Question 40: Which JDBC feature reduces network calls?

Transactions
Batch processing
Indexes
Joins

Explanation: Batch processing reduces DB calls.

Question 41: Which method sets auto-commit mode?

setCommit()
setAutoCommit()
autoCommit()
commitMode()

Explanation: setAutoCommit() controls commit mode.

Question 42: Which JDBC interface supports metadata?

DatabaseMetaData
ResultSetMetaData
Both A and B
Statement

Explanation: Both metadata interfaces provide DB info.

Question 43: Which metadata provides table structure info?

DatabaseMetaData
ResultSetMetaData
Statement
Driver

Explanation: ResultSetMetaData provides column info.

Question 44: Which JDBC object represents SQL warnings?

SQLException
SQLWarning
Error
Exception

Explanation: SQLWarning represents non-fatal warnings.

Question 45: Which interface allows retrieving generated keys?

Statement
PreparedStatement
Connection
ResultSet

Explanation: Statement can retrieve generated keys.

Question 46: Which JDBC class loads drivers dynamically?

Driver
Class
DriverManager
Connection

Explanation: Class.forName() loads drivers.

Question 47: Which method loads JDBC driver?

Driver.load()
Class.forName()
DriverManager.load()
connect()

Explanation: Class.forName() loads JDBC drivers.

Question 48: Which JDBC feature improves application performance most?

Statements
PreparedStatements
ResultSet
Connections

Explanation: PreparedStatements improve performance.

Question 49: What is the main goal of JDBC?

Database creation
Java-database interaction
Query optimization
Transaction management

Explanation: JDBC connects Java with databases.

Back to programming Quizzes

JDBC Quiz ( Beginner )

Questions

~15

Minutes

Min Limit