Time remaining
:
:
Test Status
JDBCRANDOMTEST
Ques 1 :
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 2 :
Whatâ??s the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE?
(A) Both types of result sets will make changes visible if they are closed and then reopened.
(B) A result set that is TYPE_SCROLL_INSENSITIVE does not reflect changes made while it is still open and one that is TYPE_SCROLL_SENSITIVE does.
(C) You will get a scrollable ResultSet object if you specify one of these ResultSet constants.
(D) A result set that is TYPE_SCROLL_INSENSITIVE makes the result set read only while one that is TYPE_SCROLL_SENSITIVE does not.
Ques 3 :
Which of the following is false as far as type 4 driver is concern?
(A) Type 4 driver is "native protocol, pure java" driver
(B) Type 4 drivers can not be used with Netscape
(C) Type 4 drivers are 100% Java compatible
(D) Type 4 drivers uses Socket class to connect to the database
Ques 4 :
Which of the following describes the correct sequence of the steps involved in making a connection with a database.
1. Loading the driver
2. Process the results.
3. Making the connection with the database.
4. Executing the SQL statements.
(A) 1,2,3,4
(B) 1,3,4,2
(C) 2,1,3,4
(D) 4,1,2,3
Ques 5 :
Which JDBC driver Type(s) can be used in either applet or servlet code?
(A) Both Type 1 and Type 3
(B) Both Type 1 and Type 2
(C) Both Type 3 and Type 4
(D) Type 4 only
Ques 6 :
Which method is used to find the number of column in ResultSet?
(A) getNumberOfColumn
(B) getMaxColumn
(C) getColumnCount
(D) getColumns
Ques 7 :
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 8 :
How many types of Statement in JDBC
(A) 2
(B) 3
(C) 4
(D) 5
Ques 9 :
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 10 :
How many JDBC drivers are there ?
(A) 1
(B) 2
(C) 3
(D) 4
Ques 11 :
If your Java application is accessing multiple types of databases at the same time, which type of driver is the preferred driver.
(A) Type-1
(B) Type-2
(C) Type-3
(D) Type-4
Ques 12 :
How many JDBC driver types does Sun define?
(A) One
(B) Two
(C) Three
(D) Four
Ques 13 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
(A) False
(B) True
Ques 14 :
Which of the following is false regarding the Type 3 JDBC driver
(A) A Type 3 driver is a JDBC-Net pure Java driver
(B) This translates JDBC calls into a database -dependent net protocol.
(C) Vendors of database middleware products can implement this type of driver into their products to provide interoperability with the greatest number of database servers.
(D) a,b
Ques 15 :
Is the JDBC-ODBC Bridge multi-threaded?
(A) NO
(B) Yes
Ques 16 :
what is jdbc ?
(A) a
(B) b
(C) c
(D) d
Ques 17 :
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 18 :
What MySQL property is used to create a surrogate key in MySQL?
(A) UNIQUE
(B) AUTO_INCREMENT
(C) SEQUENCE
(D) None of the above -- Surrogate keys are not implemented in MySQL.
Ques 19 :
Which isolation level prevents dirty read in JDBC, connection class.
(A) TRANSACTION_READ_ COMMITTED
(B) TRANSACTION_UNREAD_ COMMITTED
Ques 20 :
Which of the following statements is true regarding the failing of the class.forName in jdk 1.1.x.
(A) A workaround is to explicitly call the method DriverManager.registerDriver(new YourDriverClass).
(B) The problem is due to race condition in the class loader.
(C) The race condition prevents the static section of code in the driver class from executing and registering the driver with the DriverManager.
(D) All the above.
Submit Answer
Don't Refresh the Page !! ...
