Time remaining
:
:
Test Status
JDBCTEST4
Ques 1 :
Which type of JDBC driver is the fastest one?
(A) Type-1 driver
(B) Type-2 driver
(C) Type-3 driver
(D) Type-4 driver
Ques 2 :
Is JDBC support Named Param?
(A) Yes
(B) No
Ques 3 :
By default "auto commit" option is -
(A) true
(B) false
Ques 4 :
Which one is correct Driver class name for Type-1 driver?
(A) Class.forName("sun.jdbc.odbc.JdbcOdbcDriver")
(B) Class.forName("sun.odbc.jdbc.JdbcOdbcDriver")
(C) Class.forName("sun.jdbc.odbc.OdbcJdbcDriver")
(D) Class.forName("sun.odbc.jdbc.OdbcJdbcDriver")
Ques 5 :
Which statement is correct?
(A) ResultSet rs = stmt.selectQuery("SELECT COF_NAME, PRICE FROM COFFEES");
(B) ResultSet rs = stmt.executeSelect("SELECT COF_NAME, PRICE FROM COFFEES");
(C) ResultSet rs = stmt.runQuery("SELECT COF_NAME, PRICE FROM COFFEES");
(D) ResultSet rs = stmt.executeQuery("SELECT COF_NAME, PRICE FROM COFFEES");
Ques 6 :
rollback( ) methods belongs to-
(A) Statement
(B) Connection
(C) ResultSet
(D) none of these
Ques 7 :
Which driver is suitable when application is accessing multiple types of databases at the same time?
(A) Type-1 driver
(B) Type-2 driver
(C) Type-3 driver
(D) Type-4 driver
Ques 8 :
Which type of JDBC driver is the fastest one?
(A) Type-1 driver
(B) Type-2 driver
(C) Type-3 driver
(D) Type-4 driver
Ques 9 :
How do you call the stored procedure in JDBC?
(A) CallableStatement cs = con.prepareCall("{call SHOW_SUPPLIERS}");
(B) CallableStatement cs = con.makeCall("{call SHOW_SUPPLIERS}");
(C) CallableStatement cs = con.preparedCall("{call SHOW_SUPPLIERS}");
(D) CallableStatement cs = con.createCall("{call SHOW_SUPPLIERS}");
Ques 10 :
We can get the column names using?
(A) ResultSetColumnData
(B) ResultSetMetaData
(C) ResultSetHeaderData
(D) ResultSetTableData
Ques 11 :
Which package we need to import to work with JDBC?
(A) import java.sql.* ;
(B) import javax.sql.* ;
(C) import java.jdbc.sql.* ;
(D) import java.jdbc.* ;
Ques 12 :
SELECT, INSERT, DELETE, UPDATE, COMMIT and ROLLBACK comes under ?
(A) DML
(B) DDL
Ques 13 :
Which one the type of RowSet?
(A) Connected
(B) Disconnected
(C) Both A and B
(D) none of these
Ques 14 :
The return type of execute(String query) is?
(A) int
(B) ResultSet
(C) boolean
(D) void
Ques 15 :
Which interface is responsible for transaction management in JDBC?
(A) TransactionManagement
(B) Connection
(C) ResultSet
(D) PreparedStatement
Ques 16 :
Which is not a Isolation level in JDBC?
(A) TRANSACTION_READ_UNCOMMITTED
(B) TRANSACTION_READ_COMMITTED
(C) TRANSACTION_REPEATABLE_READ
(D) TRANSACTION_NONE_COMMITTED
Ques 17 :
"No suitable driver" error message is coming during-
(A) DriverManager.getConnection()
(B) Class.forName();
(C) stmt.executeQuery();
(D) none of these
Ques 18 :
RowSet is belong to which package?
(A) java.sql
(B) javax.sql
(C) java.jdbc
(D) javax.jdbc
Ques 19 :
RowSet objects are having all the features of ResultSet-
(A) Yes
(B) No
Ques 20 :
We can get the Database details using?
(A) DatabaseDetails
(B) DatabaseServerData
(C) DatabaseRawData
(D) DatabaseMetaData
Submit Answer
Don't Refresh the Page !! ...