Time remaining
:
:
Test Status
JDBCRANDOMTEST
Ques 1 :
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()
Ques 2 :
Which JDBC driver Type(s) can be used in either applet or servlet code?
(A) Both Type 1 and Type 2
(B) Both Type 3 and Type 4
(C) Both Type 1 and Type 3
(D) Type 4 only
Ques 3 :
To execute a stored procedure â??totalStockâ?? in a database server, which of the following code snippet is used?
(A) CallableStatement clbstmnt = con.prepareCall("{call totalStock}");cs.executeQuery();
(B) Statement stmt = connection.createStatement();stmt.execute("totalStock()");
(C) StoreProcedureStatement spstmt = connection.createStoreProcedure("totalStock()");spstmt.executeQuery();
(D) PrepareStatement pstmt = connection.prepareStatement("totalStock()");pstmt.execute();
Ques 4 :
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
(A) Type 1
(B) Type 2
(C) Type 3
(D) Type 4
Ques 5 :
JDBC-ODBC Bridge is platform independent driver.
(A) False
(B) True
Ques 6 :
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
(A) Type 1 only
(B) Type 2 only
(C) Both Type 3 and Type 4
(D) All of Type 1, Type 2, Type 3 and Type 4
Ques 7 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
(A) False
(B) True
Ques 8 :
Type-2 driver called-
(A) Native-protocol, pure Java driver
(B) JDBC-Net, pure Java driver
(C) Native-API, partly Java driver
(D) JDBC-ODBC Bridge plus ODBC driver
Ques 9 :
State true or false . Does the JDBC-ODBC Bridge support multiple concurrent open statements per connection?
(A) False
(B) True
Ques 10 :
what is jdbc ?
(A) a
(B) b
(C) c
(D) d
Ques 11 :
State true or false :- The JDBC-ODBC bridge from Sun's Java Software does not provide network access to desktop databases like Microsoft access by itself.
(A) True
(B) False
Ques 12 :
How many types of Statement in JDBC
(A) 2
(B) 3
(C) 4
(D) 5
Ques 13 :
The JDBC-ODBC Bridge supports multiple concurrent open statements per connection?
(A) False
(B) True
Ques 14 :
Which JDBC driver Type(s) can you use in a three-tier architecture and if the Web server and the DBMS are running on the same machine?
(A) Type 1 only
(B) Type 2 only
(C) Both Type 3 and Type 4
(D) All of Type 1, Type 2, Type 3 and Type 4
Ques 15 :
Which of the following statement is false regarding the use of setAutoCommit() in JDBC
(A) When a connection is created, it is in auto-commit mode.
(B) If the value is true each individual SQL statement is treated as a transaction and will be automatically committed right after it is executed.
(C) once auto-commit mode is disabled, no SQL statements will be committed until you call the method commit explicitly
(D) By default the JDBC call is in auto-commit mode.
Ques 16 :
Which of the following statements is false as far as different type of statements is concern in JDBC?
(A) Regular Statement
(B) Interim Statement
(C) Callable Statement
(D) Prepared Statement
Ques 17 :
Can we update a resultset programmatically?
(A) No
(B) Yes
Ques 18 :
State true or false :- ResultSet.CONCUR_UPDATABLE used with the result set is used to update the rows directly in the database.
(A) True
(B) False
Ques 19 :
Which method is used to find the number of column in ResultSet?
(A) getNumberOfColumn
(B) getMaxColumn
(C) getColumnCount
(D) getColumns
Ques 20 :
Which isolation level prevents dirty read in JDBC, connection class.
(A) TRANSACTION_READ_ COMMITTED
(B) TRANSACTION_UNREAD_ COMMITTED
Submit Answer
Don't Refresh the Page !! ...