What is the primary difference between BeanFactory and ApplicationContext in Spring?

The correct answer is A: ApplicationContext is a subinterface of BeanFactory with additional features. ApplicationContext extends BeanFactory and adds features like event publishing, message resource handling, and easier AOP integration.

In multi-catch block (Java 7+), which operator is used to catch multiple exceptions in a single catch clause?

The correct answer is C: |. Java 7 introduced multi-catch using the pipe (|) operator: catch(IOException | SQLException e). This allows handling multiple exception types in one block.

What happens when a thread acquires a lock on an object and then calls wait()?

The correct answer is B: The thread releases the lock and enters the waiting pool. When wait() is called, the thread releases the lock it holds on the object and enters the waiting pool. Another thread can then acquire the lock. The thread re-acquires the lock when notified.

In Java, which method of Throwable class is used to obtain the cause of an exception?

The correct answer is B: getCause(). The getCause() method returns the cause (underlying Throwable) of this Throwable. It's useful for exception chaining.

What is the purpose of Connection pooling in JDBC applications?

The correct answer is B: To reuse database connections instead of creating new ones each time. Connection pooling maintains a pool of reusable connections, reducing the overhead of creating new connections for each request, improving application performance.

Home

Home › Subjects › Java Programming › JDBC

Java Programming
JDBC

Java OOP, collections, multithreading

25 Q 10 Topics Take Mock Test

Difficulty: All Easy Medium Hard 1–10 of 25

Topics in Java Programming

All Basics & Syntax 100 OOP in Java 100 Collections Framework 100 Multithreading 100 Exception Handling 100 I/O Streams 100 JDBC 100 Generics 100 Lambda Expressions 100 Spring Framework Basics 58

Q.1 Hard JDBC

In JDBC metadata operations, which method is used to retrieve information about table structure, column names, and their data types?

A getDatabaseMetaData()

B getMetaData() on ResultSet

C getColumnCount() and getColumnName()

D Both B and C together

Correct Answer: D. Both B and C together

EXPLANATION

getMetaData() on ResultSet returns ResultSetMetaData which provides column information. getColumnCount() and getColumnName() are methods of ResultSetMetaData used to retrieve structure details.

Test

Q.2 Hard JDBC

A Java application requires connection pooling to handle 1000+ concurrent database requests efficiently. Which JDBC component should be implemented?

A Direct DriverManager.getConnection() calls

B DataSource interface with connection pool implementation like HikariCP or C3P0

C Creating new Connection for each request manually

D Using Statement caching only

Correct Answer: B. DataSource interface with connection pool implementation like HikariCP or C3P0

EXPLANATION

DataSource with connection pooling frameworks (HikariCP, C3P0) efficiently manages connections by reusing them, reducing overhead. Direct getConnection() calls create new connections each time, which is inefficient for high concurrency.

Test

Q.3 Hard JDBC

In a JDBC application using batch updates, what happens if one statement in the batch fails?

A All statements are executed, and failure is reported

B All statements are rolled back automatically

C Only failed statement is skipped

D Behavior depends on database configuration

Correct Answer: D. Behavior depends on database configuration

EXPLANATION

executeBatch() behavior on failure varies by database and driver. BatchUpdateException is thrown, containing update counts for each statement. Explicit transaction control is recommended.

Test

Q.4 Hard JDBC

A query execution takes 5 seconds consistently. Which JDBC optimization technique should NOT be used for this scenario?

A Connection pooling

B Batch processing for multiple inserts

C Using indexes on frequently queried columns

D Increasing setFetchSize() value

Correct Answer: D. Increasing setFetchSize() value

EXPLANATION

If query execution itself is slow (5 seconds), the bottleneck is in database operations, not data transfer. Increasing setFetchSize() only optimizes data retrieval, not query execution.

Test

Q.5 Hard JDBC

A developer wants to retrieve data from a stored procedure that returns multiple result sets and output parameters. Which approach is correct?

A Use Statement with executeQuery()

B Use PreparedStatement with execute()

C Use CallableStatement with registerOutParameter() and execute()

D Use PreparedStatement with setFetchSize()

Correct Answer: C. Use CallableStatement with registerOutParameter() and execute()

EXPLANATION

CallableStatement is specifically designed for stored procedures, supporting registerOutParameter() for output parameters and getMoreResults() for multiple result sets.

Test

Q.6 Hard JDBC

When using JDBC with Spring Framework in 2024-25, which approach is recommended for resource management?

A Manual try-catch blocks

B Try-with-resources statement

C JdbcTemplate with Spring

D DriverManager only

Correct Answer: C. JdbcTemplate with Spring

EXPLANATION

JdbcTemplate in Spring Framework automatically manages JDBC resources and is the recommended approach in modern applications.

Test

Q.7 Hard JDBC

In JDBC, what is the significance of setting FetchSize on a Statement when dealing with large ResultSets?

A It determines the maximum number of rows to fetch from database in one round-trip

B It sets the total memory allocated for ResultSet

C It automatically closes the ResultSet

D It enables caching of all rows in memory

Correct Answer: A. It determines the maximum number of rows to fetch from database in one round-trip

EXPLANATION

FetchSize controls how many rows are fetched from the database at once, optimizing performance for large datasets.

Test

Q.8 Hard JDBC

Which JDBC feature should be used for executing multiple SQL statements in a batch for optimal performance?

A executeUpdate() in a loop

B executeBatch() with addBatch()

C execute() method

D Multiple Statement objects

Correct Answer: B. executeBatch() with addBatch()

EXPLANATION

executeBatch() with addBatch() reduces network round-trips and improves performance for bulk operations.

Test

Q.9 Hard JDBC

In a JDBC application, when using transactions with setAutoCommit(false), what happens to intermediate savepoints if rollback() is called?

A All changes are saved

B Only savepoint changes are rolled back

C All changes since last commit are rolled back

D The entire connection is closed

Correct Answer: C. All changes since last commit are rolled back

EXPLANATION

When rollback() is called without savepoints, all changes made since the last commit are undone and rolled back.

Test

Q.10 Hard JDBC

Consider a scenario: A developer uses Statement with user input directly in SQL queries. What is the primary risk?

A Slower query execution

B SQL Injection attacks

C Memory leaks

D Connection timeout

Correct Answer: B. SQL Injection attacks

EXPLANATION

Direct concatenation of user input in SQL queries exposes the application to SQL injection attacks. PreparedStatement should be used instead.

Test

1 2 3

All Subjects & Topics

Govt. Exams

Entrance Exams

Teacher Exams

Subjects

Quick Links

Java Programming JDBC

Java Programming
JDBC