JDBC Quiz

Sun defines four JDBC driver types: Type 1 (JDBC-ODBC bridge), Type 2 (native API/partly Java), Type 3 (pure Java/net protocol), and Type 4 (pure Java/direct connectivity). This categorization has been part of JDBC specification since early versions.

MySQL stores system metadata (table definitions, user privileges, etc.) in a specific system database named 'mysql'. This database contains tables like 'user', 'db', and 'tables_priv'. Options A and B do not exist as standard system databases.

Type 3 and Type 4 drivers are written in 100% Java. Type 4 communicates directly with the database, while Type 3 uses a middleware server. Because they don't require native client library installations, they are suitable for applets (subject to security sandboxing) and servlets, unlike Type 1 and 2.

In a scenario where the Web server and DBMS are on the same machine, all driver types are technically usable. Type 1 (Bridge) and Type 2 (Native-API) work via local client libraries. Type 3 (Network-Protocol) and Type 4 (Native-Protocol) work over network sockets, which function fine on localhost.