MCQ IN COMPUTER SCIENCE & ENGINEERING

COMPUTER SCIENCE AND ENGINEERING

SQL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which type of driver provides JDBC access via one or more ODBC drivers?
A
Type 1 driver
B
Type 2 driver
C
Type 3 driver
D
Type 4 driver
Explanation: 

Detailed explanation-1: -Type one drivers provide JDBC access via one or more Open Database Connectivity (ODBC) drivers. ODBC, which predates JDBC, is widely used by developers to connect to databases in a non-Java environment.

Detailed explanation-2: -The JDBC type 1 driver, also known as the JDBC-ODBC bridge, is a database driver implementation that employs the ODBC driver to connect to the database. The driver converts JDBC method calls into ODBC function calls.

Detailed explanation-3: -Type-1 driver or JDBC-ODBC bridge driver uses ODBC driver to connect to the database. The JDBC-ODBC bridge driver converts JDBC method calls into the ODBC function calls. Type-1 driver is also called Universal driver because it can be used to connect to any of the databases.

Detailed explanation-4: -The Type 1 JDBC driver is simply a JDBC-ODBC bridge. The Type 2 JDBC driver is written in a language other than Java, often C++ or C. The Type 3 JDBC driver talks to a middleware server first, not the database directly. The Type 4 JDBC driver is a pure, direct Java-to-the-database implementation.

Detailed explanation-5: -Type-1 Driver JDBC driver also known as bridge driver it provides a bridge to access the ODBC driver installed on each client. Type 1 drivers translate calls to JDBC methods into calls to Open Database Connectivity (ODBC) functions.

There is 1 question to complete.