Important JDBC Interview Questions

Important JDBC Interview Questions:

• 1: What is the difference between Database and Database management system?
• 2: How a query could be executed when we send a query to Database?
• 3: What is Driver? How many Drivers are available in JDBC? What are the types?
• 4: What is JDBC and What are the steps to write a JDBC application?
• 5: How to load a JDBC driver?
• 6: How to establish a Database connection between java application and Database?
• 7: Basically Connection is an interface, how getConnection() will create an object for Connection interface?
• 8: What is the requirement to use Statement object?
• 9: How to execute SQL Queries from a java application?
• 10: What are the differences between executeQuery(…), executeUpdate(…) and execute(…) methods?
• 11: How to create a table dynamically from a jdbc application?.
• 12: How to insert records into a table from a JDBC application?
• 13: How to update a table from a jdbc application?.
• 14: How to delete records from a table from jdbc application?.
• 15:What is ment by ResultSet object and How to Fetch the Data from Database?.
• 16:Ingeneral execute() method can be used to execute selection group SQl queries for getting the data from Database , but execute() return a boolean value true so here how it possible to fetch the data from database?
• 17:Ingeneral execute() method can be used to execute updatation group SQl queries for updating the data on Database , but execute() return a boolean value false so here how it possible to get the records updated count value(int value)?
• 18: If we use selection group SQL query to executeUpdate() ,what happened?
• 19: If we use updatation group SQL query to executeQuery() ,what happened?
• 20: What is ment by ResultSet and What are the types of ResultSets are available in JDBC application?
• 21: What is the difference between ScrollSensitive ResultSet and ScrollInsensitive ResultSets?
• 22: What is the default ResultSet type in JDBC application and How it is possible to create a specific type of ResultSet object?
• 23: How to iterate the data from Scrollable ResultSet objuect in both forward and backword direction?
• 24: How to generate ScrollSensitive Result Set and how to reflect the later updations from database automatically to the ResultSet object?
• 25: How to insert records into Database throws Updatable ResultSet?
• 26: How to perform updations on Database throws Updatable ResultSet?
• 27: What is meant by ResultSetMetaData ?How to get The ResultSet metadata of a ResultSet object?
• 28: How to display the data with the respective field names
• 29: What are the differences between Statement and PreparedStatement? (or) Tell me the situations where we should go for PreparedStatement over Statement object.
• 30: Hhow to insert number of records into a table through Prepared Statement object.
• 31: How to update the database through PreparedStatement object.
• 32: How to fetch the data from database through PreparedStatement object.
• 33: What is meant by Transaction? How it is possible to maintain Transactions in JDBC applications?
• 34: What is meant by SavePoint?How to use Savepoints in JDBC applications?

All The Best For Your Carrier