Java2Share | SCJP | SCWCD | Syllabus | Exam Pattern | Question Bank | Tutorials | eBooks | SCJP Communities | Certification

Search your topic in Java2share

Home > FAQs

Sample Programs

IEEE Projects

Java Projects

Sample Resumes

Fresher Jobs


	JDBC FAQs 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?