Multiple choice java

Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?

  1. Type 1 only

  2. Type 2 only

  3. Both Type 3 and Type 4

  4. All of Type 1, Type 2, Type 3 and Type 4

Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

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.