Server Pages MySQL(Ict-Basic)Q1

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

1 Mark(s)

Unlimited
One
Two
Three

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 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) 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

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

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.

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

JDBC stands for:

1 Mark(s)

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

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

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.

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 is bytecode?

1 Mark(s)

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

Who invented Java?

1 Mark(s)

Microsoft
Sun
None of the above is correct.
Netscape

How many JDBC driver types does Sun define?

1 Mark(s)

Three
Two
One
Fo

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

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

1 Mark(s)

Type 4
Type 1
Type 2
Type 3

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 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

A JSP is transformed into a(n):

1 Mark(s)

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

What is bytecode?

1 Mark(s)

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

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

1 Mark(s)

JSP/SQL
JDBC/SQL
MySQL
Sun ACCESS

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

Career Academy