Question 1

How many Result sets available with the JDBC 2.0 core API?
A)2
B)3
C)4
D)5

Accepted Answer

The JDBC 2.0 core API provides three types of result sets: forward-only, scroll-insensitive, and scroll-sensitive.

Question 2

Which method is used to establish the connection with the specified url in a Driver Manager class?
A)public static void registerDriver(Driver driver)
B)public static void deregisterDriver(Driver driver)
C)public static Connection getConnection(String url)
D)public static Connection getConnection(String url,String userName,String password)

Accepted Answer

The getConnection(String url) method in the DriverManager class is used to establish a connection with the specified URL.

Question 3

Which driver Network connection is indirect that a JDBC client makes to a middleware process that acts as a bridge to the DBMS server?
A)JDBC-Net
B)JDBC-ODBC bridge
C)Native API as basis
D)Native protocol as basis

Accepted Answer

JDBC-Net driver (also known as Type 3 driver) uses a three-tier approach where the JDBC client communicates with a middleware application server, which in turn communicates with the DBMS. This allows for a network-based, indirect connection to the database server.

Question 4

JDBC RowSet is the wrapper of ResultSet,It holds tabular data like ResultSet but it is easy and flexible to use.

Accepted Answer

RowSet is indeed a wrapper around ResultSet, designed to make handling and passing data easier and more flexible, including features like being disconnected and serializable, which are not available in ResultSet.

Question 5

The ResultSet.next method is used to move to the next row of the ResultSet, making it the current row.

Accepted Answer

The ResultSet.next method is indeed used to move the cursor to the next row of the ResultSet, thereby making that row the current one from which data can be retrieved.

Question 6

Which JDBC product components does the Java software provide?
A)The JDBC driver manager
B)The JDBC driver test suite
C)The JDBC-ODBC bridge
D)All mentioned above

Accepted Answer

The Java software provides all mentioned components: the JDBC driver manager, the JDBC driver test suite, and the JDBC-ODBC bridge, making all of them integral parts of the JDBC product offerings.

Question 7

Which class has traditionally been the backbone of the JDBC architecture?
A)the JDBC driver manager
B)the JDBC driver test suite
C)the JDBC-ODBC bridge
D)All mentioned above

Accepted Answer

The JDBC Driver Manager is the fundamental component of the JDBC architecture, acting as a manager or director for establishing connections between database applications and the appropriate JDBC drivers.

Question 8

Which was the first most widely used programming interface for accessing relational databases and it offers the ability to connect all the databases on all the platforms.?
A)JDBC API
B)ODBC API
C)Both A & B
D)None of the above

Accepted Answer

ODBC (Open Database Connectivity) API was the first most widely used programming interface for accessing relational databases across different platforms, allowing for the connection to all databases on all platforms. JDBC (Java Database Connectivity) came later, specifically for Java applications.

Question 9

JDBC is a Java API that is used to connect and execute query to the database

Accepted Answer

JDBC (Java Database Connectivity) is an API in Java that allows programs to connect to databases, execute queries, and retrieve results, facilitating data manipulation and management.

Question 10

In the following JDBC drivers which is known as fully java driver?
A)Native-API driver
B)Network Protocol driver
C)Thin driver
D)Both B & C

Accepted Answer

Both Network Protocol driver (B) and Thin driver (C) are considered fully Java drivers. The Thin driver is a pure Java driver that communicates directly with the database server using the database-specific protocol. The Network Protocol driver, also fully implemented in Java, communicates with middleware that then communicates with the database. Both do not rely on native code, making them platform-independent.

Question 11

Which JDBC drivers will run your program?
A)The JDBC-ODBC bridge
B)The JDBC driver manager
C)The JDBC driver test suite
D)None of the above

Accepted Answer

The answer of Which JDBC drivers will run your program?
A)The...

Question 12

What is the reason that a java program cannot directly communicate with an ODBC driver?
A)ODBC written in C# language
B)ODBC written in C language
C)ODBC written in C++ language
D)None of the above

Accepted Answer

Java programs cannot directly communicate with an ODBC driver because ODBC is written in C language, and Java uses a different native interface for database connectivity, typically JDBC for Java applications.

Question 13

