Search your topic in Java2share
Servlets & JSP
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?