Time remaining
:
:
Test Status
JDBCTEST3
Ques 1 :
Which one not a JDBC interface?
(A) Connection
(B) Statement
(C) DriverManager
(D) ResultSet
Ques 2 :
Which one not a JDBC class?
(A) DriverManager
(B) Blob
(C) Clob
(D) ResultSetMetaData
Ques 3 :
Can we transfer the ResultSet object over the network.
(A) yes
(B) no
Ques 4 :
Which one is incorrect ResultSet types?
(A) ResultSet.TYPE_FORWARD_ONLY
(B) ResultSet.TYPE_SCROLL_INSENSITIVE
(C) ResultSet.TYPE_FORWARD_ONLY_SCROLL_SENSITIVE
(D) ResultSet.TYPE_SCROLL_SENSITIVE
Ques 5 :
setAutoCommit(-) method is belongs to which interface?
(A) ResultSet
(B) Statement
(C) PreparedStatement
(D) Connection
Ques 6 :
What the Class.forName() does?
(A) Established the connection with database
(B) Load the class
(C) Register a driver
(D) none of these
Ques 7 :
Which one is a correct MySql Driver class name?
(A) com.mysql.jdbc.driver.Driver
(B) com.jdbc.mysql.Driver
(C) com.mysql.jdbc.Driver
(D) none of these
Ques 8 :
Which one correct JDBC statements?
(A) Statement
(B) PreparedStatement
(C) CallableStatement
(D) all of above
Ques 9 :
Which Statement is used for calling the stored procedure?
(A) CallableStatement
(B) Statement
(C) PreparedStatement
(D) none of these
Ques 10 :
Which method used to get Database server details?
(A) getDatabaseServerDetials();
(B) getDatabaseProductName();
(C) getDatabaseProductDetils();
(D) getDatabaseDetails();
Ques 11 :
Whic one the first steps in jdbc to make database connectivity?
(A) Register a Driver
(B) Load a Driver
(C) Connect a driver using get connection
(D) none of these
Ques 12 :
Where the stored procedures reside?
(A) In side server memory
(B) In side cache
(C) In side database
(D) In side browser
Ques 13 :
By default cursor pointing to-
(A) Column Header
(B) First Record
(C) Last Record
(D) Middle Record
Ques 14 :
Which one the type of connection pool in JDBC?
(A) Database managed connection pool
(B) Server managed connection pool
(C) both are correct
(D) both are incorrect
Ques 15 :
Which one is the most recommended in JDBC?
(A) PreparedStatement
(B) Statement
(C) none of these
(D) both a and b
Ques 16 :
Which one the suitable for working with Microsoft Access database?
(A) Type-1 driver
(B) Type-2 driver
(C) Type-3 driver
(D) Type-4 driver
Ques 17 :
Can we retrieve a whole row of data at once, instead of calling an individual ResultSet.getXXX method for each column?
(A) yes
(B) no
Ques 18 :
Can we rollback the transaction in JDBC?
(A) yes
(B) no
Ques 19 :
Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
(A) yes
(B) no
Ques 20 :
Which one is the correct syntax for creating a Statement?
(A) Statement stmt = connection.createStatements();
(B) Statement stmt = connection.preparedStatement();
(C) Statement stmt = connection.createStatement();
(D) none of these
Submit Answer
Don't Refresh the Page !! ...