Time remaining
:
:
Test Status
JDBCRANDOMTEST
Ques 1 :
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 2 :
Which of the following allows non repeatable read in JDBC Connection?
(A) TRANSACTION_READ_COMMITTED
(B) TRANSACTION_READ_UNCOMMITTED
(C) TRANSACTION_REPEATABLE_READ
(D) TRANSACTION_SERIALIZABLE
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 :
Is the JDBC-ODBC Bridge multi-threaded?
(A) NO
(B) Yes
Ques 5 :
How many types of Statement in JDBC
(A) 2
(B) 3
(C) 4
(D) 5
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 :
What is sent to the user via HTTP, invoked using the HTTP protocol on the user's computer, and run on the user's computer as an application?
(A) A Java application
(B) A Java applet
(C) A Java servlet
(D) None of the above is correct.
Ques 8 :
Can we update a resultset programmatically?
(A) No
(B) Yes
Ques 9 :
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 10 :
Which isolation level prevents dirty read in JDBC, connection class.
(A) TRANSACTION_READ_ COMMITTED
(B) TRANSACTION_UNREAD_ COMMITTED
Ques 11 :
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 12 :
Which driver is efficient and always preferable for using JDBC applications?
(A) Type-4
(B) Type-1
(C) Type-2
(D) Type-3
Ques 13 :
How many JDBC driver types does Sun define?
(A) One
(B) Two
(C) Three
(D) Four
Ques 14 :
Which JDBC driver Type(s) is(are) the JDBC-ODBC bridge?
(A) Type 1
(B) Type 2
(C) Type 3
(D) Type 4
Ques 15 :
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 16 :
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 17 :
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 18 :
ResultSet.CONCUR_UPDATABLE used with the result set is used
to update the rows directly in the database.
(A) False
(B) True
Ques 19 :
JDBC-ODBC Bridge is platform independent driver.
(A) False
(B) True
Ques 20 :
Where is metadata stored in MySQL?
(A) In the MySQL database mysql
(B) In the MySQL database metadata
(C) In the MySQL database metasql
(D) In the MySQL database mysql
Submit Answer
Don't Refresh the Page !! ...