JDBC, Java Server Pages, and MySQL Questions and Answers

Q: Which Servlet life-cycle method is called only once ?

The keyed answer is init().The servlet container calls init() exactly once, after it creates the servlet object and before the first request, to let the servlet set itself up. service() (the printed option reads services()) and the handlers doGet() and doPost() run once for every request.One caution: destroy() is also called only once, when the container removes the servlet. The question does not exclude it, but the key and the usual textbook answer to 'called only once' is init(), the one-time initialisation method, so that is the answer given.

Q: When a servlet cannot be instantiated by the servlet container, which exception is thrown to the servlet container methods such as init() or service() ?

The answer is None of these.In the Servlet API, the life-cycle methods signal failure with ServletException and its subclass UnavailableException, which tells the container that the servlet cannot be put into service, temporarily or permanently. Neither is offered.InstantiationException is a general Java reflection exception raised when a class cannot be instantiated; it is not what init() or service() throw. ServletInitializationException is not a class in the Servlet API. IllegalStateException is thrown when a method is called at the wrong time, for example sending a redirect after the response has been committed.

Q: 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.

Correct answer: TrueThat is the definition of an applet, and the contrast with a servlet is the point: an applet is sent over HTTP and executed by the JVM in the user’s browser, a servlet is executed by the container on the server. The applet’s dependence on a browser JVM is what eventually made it obsolete.

Q: What is not true of a Java bean?

Correct answer: It may have many constructors as necessary.A bean must provide a public constructor taking no arguments, because the container creates it by reflection and has no arguments to supply. Additional constructors may exist, but the no-argument one is obligatory, so the statement as written is not true of a bean. The other two - no public instance variables, access through get and set methods - are the other defining requirements.

Q: JSP and ASP not only look alike but their underlying technology is quite similar.

Correct answer: FalseThey look alike on the page, both embedding code in HTML, and there the resemblance ends. JSP is translated into a Java servlet and runs on the JVM in a servlet container; ASP runs under the Microsoft web server and accepts VBScript and JScript rather than Java. The similarity is of appearance only.

Q: MySQL is pronounced "my See-quel."

Correct answer: FalseIt is pronounced My Ess Cue Ell, letter by letter, and the manual says so explicitly. The See-quel pronunciation belongs to SQL Server and to SQL informally, and the distinction is a point the MySQL documentation has always been particular about.

Q: Which JDBC driver Types are for use over communications networks?

Correct answer: Both Type 3 and Type 4Types 3 and 4 are pure Java and communicate over a network, Type 3 to a middleware server and Type 4 straight to the DBMS in its own protocol. Neither needs anything installed on the client, which is what makes them the types usable from applets and from servlets on machines separate from the database.

Q: MySQL surrogate keys are given the property AUTO_INCREMENT.

Correct answer: TrueAUTO_INCREMENT on an integer column makes MySQL supply the next value automatically on each insert, which is precisely what a surrogate key needs: a unique value with no meaning, generated by the system rather than by the application.

Q: JDBC Type 2 drivers connect to the native API of the DBMS.

Correct answer: TrueA Type 2 driver converts JDBC calls into calls on the DBMS vendor’s own client library, so part of it is native code that must be installed on the machine. It is generally faster than the Type 1 bridge for that reason, and less portable for the same one.

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

Correct answer: OneThe container keeps a single instance of the translated servlet and serves every concurrent request from it, each on its own thread. This is why a JSP must be written to be thread-safe: an instance variable is shared across all users, and only local variables within the service method are private to a request.

Which Servlet life-cycle method is called only once ?

A.init()
B.services()
C.destroy()
D.doGet()

Exam Year(s)

Tripura Public Service Commission - 2026,

Answer: A

The keyed answer is init().

The servlet container calls init() exactly once, after it creates the servlet object and before the first request, to let the servlet set itself up. service() (the printed option reads services()) and the handlers doGet() and doPost() run once for every request.

One caution: destroy() is also called only once, when the container removes the servlet. The question does not exclude it, but the key and the usual textbook answer to 'called only once' is init(), the one-time initialisation method, so that is the answer given.

Discuss in Forum

When a servlet cannot be instantiated by the servlet container, which exception is thrown to the servlet container methods such as init() or service() ?

A.InstantiationException
B.ServletInitializationException
C.IllegalStateException
D.None of these

