JDBC, Java Server Pages, and MySQL - Database MCQ Questions and answers- Technical Aptitude

1

How many JDBC driver types does Sun define?

A) One B) Two C) Three D) Four

Discuss

Answer & Solution

Answer: Option D

No explanation is given for this question. Let's Discuss on Board

2

Where is metadata stored in MySQL?

A) In the MySQL database metadata B) In the MySQL database metasql C) In the MySQL database mysql D) None of the above is correct

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

3

Who invented Java?

A) Netscape B) Microsoft C) Sun D) None of the above is correct

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

4

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

A) Java virtual machine B) Java compiler C) Java bytecode D) A Web browser

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

5

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

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

6

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

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

Discuss

Answer & Solution

Answer: Option A

No explanation is given for this question. Let's Discuss on Board

7

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

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board

8

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

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

9

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.

Discuss

Answer & Solution

Answer: Option C

No explanation is given for this question. Let's Discuss on Board

10

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.

Discuss

Answer & Solution

Answer: Option B

No explanation is given for this question. Let's Discuss on Board