0% found this document useful (0 votes)
7 views15 pages

Java Servlet and JDBC Quiz Answers

advanced java

Uploaded by

Sahu Sahu Subham
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
7 views15 pages

Java Servlet and JDBC Quiz Answers

advanced java

Uploaded by

Sahu Sahu Subham
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Certainly!

Here is the answer key formatted with each question, its options, and the correct answer
following each question:

1. Which of the following code is used to get an HTTP Session object in servlets?

Options:

1. [Link]()
2. [Link]();
3. new Session()
4. [Link]()

Correct Answer: 1. [Link]()

2. Which keyword is used for inheritance in Java?

Options:

1. extend
2. extends
3. derived
4. extents

Correct Answer: 2. extends

3. Which method of ResultSet is used to move the cursor to the next row?

Options:

1. next()
2. moveToNext()
3. moveNext()
4. forward()

Correct Answer: 1. next()

4. Which interface in JDBC is responsible for managing a connection with a database?

Options:

1. DriverManager
2. Connection
3. Statement

Page 1 of 15
4. ResultSet

Correct Answer: 2. Connection

5. Which of the following is not true about the GET method?

Options:

1. It is appended along with the URL


2. Only limited data can be sent
3. It is not secure
4. It is less efficient

Correct Answer: 4. It is less efficient

6. Exception is found in which package of Java?

Options:

1. [Link]
2. [Link]
3. [Link]
4. [Link]

Correct Answer: 3. [Link]

7. Which method of the HttpServlet class is called only once during the servlet lifecycle?

Options:

1. init()
2. doGet()
3. doPost()
4. service()

Correct Answer: 1. init()

8. The request is an instance of which one of the following classes?

Options:

1. request
2. HttpRequest
3. HttpServletRequest
4. ServletRequest
Page 2 of 15
Correct Answer: 3. HttpServletRequest

9. What is the full form of JSP?

Options:

1. Java Servlet Packets


2. Java Standard Pages
3. Java Server Pages
4. Java Servlet Pages

Correct Answer: 3. Java Server Pages

10. Which of the following is an example of a runtime exception?

Options:

1. FileNotFoundException
2. ArrayStoreException
3. InterruptedException
4. None of the above

Correct Answer: 2. ArrayStoreException

11. What does JDBC Batch Processing provide?

Options:

1. It allows executing multiple SQL statements as a single batch


2. It allows executing SQL queries asynchronously
3. It allows executing SQL queries in parallel
4. It allows executing SQL queries with higher priority

Correct Answer: 1. It allows executing multiple SQL statements as a single batch

12. Which method of Connection is used to create a Statement object?

Options:

1. createStatement()
2. prepareStatement()
3. executeStatement()
4. statement()

Correct Answer: 1. createStatement()


Page 3 of 15
13. Queue follows which principle?

Options:

1. FIFO
2. LIFO
3. Both A and B
4. None of the above

Correct Answer: 1. FIFO

14. Which method is called at the end to clear the memory occupied by the servlet?

Options:

1. clear()
2. destroy()
3. erase()
4. none of the above

Correct Answer: 2. destroy()

15. Which interface in JDBC is used to execute SQL queries?

Options:

1. Connection
2. DriverManager
3. Statement
4. ResultSet

Correct Answer: 3. Statement

16. Which method is used to establish a connection to a database in JDBC?

Options:

1. getConnection()
2. createConnection()
3. establishConnection()
4. openConnection()

Correct Answer: 1. getConnection()

Page 4 of 15
17. Which of the following tags is used to represent JSP Expression tags?

Options:

1. <%= %>
2. <%= %>
3. <%= %>
4. <%= %>

Correct Answer: 1. <%= %>

18. What is the purpose of the DriverManager class in JDBC?

Options:

1. It manages connections to the database


2. It represents the database driver
3. It provides methods for executing SQL queries
4. It provides metadata about the database schema

Correct Answer: 1. It manages connections to the database

19. Which of the following interfaces must a Servlet class implement?

Options:

1. Servlet
2. HttpServlet
3. ServletConfig
4. All of the above

Correct Answer: 1. Servlet

20. Which block is used to enclose the code that might throw an error?

Options:

1. try
2. catch
3. throw
4. finally

Correct Answer: 1. try

21. [Link] is present in which of the folder?


Page 5 of 15
Options:

1. info
2. WEB-INF
3. lib
4. none of the above

Correct Answer: 2. WEB-INF

