Deck 6: JDBC and Spring Framework

Question 1

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

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

Answer 1

ApplicationContext

Question 2

Beans can be created by which of the following properties?

A)Scope
B)Property
C)Class
D)It's own constructor

Answer 2

It's own constructor

Question 3

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

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

Answer 3

class

Question 4

Which of the following method can be used to used to instantiate a method?

A)static factory method
B)default-init method
C)destroy method
D)lazy-init method

Question 5

Which attribute is used to specify static factory-method?

A)factory-method
B)default-init method
C)destroy method
D)lazy-init method

Question 6

Purpose of Static Factory Method?

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

Question 7

Which of the following contains both date and time?

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

Question 8

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

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

Question 9

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

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

Question 10

Which one of the following contains date information?

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

Question 11

What does setAutoCommit(false) do?

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

Question 12

Which of the following is used to call stored procedure?

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

Question 13

Which of the following is method of JDBC batch process?

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

Question 14

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

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

Question 15

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 16

How many JDBC product components does the Java software provides?

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

Question 17

How many types of JDBC drivers are available?

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

Question 18

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?

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

Question 19

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

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

Question 20

What is used to execute parameterized query?

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

Question 21

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 22

JDBC stands for?

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

Question 23

Which of the following allows non repeatable read in JDBC Connection?

A)transweraction_read_uncommitted
B)transweraction_read_committed
C)transweraction_serializable
D)transweraction_repeatable_read

Question 24

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

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

Question 25

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

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