Database

Database

JDBC, Java Server Pages, and MySQL has 40 Questions
How many JDBC driver types does Sun define?

One
Two
Three
Four
MySQL is just as powerful as Oracle and is half the price.

True
False
Where is metadata stored in MySQL?

In the MySQL database metadata
In the MySQL database metasql
In the MySQL database mysql
None of the above is correct.
Java programs are compiled into bytecode.

True
False
Who invented Java?

Netscape
Microsoft
Sun
None of the above is correct.
JDBC Type 2 drivers connect to the native API of the DBMS.

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

Java virtual machine
Java compiler
Java bytecode
A Web browser
MySQL surrogate keys are given the property AUTO_INCREMENT.

True
False
Which JDBC driver Type(s) can be used in either applet or servlet code?

Both Type 1 and Type 2
Both Type 1 and Type 3
Both Type 3 and Type 4
Type 4 only
A servlet is a Java program that is invoked via HTTP on the Web server.

True
False
________ is an open source DBMS product that runs on UNIX, Linux and Windows.

MySQL
JSP/SQL
JDBC/SQL
Sun ACCESS
Apache Web server does not support servlets.

True
False
What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?

A Java application
A Java applet
A Java servlet
None of the above is correct.
MySQL maintains metadata in the database meta_sql.

True
False
What MySQL property is used to create a surrogate key in MySQL?

UNIQUE
SEQUENCE
AUTO_INCREMENT
None of the above -- Surrogate keys are not implemented in MySQL.
The JVM (Java virtual machine) interprets Java bytecode at run time.

True
False
What is not true of a Java bean?

There are no public instance variables.
All persistent values are accessed using getxxx and setxxx methods.
It may have many constructors as necessary.
All of the above are true of a Java bean.
JSP pages provide a means to create dynamic Web pages using HTML and the Java programming language.

True
False
A JSP is transformed into a(n):

Java applet.
Java servlet.
Either 1 or 2 above.
Neither 1 nor 2 above.
MySQL is pronounced "my See-quel."

True
False
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
Java bytecode is machine-specific code.

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

VBScript only
Jscript only
Java only
All of the above are supported
Even though Java is machine-independent, JSPs are not.

True
False
What servlet processor was developed by Apache Foundation and Sun?

Apache Tomcat
Apache Web server
Sun servlet processor
None of the above is correct.
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.

True
False
What is bytecode?

Machine-specific code
Java code
Machine-independent code
None of the above is correct.
With JSP, the coding is done in Java and only in Java.

True
False
What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?

A Java application
A Java applet
A Java servlet
None of the above is correct.
Sun defines four JDBC driver types.

True
False
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?

Type 1
Type 2
Type 3
Type 4
Java and C/C++ are so close that there are no incompatibilities between them. Therefore, a driver is not necessary.

True
False
How many copies of a JSP page can be in memory at a time?

One
Two
Three
Unlimited
JSP and ASP not only look alike but their underlying technology is quite similar.

True
False
Which JDBC driver Types are for use over communications networks?

Type 3 only
Type 4 only
Both Type 3 and Type 4
Neither Type 3 nor Type 4
Type 3 and Type 4 JDBC drivers can be used for sevlets and applets.

True
False
JDBC stands for:

Java Database Connectivity
Java Database Components
Java Database Control
None of the above is correct.
JDBC Type 1 drivers are JDBC-ODBC bridge drivers.

True
False
How does Tomcat execute a JSP?

As a CGI script
As an independent process
By one of Tomcat's threads
None of the above is correct.
JDBC stands for Java Database Connectivity

True
False