Exploring JDBC and Servlets

What does JDBC stand for?

• Java Database Connector

• Java Data Connectivity

• Java Database Connectivity

• Java Data Base Connection

Name the types of JDBC drivers.

• Type B

• Type 1, Type 2, Type 3, Type 4

• Type C

• Type A

How do you establish a connection to a database using JDBC?

• Invoke Database.connect(url) without a driver

• Use ConnectionFactory.createConnection(url, username, password)

• Call DatabaseManager.openConnection(url) directly

• Use DriverManager.getConnection(url, username, password) after loading the JDBC driver.

What is the purpose of the Statement interface in JDBC?

• To execute SQL statements and interact with the database.

• To create database connections.

• To define the structure of database tables.

• To manage user permissions in the database.

What is a ResultSet in JDBC?

• A ResultSet is a graphical user interface for SQL queries.

• A ResultSet is a type of database connection.

• A ResultSet is a method for executing SQL commands.

• A ResultSet is an object in JDBC that contains the data returned by executing a SQL query.

Explain the life cycle of a Servlet.

• The life cycle of a Servlet includes loading, initialization, request handling, and destruction.

• Servlets do not have a defined life cycle.

• The life cycle of a Servlet includes only loading and destruction.

• The life cycle of a Servlet consists of initialization and termination only.

What is Tomcat used for in Servlet development?

• Tomcat is a programming language for building applications.

• Tomcat is a database management system.

• Tomcat is used for front-end web development.

• Tomcat is used as a servlet container to run Java Servlets and JSPs.

How do you read parameters from a Servlet?

• Access parameters using the ServletContext object.

• Read parameters directly from the URL string.

• Use HttpServletResponse's setHeader() method.

• Use HttpServletRequest's getParameter() or getParameterValues() methods.

What is the role of the javax.servlet.Http package?

• The javax.servlet.Http package is responsible for rendering HTML pages.

• The javax.servlet.Http package facilitates handling HTTP requests and responses in Java web applications.

• The javax.servlet.Http package manages user authentication in Java applications.

• The javax.servlet.Http package is used for database connectivity.

How can session tracking be implemented in Servlets?

• Relying solely on client-side scripts

• Using only server-side storage

• Session tracking can be implemented using HttpSession, cookies, or URL rewriting.

• Implementing session tracking with static variables