MCQs on Java Database Connectivity (JDBC) | Java Database Integration
Discover Java Database Connectivity (JDBC) through this comprehensive set of 30 MCQs. Perfect for developers looking to enhance their database integration skills, this collection covers JDBC basics, drivers, connections, SQL queries, prepared statements, and batch processing techniques.
MCQs
1-10: Introduction to JDBC
- What does JDBC stand for in Java?
- A) Java Database Communication
- B) Java Data Connector
- C) Java Database Connectivity
- D) Java Database Class
- Which of the following is a major purpose of JDBC?
- A) To connect Java applications to various databases
- B) To enhance Java user interfaces
- C) To speed up Java applications
- D) To manage memory in Java applications
- What is the first step to establish a connection to a database in JDBC?
- A) Load the JDBC driver
- B) Execute an SQL query
- C) Close the connection
- D) Set the database credentials
- Which of the following methods is used to create a database connection in JDBC?
- A)
DriverManager.getConnection() - B)
Connection.openConnection() - C)
JDBC.connect() - D)
Database.connect()
- A)
- Which class is used to manage the database connection in JDBC?
- A)
Statement - B)
Connection - C)
Driver - D)
ResultSet
- A)
- Which interface provides methods to establish a connection to a database in JDBC?
- A)
Connection - B)
DriverManager - C)
Statement - D)
PreparedStatement
- A)
- Which method is used to load a JDBC driver class in Java?
- A)
Class.forName() - B)
Driver.load() - C)
getClass() - D)
JDBC.loadDriver()
- A)
- Which of the following can JDBC be used for?
- A) Managing database connections
- B) Performing CRUD operations
- C) Executing SQL queries
- D) All of the above
- In JDBC, what type of object is used to execute SQL queries?
- A)
Statement - B)
ResultSet - C)
Connection - D)
CallableStatement
- A)
- What type of JDBC object is used to execute stored procedures?
- A)
CallableStatement - B)
PreparedStatement - C)
Statement - D)
ResultSet
11-15: JDBC Drivers and Connections
- What is the purpose of a JDBC driver?
- A) To handle communication between Java and the database
- B) To store database credentials
- C) To execute SQL queries
- D) To display results in the UI
- Which of the following is a type of JDBC driver?
- A) Type 1: JDBC-ODBC Bridge
- B) Type 2: Native-API Driver
- C) Type 3: Network Protocol Driver
- D) All of the above
- Which JDBC driver is suitable for direct connection to the database server using native API calls?
- A) Type 1 Driver
- B) Type 2 Driver
- C) Type 3 Driver
- D) Type 4 Driver
- Which method in the
Connectioninterface is used to create aStatementobject?
- A)
createStatement() - B)
prepareStatement() - C)
setStatement() - D)
newStatement()
- What is the correct syntax to register a JDBC driver in Java?
- A)
DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver()); - B)
Driver.registerDriver(com.mysql.cj.jdbc.Driver); - C)
Connection.registerDriver(com.mysql.cj.jdbc.Driver); - D)
DriverManager.register(com.mysql.cj.jdbc.Driver);
16-20: Executing SQL Queries in Java
- Which method is used to execute an SQL query in JDBC?
- A)
executeQuery() - B)
execute() - C)
runQuery() - D)
executeSQL()
- Which of the following methods is used to execute an SQL update query (INSERT, UPDATE, DELETE)?
- A)
executeUpdate() - B)
executeQuery() - C)
execute() - D)
runUpdate()
- What does the
executeQuery()method in JDBC return?
- A) An integer indicating the number of rows affected
- B) A
ResultSetobject containing the query results - C) A
Connectionobject - D) A
Statementobject
- Which of the following is used to handle SQL exceptions in JDBC?
- A)
SQLException - B)
SQLExceptionHandler - C)
DatabaseException - D)
JDBCException
- What type of result does
executeUpdate()return in JDBC?
- A) A
ResultSet - B) A
boolean - C) An integer indicating rows affected
- D) A
Connectionobject
21-30: Prepared Statements and Batch Processing
- What is the main advantage of using
PreparedStatementoverStatementin JDBC?
- A) Prevents SQL injection
- B) Increases query execution time
- C) Automatically closes the connection
- D) Reduces memory usage
- Which of the following methods is used to set parameters in a
PreparedStatement?
- A)
setParameter() - B)
setObject() - C)
setInt(),setString(), etc. - D)
bindParameter()
- What is the purpose of batch processing in JDBC?
- A) To execute multiple SQL queries in one go
- B) To increase memory usage
- C) To execute one SQL query repeatedly
- D) To handle SQL exceptions more effectively
- Which method is used to add a query to the batch in JDBC?
- A)
addBatch() - B)
batchQuery() - C)
addStatement() - D)
addSQL()
- How do you execute a batch of SQL queries in JDBC?
- A)
executeBatch() - B)
executeQuery() - C)
runBatch() - D)
execute()
- Which of the following methods is used to clear the batch of queries in JDBC?
- A)
clearBatch() - B)
resetBatch() - C)
clearQueries() - D)
flushBatch()
- What does the
executeBatch()method return?
- A) A
ResultSetobject - B) An array of integers indicating the number of affected rows for each statement
- C) A
Connectionobject - D) A
PreparedStatementobject
- What is the best practice for executing batch updates with
PreparedStatementin JDBC?
- A) Always execute a single update at a time
- B) Use
executeUpdate()for batch processing - C) Use
addBatch()to add multiple statements and execute them in bulk - D) Avoid using batch processing for large queries
- Which of the following is true about
PreparedStatementin JDBC?
- A) It supports SQL injection attacks
- B) It is slower than
Statement - C) It is precompiled, making it more efficient for repeated use
- D) It cannot accept parameters
- What is the correct sequence of steps for batch processing in JDBC?
- A) Create
Statement, add queries usingaddBatch(), execute withexecuteBatch() - B) Create
Connection, set parameters usingsetParameter(), execute withexecuteUpdate() - C) Create
PreparedStatement, add queries withexecuteBatch(), execute withaddBatch() - D) Create
Statement, set parameters, and execute withexecute()
Answer Key
| Qno | Answer |
|---|---|
| 1 | C) Java Database Connectivity |
| 2 | A) To connect Java applications to various databases |
| 3 | A) Load the JDBC driver |
| 4 | A) DriverManager.getConnection() |
| 5 | B) Connection |
| 6 | A) Connection |
| 7 | A) Class.forName() |
| 8 | D) All of the above |
| 9 | A) Statement |
| 10 | A) CallableStatement |
| 11 | A) To handle communication between Java and the database |
| 12 | D) All of the above |
| 13 | B) Type 2 Driver |
| 14 | A) createStatement() |
| 15 | A) DriverManager.registerDriver(new com.mysql.cj.jdbc.Driver()); |
| 16 | A) executeQuery() |
| 17 | A) executeUpdate() |
| 18 | B) A ResultSet object containing the query results |
| 19 | A) SQLException |
| 20 | C) An integer indicating rows affected |
| 21 | A) Prevents SQL injection |
| 22 | C) setInt(), setString(), etc. |
| 23 | A) To execute multiple SQL queries in one go |
| 24 | A) addBatch() |
| 25 | A) executeBatch() |
| 26 | A) clearBatch() |
| 27 | B) An array of integers indicating the number of affected rows for each statement |
| 28 | C) Use addBatch() to add multiple statements and execute them in bulk |
| 29 | C) It is precompiled, making it more efficient for repeated use |
| 30 | A) Create Statement, add queries using addBatch(), execute with executeBatch() |