Exam Year(s)

Tripura Public Service Commission - 2026,

Answer: D

The answer is None of these.

In the Servlet API, the life-cycle methods signal failure with ServletException and its subclass UnavailableException, which tells the container that the servlet cannot be put into service, temporarily or permanently. Neither is offered.

InstantiationException is a general Java reflection exception raised when a class cannot be instantiated; it is not what init() or service() throw. ServletInitializationException is not a class in the Servlet API. IllegalStateException is thrown when a method is called at the wrong time, for example sending a redirect after the response has been committed.

Discuss in Forum

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.

A.True
B.False

Answer: A

Correct answer: True

That is the definition of an applet, and the contrast with a servlet is the point: an applet is sent over HTTP and executed by the JVM in the user’s browser, a servlet is executed by the container on the server. The applet’s dependence on a browser JVM is what eventually made it obsolete.

Discuss in Forum

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

Correct answer: It may have many constructors as necessary.

A bean must provide a public constructor taking no arguments, because the container creates it by reflection and has no arguments to supply. Additional constructors may exist, but the no-argument one is obligatory, so the statement as written is not true of a bean. The other two - no public instance variables, access through get and set methods - are the other defining requirements.

Discuss in Forum

JSP and ASP not only look alike but their underlying technology is quite similar.

A.True
B.False

Answer: B

Correct answer: False

They look alike on the page, both embedding code in HTML, and there the resemblance ends. JSP is translated into a Java servlet and runs on the JVM in a servlet container; ASP runs under the Microsoft web server and accepts VBScript and JScript rather than Java. The similarity is of appearance only.

Discuss in Forum

MySQL is pronounced "my See-quel."

A.True
B.False

Answer: B

Correct answer: False

It is pronounced My Ess Cue Ell, letter by letter, and the manual says so explicitly. The See-quel pronunciation belongs to SQL Server and to SQL informally, and the distinction is a point the MySQL documentation has always been particular about.

Discuss in Forum

Which JDBC driver Types are for use over communications networks?

A.Type 3 only
B.Type 4 only
C.Both Type 3 and Type 4
D.Neither Type 3 nor Type 4

Answer: C

Correct answer: Both Type 3 and Type 4

Types 3 and 4 are pure Java and communicate over a network, Type 3 to a middleware server and Type 4 straight to the DBMS in its own protocol. Neither needs anything installed on the client, which is what makes them the types usable from applets and from servlets on machines separate from the database.

Discuss in Forum

MySQL surrogate keys are given the property AUTO_INCREMENT.

A.True
B.False

Answer: A

Correct answer: True

AUTO_INCREMENT on an integer column makes MySQL supply the next value automatically on each insert, which is precisely what a surrogate key needs: a unique value with no meaning, generated by the system rather than by the application.

Discuss in Forum

JDBC Type 2 drivers connect to the native API of the DBMS.

A.True
B.False

Answer: A

Correct answer: True

A Type 2 driver converts JDBC calls into calls on the DBMS vendor’s own client library, so part of it is native code that must be installed on the machine. It is generally faster than the Type 1 bridge for that reason, and less portable for the same one.

Discuss in Forum

10.

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

A.One
B.Two
C.Three
D.Unlimited

Answer: A

Correct answer: One

The container keeps a single instance of the translated servlet and serves every concurrent request from it, each on its own thread. This is why a JSP must be written to be thread-safe: an instance variable is shared across all users, and only local variables within the service method are private to a request.

Discuss in Forum

Loading…

Topics

Other Subjects

Tags: JDBC, Java Server Pages, and MySQL Questions and Answers || JDBC, Java Server Pages, and MySQL MCQ Questions and Answers || JDBC, Java Server Pages, and MySQL GK Questions and Answers || JDBC, Java Server Pages, and MySQL GK MCQ Questions || JDBC, Java Server Pages, and MySQL Multiple Choice Questions and Answers || JDBC, Java Server Pages, and MySQL GK || GK on JDBC, Java Server Pages, and MySQL || Database Questions and Answers || Database MCQ Questions and Answers || Database GK Questions and Answers || GK on Database

JDBC, Java Server Pages, and MySQL Questions and Answers

Topics

Other Subjects

About Us

Stay informed about all important Dates & Notifications