Wednesday, 15 February 2012

What are the common tasks of JDBC? | Java JDBC


1.Create an instance of a JDBC driver or load JDBC drivers through jdbc.drivers;
2. Register a driver;
3. Specify a database;
4. Open a database connection;
5. Submit a query;
6. Receive results.

What are stored procedures? | Java JDBC


A stored procedure is a set of statements/commands which reside in the database. The stored procedure is precompiled. Each Database has its own stored procedure language.

What is JDBC Driver interface? | Java JDBC


 The JDBC Driver interface provides vendor-specific implementations of the abstract classes provided by the JDBC API. Each vendors driver must provide implementations of the java.sql.Connection,Statement,PreparedStatement, CallableStatement, ResultSet and Driver.

What are the two major components of JDBC? | Java JDBC


One implementation interface for database manufacturers, the other implementation interface for application and applet writers.

What is JDBC? | Java JDBC


JDBC technology is an API (included in both J2SE and J2EE releases) that provides cross-DBMS connectivity to a wide range of SQL databases and access to other tabular data sources, such as spreadsheets or flat files. With a JDBC technology-enabled driver, you can connect all corporate data even in a heterogeneous environment

33 TOP Java JDBC Interview Questions and Answers for pdf free download

JDBC Interview question forms one of the important section in Java Interviews
1. What is JDBC?
2. What are the two major components of JDBC?
3. What is JDBC Driver interface?
4. What are stored procedures?
5. What are the common tasks of JDBC?
6. What packages are used by JDBC?
7. What are the flow statements of JDBC?
8. What is JDBC Driver?
9. What are the steps required to execute a query in JDBC?
10. What are the steps involved in establishing a connection using JDBC in JAVA?
11. What is Driver Manager?
12. How can you load the drivers in JDBC?
13. What is a ResultSet?
14. What is Connection?
15. What does Class.forName return?
16. What is Connection pooling?
17. What are the different JDB drivers available?
18. What is the fastest type of JDBC driver?
19. Is the JDBC-ODBC Bridge multi-threaded?
20. What is cold backup, hot backup, warm backup recovery?
21. What is the advantage of denormalization?
22. How do you handle your own transaction?
23. What Class.forName will do while loading drivers of JDBC?
24. How can you make the connection using JDBC?
25. How can you create JDBC statements?
26. How can you retrieve data from the ResultSet using JDBC?
27. What are the different types of Statements in JDBC?
28. How can you use PreparedStatement in JDBC?
29. How to call a Stored Procedure from JDBC?
30. How to Retrieve Warnings in JDBC?
31. How to Make Updates to Updatable Result Sets in JDBC?
32. What is Serialization and deserialization in JAVA Programming?
33. How you restrict a user to cut and paste from the html page using JAVA Programing?

Tuesday, 14 February 2012

How will you initialize an Applet? | Java Applets

Write my initialization code in the applets mit method or applet constructor.