Question 1

How many types of JDBC drivers are available?

Accepted Answer

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

Question 2

Which result set generally does not show changes to the underlying databasethat are made while it is open. The membership, order, and column values ofrows are typically fixed when the result set is created?

Accepted Answer

A) type_forward_only 
B) type_scroll_insensitive 
C) type_scroll_sensitive 
D) all mentioned above 
A) type_forward_only 
B) type_scroll_insensitive 
C) type_scroll_sensitive 
D) all mentioned above B

Question 3

Which of the following is method of JDBC batch process?

Accepted Answer

A) setbatch() 
B) deletebatch() 
C) removebatch() 
D) addbatch() 
A) setbatch() 
B) deletebatch() 
C) removebatch() 
D) addbatch() D

Question 4

Which driver uses ODBC driver to connect to the database?

Accepted Answer

A) jdbc-odbc bridge driver 
B) native - api driver 
C) network protocol driver 
D) thin driver 
A) jdbc-odbc bridge driver 
B) native - api driver 
C) network protocol driver 
D) thin driver

Question 5

Which attribute is used to specify class name of the bean?

Accepted Answer

A) name 
B) id 
C) class 
D) constructor-args 
A) name 
B) id 
C) class 
D) constructor-args

Question 6

Which interface in spring is responsible for Instantiating and managing the so called Spring beans?

Accepted Answer

A) Bean Factory 
B) ApplicationContext 
C) BeanDefenition. 
D) BeanDefenition 
A) Bean Factory 
B) ApplicationContext 
C) BeanDefenition. 
D) BeanDefenition

Question 7

What does setAutoCommit(false) do?

Accepted Answer

A) commits transweraction after each query 
B) explicitly commits transweraction 
C) does not commit transweraction automatically after each query 
D) never commits transweraction 
A) commits transweraction after each query 
B) explicitly commits transweraction 
C) does not commit transweraction automatically after each query 
D) never commits transweraction

Question 8

Which of the following is advantage of using JDBC connection pool?

Accepted Answer

A) slow performance 
B) using more memory 
C) using less memory 
D) better performance 
A) slow performance 
B) using more memory 
C) using less memory 
D) better performance

Question 9

How many JDBC product components does the Java software provides?

Accepted Answer

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

Question 10

Which of the following contains both date and time?

Accepted Answer

A) java.io.date 
B) java.sql.date 
C) java.util.date 
D) java.util.datetime 
A) java.io.date 
B) java.sql.date 
C) java.util.date 
D) java.util.datetime

Question 11

Purpose of Static Factory Method?

Accepted Answer

A) Static method to create an object 
B) Initialize bean 
C) All of the mentioned 
D) None of the mentioned 
A) Static method to create an object 
B) Initialize bean 
C) All of the mentioned 
D) None of the mentioned

Question 12

What is used to execute parameterized query?

Accepted Answer

A) statement interface 
B) preparedstatement interface 
C) resultset interface 
D) none of the above 
A) statement interface 
B) preparedstatement interface 
C) resultset interface 
D) none of the above

Question 13

JDBC stands for?

Accepted Answer

A) java database connectivity 
B) java database concept 
C) java database communications 
D) none of the above 
A) java database connectivity 
B) java database concept 
C) java database communications 
D) none of the above

Question 14

Which of the following is advantage of using PreparedStatement in Java?

Accepted Answer

A) slow performance 
B) encourages sql injection 
C) prevents sql injection 
D) more memory usage 
A) slow performance 
B) encourages sql injection 
C) prevents sql injection 
D) more memory usage

Question 15

Which of the following statements is false as far as different type of statements is concern in JDBC?

Accepted Answer

A) regular statement 
B) prepared statement 
C) callable statement 
D) interim statement 
A) regular statement 
B) prepared statement 
C) callable statement 
D) interim statement

Question 16

Which of the following methods are needed for loading a database driver in JDBC?

Accepted Answer

A) registerdriver() method 
B) class.forname() 
C) both a and b 
D) getconnection() 
A) registerdriver() method 
B) class.forname() 
C) both a and b 
D) getconnection()

Question 17

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

Accepted Answer

A) prepare statement 
B) prepare call 
C) create statement 
D) none of the above 
A) prepare statement 
B) prepare call 
C) create statement 
D) none of the above

Question 18

Which one of the following contains date information?

Accepted Answer

A) java.sql.timestamp 
B) java.sql.time 
C) java.io.time 
D) java.io.timestamp 
A) java.sql.timestamp 
B) java.sql.time 
C) java.io.time 
D) java.io.timestamp

Question 19

Which of the following is used to call stored procedure?

Accepted Answer

A) statement 
B) preparedstatement 
C) callablestatment 
D) calledstatement 
A) statement 
B) preparedstatement 
C) callablestatment 
D) calledstatement

Question 20

Which of the following is used to rollback a JDBC trAnsweraction?

Accepted Answer

A) rollback() 
B) rollforward() 
C) deletetransweraction() 
D) removetransweraction() 
A) rollback() 
B) rollforward() 
C) deletetransweraction() 
D) removetransweraction()

How many types of JDBC drivers are available?

Which result set generally does not show changes to the underlying databasethat are made while it is open. The membership, order, and column values ofrows are typically fixed when the result set is created?

Which of the following is method of JDBC batch process?

Which driver uses ODBC driver to connect to the database?

Which attribute is used to specify class name of the bean?

Which interface in spring is responsible for Instantiating and managing the so called Spring beans?

What does setAutoCommit(false) do?

Which of the following is advantage of using JDBC connection pool?

How many JDBC product components does the Java software provides?

Which of the following contains both date and time?

Purpose of Static Factory Method?

What is used to execute parameterized query?

JDBC stands for?

Which of the following is advantage of using PreparedStatement in Java?

Which of the following statements is false as far as different type of statements is concern in JDBC?

Which of the following methods are needed for loading a database driver in JDBC?

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

Which one of the following contains date information?

Which of the following is used to call stored procedure?

Which of the following is used to rollback a JDBC trAnsweraction?

Networking and JDBC

JDBC, Servlets, and Cookies

Servlets and Session Tracking

Web Development and JSP

Web Development With Java Frameworks and Libraries

JDBC and Networking

Java Web Development: Methods, Variables, and Technologies

JSP, Threading, and RMI

Filters

Exam 6: JDBC and Spring Framework

How many types of JDBC drivers are available?

Which result set generally does not show changes to the underlying databasethat are made while it is open. The membership, order, and column values ofrows are typically fixed when the result set is created?

Which of the following is method of JDBC batch process?

Which driver uses ODBC driver to connect to the database?

Which attribute is used to specify class name of the bean?

Which interface in spring is responsible for Instantiating and managing the so called Spring beans?

What does setAutoCommit(false) do?

Which of the following is advantage of using JDBC connection pool?

How many JDBC product components does the Java software provides?

Which of the following contains both date and time?

Purpose of Static Factory Method?

What is used to execute parameterized query?

JDBC stands for?

Which of the following is advantage of using PreparedStatement in Java?

Which of the following statements is false as far as different type of statements is concern in JDBC?

Which of the following methods are needed for loading a database driver in JDBC?

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

Which one of the following contains date information?

Which of the following is used to call stored procedure?

Which of the following is used to rollback a JDBC trAnsweraction?

Networking and JDBC

JDBC, Servlets, and Cookies

Servlets and Session Tracking

Web Development and JSP

Web Development With Java Frameworks and Libraries

JDBC and Networking

Java Web Development: Methods, Variables, and Technologies

JSP, Threading, and RMI

Filters