JDBC INTERVIEW QUESTIONS
1) What is the JDBC? Java Database Connectivity ( JDBC ) is a standard Java API to interact with relational databases form Java. The JDBC driver gives out the connection to the database and implements the protocol for transferring the query and result between client and database. 2) Explain Basic Steps in writing a Java program using JDBC? JDBC makes the interaction with RDBMS simple and intuitive. When a Java application needs to access database : Load the RDBMS specific JDBC driver because this driver actually communicates with the database (Incase of JDBC 4.0 this is automatically loaded). Open the connection to database which is then used to send SQL statements and get results back. Create JDBC Statement object. This object contains SQL query. Execute statement which returns resultset(s). ResultSet contains the tuples of database table as a result of SQL query. Process the result set. Close the connection. For detailed Answer r...