22. Which of the following methods of ResultSet is used to retrieve data from a specific column?

Options:

1. getObject()
2. getData()
3. getString()
4. getColumn()

Correct Answer: 3. getString()

23. Which interface in JDBC is used to represent the results of a SQL query?

Options:

1. Connection
2. Statement
3. ResultSet
4. ResultSetMetaData

Correct Answer: 3. ResultSet

24. Which inheritance is not supported by Java?

Options:

1. Single
2. Multi-level
3. Hierarchical
4. None of the above

Correct Answer: 4. None of the above** (Note: The correct answer should be "Multiple
inheritance," which is not listed as an option.)

25. What is the role of the SQLException class in JDBC?

Page 6 of 15
Options:

1. It represents a warning issued by the database server


2. It represents an error that occurred during SQL execution
3. It represents an informational message from the database server
4. It represents a message about successful SQL execution

Correct Answer: 2. It represents an error that occurred during SQL execution

26. What is the correct syntax to include another JSP page within a JSP page?

Options:

1.
2. <jsp:include page="[Link]"/>
3.
4. <include ="[Link]"/>

Correct Answer: 2. <jsp:include page="[Link]"/>

Certainly! Here is the continuation of the answer key, starting from question 27, with each question, its
options, and the correct answer:

27. Given the code snippet, what will be the output?

class Car {
void startCar() {
[Link]("Car started.");
}
}

class Tiago extends Car {


void startCar() {
[Link]("Tiago started.");
}
}

public class Test {


public static void main(String[] args) {
Car myCar = new Tiago();
[Link]();
}
}

Page 7 of 15
Options:

1. Car started
2. Tiago started
3. Compilation Error
4. No Output

Correct Answer: 3. Compilation Error

(Note: The provided code snippet in the question has syntax errors, such as missing closing braces and
incomplete print statements.)

28. What is the purpose of the finally block in Java exception handling?

Options:

1. It is used to handle the exception


2. It defines custom exception classes
3. It is used to declare throws clause in methods
4. It is always executed, regardless of whether an exception is thrown or not

Correct Answer: 4. It is always executed, regardless of whether an exception is thrown or not

29. Which class is used to establish a database connection in JDBC?

Options:

1. [Link]
2. [Link]
3. [Link]
4. [Link]

Correct Answer: 1. [Link]

30. Which JDBC component is used for establishing a connection with the specific database in
JDBC?

Options:

1. ResultSet
2. Connection
3. PreparedStatement
4. DriverManager

Correct Answer: 4. DriverManager

Page 8 of 15
31. What is the mechanism in Java that allows creating new classes based on existing ones?

Options:

1. Interface
2. Inheritance
3. Abstraction
4. Package

Correct Answer: 2. Inheritance

32. Consider the following code snippet:

protected void doGet(HttpServletRequest request, HttpServletResponse resp


throws ServletException, IOException {
[Link]("text/html");
PrintWriter out = [Link]();
[Link]("<html><body>");
[Link]("<h1>Hello</h1>");
[Link]("</body></html>");
}

Options:

1. It sets the character encoding of the response


2. It specifies the content type of the response as HTML
3. It instructs the browser to cache the response
4. It sets the HTTP status code of the response

Correct Answer: 2. It specifies the content type of the response as HTML

33. Which keyword is used to explicitly throw an exception in Java?

Options:

1. try
2. catch
3. throw
4. finally

Correct Answer: 3. throw

34. In what order do the servlet life cycle methods get called?

Page 9 of 15
Options:

1. service(), init(), destroy()


2. init(), service(), destroy()
3. service(), destroy(), init()
4. All of the above

Correct Answer: 2. init(), service(), destroy()

35. Which of these packages contain all the collection classes?

Options:

1. [Link]
2. [Link]
3. [Link]
4. [Link]

Correct Answer: 1. [Link]

36. JDBC is an API that consists of a set of Java classes, interfaces, and exceptions.

Options:

1. TRUE
2. FALSE

Correct Answer: 1. TRUE

37. What method in JDBC allows you to execute a batch of SQL statements?

Options:

1. executeUpdate
2. executeBatch
3. executeQuery
4. execute

Correct Answer: 2. executeBatch

38. Which feature of Java allows performing a single action in different ways?

Options:

1. Abstraction

Page 10 of 15
2. Encapsulation
3. Polymorphism
4. Inheritance

Correct Answer: 3. Polymorphism

39. What is the primary purpose of exception handling in Java?

Options:

1. To debug the code


2. To handle runtime errors and maintain the normal flow of the program
3. To optimize the code for better performance
4. To provide documentation

Correct Answer: 2. To handle runtime errors and maintain the normal flow of the program

40. Which of the following is not a valid type of statement in JDBC?

Options:

1. sql_query_statement
2. CallableStatement
3. Statement
4. PreparedStatement

Correct Answer: 1. sql_query_statement

41. Which of the following annotations is used to map a servlet to a URL pattern in a web application?

Options:

1. @WebServlet
2. @WebListener
3. @WebFilter
4. @Controller

Correct Answer: 1. @WebServlet

42. Which HTTP methods do the doGet() and doPost() methods handle, respectively?

Options:

1. doGet() handles GET, doPost() handles POST


2. doGet() handles POST, doPost() handles GET
Page 11 of 15
3. Both handle POST requests
4. Both handle GET requests

Correct Answer: 1. doGet() handles GET, doPost() handles POST

43. What does the "[Link]()" method do in JDBC?

Options:

1. Connects to the database


2. Loads the JDBC driver class
3. Executes a SQL Query
4. Creates a new instance of the Connection class

Correct Answer: 2. Loads the JDBC driver class

44. What is the role of the "Statement" object in JDBC?

Options:

1. To load the JDBC driver


2. To establish a database connection
3. To handle the result set
4. To execute a SQL query

Correct Answer: 4. To execute a SQL query

45. What method is used to retrieve data from a database table in JDBC?

Options:

1. getConnection()
2. executeQuery()
3. executeUpdate()
4. getResultset()

Correct Answer: 2. executeQuery()

46. What interface represents a set of rows and columns obtained from a database query in JDBC?

Options:

1. DriverManager
2. Connection
3. Statement
Page 12 of 15
4. ResultSet

Correct Answer: 4. ResultSet

47. In which file do we define a servlet mapping?

Options:

1. [Link]
2. [Link]
3. [Link]
4. [Link]

Correct Answer: 1. [Link]

48. Which of the following is not a valid method for handling form submissions in a Servlet?

Options:

1. doGet(HttpServletRequest request, HttpServletResponse response)


2. doPost(HttpsServletRequest request, HttpServletResponse response)
3. service(HttpServletRequest request, HttpServletResponse response)
4. init(ServletConfig config)

Correct Answer: 4. init(ServletConfig config)

49. Where is the session object being stored?

Options:

1. Storing session data in client-side cookie


2. Storing session data in server-side
3. Using Javascript to manage Session
4. Embedding session information in the URL

Correct Answer: 2. Storing session data in server-side

50. What is the output of the following block of code:

try {
[Link](10 / 0);
} catch (ArithmeticException e) {
[Link]("Arithmetic Exception caught.");
}

Page 13 of 15
Options:

1. 1 / 10 / 00
2. No output
3. Arithmetic Exception
4. Arithmetic Exception caught.

Correct Answer: 4. Arithmetic Exception caught.

51. Which of the following is a correct way to declare a JavaBean property within a JSP file?

Options:

1. <jsp:useBean id="user" class="[Link]"/>


2. <jsp:property id="user" name="[Link]" />
3. <jsp:bean id="user" scope="session" class="[Link]"/>
4. <jsp:property id="user" value="new [Link]()" />

Correct Answer: 1. <jsp:useBean id="user" class="[Link]"/>

52. In the below code, what does "[Link](1)" do?

public static void selectData(Connection c, String sql) throws SQLExcepti


Statement stmt = [Link]();
ResultSet rs = [Link](sql);
while ([Link]()) {
[Link]([Link](2));
}
}

Options:

1. Inserts an integer into the first column of the ResultSet


2. Deletes an integer from the first column of the ResultSet
3. Retrieves an integer from the first column of the ResultSet
4. Updates an integer in the first column of the ResultSet

Correct Answer: 3. Retrieves an integer from the first column of the ResultSet

53. Which of these HTTP methods doesn't have a length restriction?

Options:

Page 14 of 15
1. PUT
2. DELETE
3. GET
4. POST

Correct Answer: 4. POST

54. Which collection does not allow duplicate elements?

Options:

1. set
2. list
3. map
4. All of the above

Correct Answer: 1. set

55. The process of handling unexpected conditions that arise during program execution is called:

Options:

1. Exception Handling
2. Error Handling
3. Code Verification
4. Debugging

Correct Answer: 1. Exception Handling

Page 15 of 15

You might also like