Server Pages MySQL(Ict-Basic)Q1

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

1 Mark(s)

Both Type 1 and Type 2
Both Type 1 and Type 3
Both Type 3 and Type 4
Type 4 only

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 Mark(s)

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

What servlet processor was developed by Apache Foundation and Sun?

1 Mark(s)

Apache Tomcat
Sun servlet processor
Apache Web server
None of the above is correct.

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

1 Mark(s)

SEQUENCE
UNIQUE
None of the above -- Surrogate keys are not implemented in MySQL.
AUTO_INCREMENT

What is bytecode?

1 Mark(s)

Machine-independent code
None of the above is correct
Java code
Machine-specific code

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?

1 Mark(s)

A Java servlet
A Java application
A Java applet
None of the above is correct.

How does Tomcat execute a JSP?

1 Mark(s)

None of the above is correct.
By one of Tomcat's threads
As an independent process
As a CGI script

Which JDBC driver Types are for use over communications networks?

1 Mark(s)

Neither Type 3 nor Type 4
Type 4 only
Type 3 only
Both Type 3 and Type 4

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

1 Mark(s)

JSP/SQL
JDBC/SQL
MySQL
Sun ACCESS

What is bytecode?

1 Mark(s)

Machine-independent code
None of the above is correct
Machine-specific code
Java code

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

1 Mark(s)

Unlimited
One
Two
Three

JDBC stands for:

1 Mark(s)

None of the above is correct.
Java Database Control
Java Database Components
Java Database Connectivity

A JSP is transformed into a(n):

1 Mark(s)

Java servlet.
Java applet.
Either 1 or 2 above.
Neither 1 nor 2 above.

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

1 Mark(s)

Java bytecode
A Web browser
Java compiler
Java virtual machine

Where is metadata stored in MySQL?

1 Mark(s)

In the MySQL database metadata
None of the above is correct.
In the MySQL database mysql
In the MySQL database metasql

How many JDBC driver types does Sun define?

1 Mark(s)

Three
Two
One
Fo

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

1 Mark(s)

A Java application
A Java servlet
None of the above is correct.
A Java applet

What is not true of a Java bean?

1 Mark(s)

All of the above are true of a Java bean.
All persistent values are accessed using getxxx and setxxx methods.
It may have many constructors as necessary.
There are no public instance variables.

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

1 Mark(s)

VBScript only
Java only
All of the above are supported
Jscript only

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

1 Mark(s)

Type 4
Type 1
Type 2
Type 3

Who invented Java?

1 Mark(s)

Microsoft
Sun
None of the above is correct.
Netscape

Server Pages MySQL(Ict-Basic)Q1 : Question 1 of 21

Career Academy