JDBC, JAVA SERVER PAGES, AND MYSQL QUIZ

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?

Type 1 only

Type 2 only

Both Type 3 and Type 4

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

TRUE ANSWER : ?
YOUR ANSWER : ?

To run a compiled Java program, the machine must have what loaded and running?

Java virtual machine

A Web browser

Java compiler

Java bytecode

TRUE ANSWER : ?
YOUR ANSWER : ?

What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?

Java only

All of these

Jscript only

VBScript only

TRUE ANSWER : ?
YOUR ANSWER : ?

MySQL maintains metadata in the database meta_sql.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

Even though Java is machine-independent, JSPs are not.

True

False

TRUE ANSWER : ?
YOUR ANSWER : ?

An applet is a Java bytecode program that is sent to the user via HTTP and is invoked using the HTTP protocol on the user's computer.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

JDBC stands for:

Java Database Control

None of these

Java Database Connectivity

Java Database Components

TRUE ANSWER : ?
YOUR ANSWER : ?

JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

How does Tomcat execute a JSP?

As an independent process

As a CGI script

By one of Tomcat's threads

None of these

TRUE ANSWER : ?
YOUR ANSWER : ?

Java bytecode is machine-specific code.

False

True

TRUE ANSWER : ?
YOUR ANSWER : ?

↑