Quiz on Servlet and JDBC

When destroy() method of a filter is called?

• The destroy() method is called only once at the end of the life cycle of a filter

• The destroy() method is called after the filter has executed doFilter method

• The destroy() method is called only once at the begining of the life cycle of a filter

• The destroyer() method is called after the filter has executed

Which of the following is true about servlets?

• Servlets execute within the address space of web server

• Servlets are platform-independent because they are written in java

• Servlets can use the full functionality of the Java class libraries

• Servlets execute within the address space of web server, platform independent and uses the functionality of java class libraries

When service() method of servlet gets called?

• The service() method is called when the servlet is first created

• The service() method is called whenever the servlet is invoked

• Both a and b

• none

What is javax.servlet.http.HttpServlet?

• interface

• abstract class

• concreate class

• None of the above.

Which of the following code is used to get PrintWriter object in servlet?

• response.getWriter()

• request.getWriter()

• new PrintWriter()

• None of the above.

Which packages represent interfaces and classes for servlet API?

• javax.servlet

• javax.servlet.http

• Both A & B

• None of the above

Which class can handle any type of request so that it is protocol-independent?

• GenericServlet

• HttpServlet

• Both A & B

• None of the above

What is the lifecycle of a servlet?

• Servlet class is loaded

• Servlet instance is created

• init,Service,destroy method is invoked

• All mentioned above

Thin driver is also known as?

• Type 3 Driver

• Type-2 Driver

• Type-4 Driver

• Type-1 Driver

What is the correct sequence to create a database connection?

i. Import JDBC packages.

ii. Open a connection to the database.

iii. Load and register the JDBC driver.

iv. Execute the statement object and return a query resultset.

v. Create a statement object to perform a query.

vi. Close the resultset and statement objects.

vii. Process the resultset.

• i, ii, iii, v, iv, vii, viii, vi

• i, iii, ii, v, iv, vii, vi, viii

• ii, i, iii, iv, viii, vii, v, vi

• i, iii, ii, iv, v, vi, vii, viii