JDBC, Java Server Pages, and MySQL - General Questions (2)

9.

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

A.	VBScript only
B.	Jscript only
C.	Java only
D.	All of the above are supported

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

10.

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?

A.	Type 1 only
B.	Type 2 only
C.	Both Type 3 and Type 4
D.	All of Type 1, Type 2, Type 3 and Type 4

Answer: Option D

Explanation:

No answer description available for this question. Let us discuss.

11.

A JSP is transformed into a(n):

A.	Java applet.
B.	Java servlet.
C.	Either 1 or 2 above.
D.	Neither 1 nor 2 above.

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

12.

What is not true of a Java bean?

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

13.

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

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

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

14.

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.	A Java application
B.	A Java applet
C.	A Java servlet
D.	None of the above is correct.

Answer: Option B

Explanation:

No answer description available for this question. Let us discuss.

15.

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

A.	MySQL
B.	JSP/SQL
C.	JDBC/SQL
D.	Sun ACCESS

Answer: Option A

Explanation:

No answer description available for this question. Let us discuss.

16.

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

A.	Both Type 1 and Type 2
B.	Both Type 1 and Type 3
C.	Both Type 3 and Type 4
D.	Type 4 only

Answer: Option C

Explanation:

No answer description available for this question. Let us discuss.

1
2
3