Deck 2: JDBC, Servlets, and Cookies

Question 1

How many Result sets available with the JDBC 2.0 core API?

A)2
B)3
C)4
D)5

Answer 1

3

Question 2

Which method is used to establish the connection with the specified url in a Driver Manager class?

A)public static void registerDriver(Driver driver)
B)public static void deregisterDriver(Driver driver)
C)public static Connection getConnection(String url)
D)public static Connection getConnection(String url,String userName,String password)

Answer 2

public static Connection getConnection(String url)

Question 3

Which driver Network connection is indirect that a JDBC client makes to a middleware process that acts as a bridge to the DBMS server?

A)JDBC-Net
B)JDBC-ODBC bridge
C)Native API as basis
D)Native protocol as basis

Answer 3

JDBC-Net

Question 4

JDBC RowSet is the wrapper of ResultSet,It holds tabular data like ResultSet but it is easy and flexible to use.

Question 5

The ResultSet.next method is used to move to the next row of the ResultSet, making it the current row.

Question 6

Which JDBC product components does the Java software provide?

A)The JDBC driver manager
B)The JDBC driver test suite
C)The JDBC-ODBC bridge
D)All mentioned above

Question 7

Which class has traditionally been the backbone of the JDBC architecture?

A)the JDBC driver manager
B)the JDBC driver test suite
C)the JDBC-ODBC bridge
D)All mentioned above

Question 8

Which was the first most widely used programming interface for accessing relational databases and it offers the ability to connect all the databases on all the platforms.?

A)JDBC API
B)ODBC API
C)Both A & B
D)None of the above

Question 9

JDBC is a Java API that is used to connect and execute query to the database

Question 10

In the following JDBC drivers which is known as fully java driver?

A)Native-API driver
B)Network Protocol driver
C)Thin driver
D)Both B & C

Question 11

Which JDBC drivers will run your program?

A)The JDBC-ODBC bridge
B)The JDBC driver manager
C)The JDBC driver test suite
D)None of the above

Question 12

What is the reason that a java program cannot directly communicate with an ODBC driver?

A)ODBC written in C# language
B)ODBC written in C language
C)ODBC written in C++ language
D)None of the above

Question 13

A leading database connectivity vendor, worked together to produce the ____.

A)JDBC-ODBC Bridge
B)JDBC Driver Test Suite
C)Both A & B
D)None of the above

Question 14

Which driver converts JDBC calls directly into the vendor-specific database protocol?

A)Native - API driver
B)Network Protocol driver
C)Thin driver
D)Both B & C

Question 15

Which models do the JDBC API support for the database access?

A)Two-tier models
B)Three-tier models
C)Both A & B
D)None of the above

Question 16

Which of the following JDBC drivers is known as a partially java driver?

A)JDBC-ODBC bridge driver
B)Native-API driver
C)Network Protocol driver
D)Thin driver

Question 17

The JDBC API is what allows access to a data source from a Java middle tier

Question 18

Which driver uses ODBC driver to connect to the database?

A)JDBC-ODBC bridge driver
B)Native - API driver
C)Network Protocol driver
D)Thin driver

Question 19

How many JDBC product components does the Java software provides?

A)3
B)2
C)4
D)5

Question 20

How many types of JDBC drivers are available?

A)3
B)4
C)2
D)5

Question 21

Which method is used for an SQL statement that is executed frequently?

A)prepareStatement
B)prepareCall
C)createStatement
D)None of the above

Question 22

How is the dynamic interception of requests and responses to transform the information done?

A)servlet container
B)servlet config
C)servlet context
D)servlet filter

Question 23

Which type of ServletEngine is a server that includes built-in support for servlets?

A)Add-on ServletEngin
B)Embedded ServletEngine
C)Standalone ServletEngine
D)None of the above

Question 24

What type of servlets use these methods doGet(), doPost(),doHead, doDelete(), doTrace()?

A)Genereic Servlets
B)HttpServlets
C)All of the above
D)None of the above

Question 25

Which cookie it is valid for single session only and it is removed each time when the user closes the browser?

A)Persistent cookie
B)Non-persistent cookie
C)All the above
D)None of the above