A leading database connectivity vendor, worked together to produce the ____.
A)JDBC-ODBC Bridge
B)JDBC Driver Test Suite
C)Both A & B
D)None of the above

Accepted Answer

Sun Microsystems, the company behind Java, and a leading database connectivity vendor, collaborated to produce both the JDBC-ODBC Bridge and the JDBC Driver Test Suite. The JDBC-ODBC Bridge allowed Java programs to connect to databases via the ODBC driver, and the JDBC Driver Test Suite was developed to ensure that JDBC drivers met the standards and worked as expected.

Question 14

Which driver converts JDBC calls directly into the vendor-specific database protocol?
A)Native - API driver
B)Network Protocol driver
C)Thin driver
D)Both B & C

Accepted Answer

The Thin driver converts JDBC calls directly into the vendor-specific database protocol, allowing direct communication with the database server without needing any additional translation or middleware layers.

Question 15

Which models do the JDBC API support for the database access?
A)Two-tier models
B)Three-tier models
C)Both A & B
D)None of the above

Accepted Answer

The JDBC API supports both two-tier and three-tier models for database access. In a two-tier model, a Java app communicates directly with the database. In a three-tier model, the Java app communicates with a middle tier, which then communicates with the database.

Question 16

Which of the following JDBC drivers is known as a partially java driver?
A)JDBC-ODBC bridge driver
B)Native-API driver
C)Network Protocol driver
D)Thin driver

Accepted Answer

The Native-API driver, also known as Type 2 driver, is known as a partially Java driver because it converts JDBC calls into database-specific calls using a native API that is partially written in native code (non-Java) specific to the database.

Question 17

The JDBC API is what allows access to a data source from a Java middle tier

Accepted Answer

The JDBC (Java Database Connectivity) API is specifically designed to enable Java applications to interact with a wide range of databases and data sources, serving as a bridge between Java applications and the data sources they need to access.

Question 18

Which driver uses ODBC driver to connect to the database?
A)JDBC-ODBC bridge driver
B)Native - API driver
C)Network Protocol driver
D)Thin driver

Accepted Answer

The JDBC-ODBC bridge driver allows Java applications to connect to databases via the Open Database Connectivity (ODBC) interface, which is a standard API for accessing database management systems (DBMS). This driver translates JDBC method calls into ODBC function calls to interact with the database.

Question 19

How many JDBC product components does the Java software provides?
A)3
B)2
C)4
D)5

Accepted Answer

JDBC provides 4 product components: JDBC API, JDBC Driver, JDBC Driver Manager, and JDBC Database Metadata.

Question 20

How many types of JDBC drivers are available?
A)3
B)4
C)2
D)5

Accepted Answer

There are 4 types of JDBC drivers available: Type 1 (JDBC-ODBC bridge), Type 2 (native-API driver), Type 3 (network protocol driver), and Type 4 (thin driver).

Quiz 2: JDBC, Servlets, and Cookies

How many Result sets available with the JDBC 2.0 core API?

Which method is used to establish the connection with the specified url in a Driver Manager class?

Which driver Network connection is indirect that a JDBC client makes to a middleware process that acts as a bridge to the DBMS server?

JDBC RowSet is the wrapper of ResultSet,It holds tabular data like ResultSet but it is easy and flexible to use.

The ResultSet.next method is used to move to the next row of the ResultSet, making it the current row.

Which JDBC product components does the Java software provide?

Which class has traditionally been the backbone of the JDBC architecture?

Which was the first most widely used programming interface for accessing relational databases and it offers the ability to connect all the databases on all the platforms.?

JDBC is a Java API that is used to connect and execute query to the database

In the following JDBC drivers which is known as fully java driver?

Which JDBC drivers will run your program?

What is the reason that a java program cannot directly communicate with an ODBC driver?

A leading database connectivity vendor, worked together to produce the ____.

Which driver converts JDBC calls directly into the vendor-specific database protocol?

Which models do the JDBC API support for the database access?

Which of the following JDBC drivers is known as a partially java driver?

The JDBC API is what allows access to a data source from a Java middle tier

Which driver uses ODBC driver to connect to the database?

How many JDBC product components does the Java software provides?

How many types of JDBC drivers are available?