JDBC Quiz, JDBC Online Test, JDBC certifcation test

Online JDBC quiz with 20 questions for JDBC ehtusiasts with some sample questions. This online test helps you prepare for upcoming interviews, certification tests and other entrance exams. The score displayed at the end of JDBC test helps you assess your level of preparation.

Online Practice Test > JDBC quiz

Click here to start JDBC practice quiz/test
Here are few sample JDBC test/quiz questions

Which of the following methods are needed for loading a database driver in JDBC?

registerDriver() method
Class.forName()
Both A and B
getConnection()

To execute a stored procedure “totalStock” in a database server, which of the following code snippet is used?

Statement stmt = connection.createStatement();stmt.execute("totalStock()");
CallableStatement clbstmnt = con.prepareCall("{call totalStock}");cs.executeQuery();
StoreProcedureStatement spstmt = connection.createStoreProcedure("totalStock()");spstmt.executeQuery();
PrepareStatement pstmt = connection.prepareStatement("totalStock()");pstmt.execute();

Which of the following methods finds the maximum number of connections that a specific driver can obtain?

Database.getMaxConnections
Connection.getMaxConnections
DatabaseMetaData.getMaxConnections
ResultSetMetaData.getMaxConnections 

Click here to start JDBC practice quiz/test 

More Links

What is optimistic concurrency control?

In optimistic concurrency control, locks are granted without performing conflict checks. In this, a track of files which have been read or written is maintained............. 

What is pessimistic concurrency?

In this approach, each transaction is assigned a timestamp. One can make sure that they are unique using algorithms like Lamport. ............



Write your comment - Share Knowledge and Experience

Discussion Board
JDBC Quiz, JDBC Online Test, JDBC certifcation test

What is the disadvantage of Type-4 Native-Protocol Driver?

At client side, a separate driver is needed for each database.
Type-4 driver is entirely written in Java
The driver converts JDBC calls into vendor-specific database protocol
It does not support to read MySQL data.


JDBC Quiz, JDBC Online Test 05-10-2012 06:38 AM

JDBC Quiz, JDBC Online Test, JDBC certifcation test

Which of the following methods finds the maximum number of connections that a specific driver can obtain?

Database.getMaxConnections
Connection.getMaxConnections
DatabaseMetaData.getMaxConnections
ResultSetMetaData.getMaxConnections


JDBC Quiz, JDBC Online Test 05-10-2012 06:38 AM

JDBC Quiz, JDBC Online Test, JDBC certifcation test

Which of the following is false as far as type 4 driver is concern?

Type 4 driver is “native protocol, pure java” driver
Type 4 drivers are 100% Java compatible
Type 4 drivers uses Socket class to connect to the database
Type 4 drivers can not be used with Netscape


JDBC Quiz, JDBC Online Test 05-10-2012 06:38 AM

JDBC Quiz, JDBC Online Test, JDBC certifcation test

Which of the following statements is false as far as different type of statements is concern in JDBC?

Regular Statement
Prepared Statement
Callable Statement
Interim Statement


JDBC Quiz, JDBC Online Test 05-10-2012 06:38 AM

More online test

Oracle Transaction Online
Testing online test
Testing sample questions
Software Testing Quiz
PMP Sample Test
Software Engineering Test
PHP Online Test
DHTML Online Test
Networking Test
Iphone Test
Android Quiz
Wireless Communication Test


Career 12-20-2011 03:04 AM

 


Latest MCQs
» General awareness - Banking » ASP.NET » PL/SQL » Mechanical Engineering
» IAS Prelims GS » Java » Programming Language » Electrical Engineering
» English » C++ » Software Engineering » Electronic Engineering
» Quantitative Aptitude » Oracle » English » Finance
Home | About us | Sitemap | Contact us | We are hiring