Java JDBC Quiz 2 | JDBC online test, Online practice Test | Java Test

“No suitable driver” is an error which occurs during a call to the DriverManager.getConnection method and it is also a cause that can occur while failing to load the appropriate JDBC drivers before calling the getConnection method, or it can be specifying an invalid JDBC URL (which isn’t recognized by JDBC driver). While using JDBC-ODBC Bridge also this kind of error can occur. This is the cause when one or more shared libraries needed by the Bridge cannot be loaded.

The JDBC type 4 driver is known as the Direct to Database Pure Java Driver. It is a database driver implementation that converts JDBC calls directly into a vendor-specific database protocol. It is a platform independent driver and it gets install inside the Java Virtual Machine of the client. It provides higher performance then its counterparts and it also doesn’t have the overhead of conversion of calls into ODBC or database API calls.

It is vendor specific and it requires separate drivers which is provided to the vendor to connect to different types of databases. For example Oracle thin-driver.

Data manipulation language (DML) provides statements like selecting, inserting, deleting and updating data in a database. Component of DML includes performing read-only queries of data. SQL is also known as DML or data manipulation language as it is used retrieve and manipulate data in a relational database.

executeupdate() is used to perform as Data manipulation language, it is used to modify stored data but not the schema or database objects. Manipulation takes place in form of persistent database objects, e.g., tables or stored procedures, via the SQL schema statements,rather than the data stored within them.

The JDBC type 4 driver is known as the Direct to Database Pure Java Driver. It is a database driver implementation that converts JDBC calls directly into a vendor-specific database protocol. It is a platform independent driver and it gets install inside the Java Virtual Machine of the client. It provides higher performance then its counterparts and it also doesn’t have the overhead of conversion of calls into ODBC or database API calls.

It is vendor specific and it requires separate drivers which is provided to the vendor to connect to different types of databases. For example Oracle thin-driver.

The main disadvantage to this is that drivers are database dependent, as different database vendors use widely different (and usually proprietary) network protocols.