JDBC, Java Server Pages, and MySQL Questions and Answers

Answer: A

Correct answer: True

The Apache web server serves HTTP and static content and does not execute servlets; that is Tomcat’s function. The two are commonly deployed together, Apache handling ordinary requests and passing those for servlets and JSPs through to Tomcat, so the combination supports servlets although Apache alone does not.

Answer: B

Correct answer: True

Sun defines four: Type 1, the JDBC-ODBC bridge; Type 2, calling the DBMS’s native client library; Type 3, speaking to middleware over a network; and Type 4, pure Java speaking the DBMS protocol directly. The four differ in how much native code they require and hence in where they can be deployed.

Answer: B

Correct answer: Java servlet.

A JSP page is translated by the container into the source of a servlet, which is then compiled and run like any other. The translation happens once, on first request, which is why the first hit on a page is slow and later ones are not. The JSP is therefore a convenient way of writing a servlet, not a different technology.

Answer: A

Correct answer: True

Types 3 and 4 are pure Java and need nothing installed on the machine they run on, so they are usable from an applet in a browser as well as from a servlet on a server. Types 1 and 2 depend on ODBC or a native client library being present locally, which an applet cannot assume.

Answer: C

Correct answer: By one of Tomcat's threads

Tomcat runs the translated servlet inside its own process, allocating one of its threads to each request. Nothing is forked and no separate process is started, which is exactly why servlets are so much faster than CGI scripts - and why they must be written to be thread-safe.

Answer: A

Correct answer: True

Java Database Connectivity is the standard API for issuing SQL from Java. The application programs against JDBC and the driver, loaded at run time, translates for the particular DBMS - which is how the same code runs against different databases without alteration.

Answer: B

Correct answer: False

The two are not equivalent products. Oracle offers a range of enterprise features that MySQL of this period did not, and the pricing comparison is not half the price but free against a substantial licence fee. Which is the better choice depends on the application; the claim as stated is wrong on both halves.

Answer: D

Correct answer: All of Type 1, Type 2, Type 3 and Type 4

With the web server and the DBMS on one machine, the driver runs where the native libraries are and no network is crossed, so nothing rules any type out. Types 1 and 2 become impracticable only when the code must run somewhere the native components are not installed, which is the applet and distributed cases.

Answer: A

Correct answer: True

A JSP page is HTML with Java embedded in it, translated by the container into a servlet that generates the page when requested. The point of the arrangement is that the static part of the page is written as ordinary HTML and only the varying part as code, which is the reverse of writing a servlet that prints HTML.

Answer: A

Correct answer: True

Type 1 is the bridge: it translates JDBC calls into ODBC calls and depends on an ODBC driver and a configured data source on the machine. It was provided so that Java could reach databases with no JDBC driver of their own, and its local dependency makes it the least portable of the four.