JDBC, Java Server Pages, and MySQL Questions and Answers

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.

Answer: A

Correct answer: Apache Tomcat

Tomcat is the servlet container produced by the Apache Foundation with Sun, and it is the reference implementation of the servlet and JSP specifications. The Apache web server itself serves HTTP and does not run servlets, so the two are usually deployed together with requests for JSPs passed through to Tomcat.

Answer: C

Correct answer: A Java servlet

A servlet is Java bytecode that runs on the server, invoked over HTTP when a request arrives from a browser, and returns a response. An applet is its mirror image, sent to the browser and run on the user’s machine, and an ordinary application has nothing to do with HTTP.

Answer: C

Correct answer: Machine-independent code

Bytecode is the instruction set of the Java virtual machine rather than of any real processor, so the same compiled file runs anywhere a JVM exists. That is precisely what makes Java portable, and it is why a JVM must be present on the machine before a compiled program can run at all.

Answer: A

Correct answer: Java Database Connectivity

JDBC is the standard API by which a Java program issues SQL to any database for which a driver exists, and its role in Java is what ODBC’s is elsewhere. The driver, loaded at run time, is what makes the same application code work against different DBMS products.

Answer: C

Correct answer: AUTO_INCREMENT

Declaring an integer column AUTO_INCREMENT makes MySQL assign the next value on each insert, which is the standard way of creating a surrogate key. Oracle of the same era had no such property and needed a sequence with a trigger instead - a difference worth remembering when porting a schema.

Answer: A

Correct answer: True

That is the definition. A servlet is Java bytecode running inside a container on the web server, invoked when an HTTP request arrives and returning the response. It is the server-side counterpart of the applet, which runs on the user’s machine instead.

Answer: C

Correct answer: Sun

Java was developed at Sun Microsystems, released in 1995, and the language, the virtual machine and the JDBC specification all came from there. Sun was acquired by Oracle in 2010, which is why current Java documentation carries Oracle’s name.

Answer: A

Correct answer: Type 1

Type 1 is the JDBC-ODBC bridge: it translates JDBC calls into ODBC calls and relies on an ODBC driver and data source being configured on the machine. That dependency makes it the least portable of the four, and it was intended as a stopgap for databases with no native JDBC driver.