1600 PMP mock questions 1400 CAPM mock questions 800 SCJP 6 mock questions 600 OCAJP 7 mock questions 590 OCPJP 7 mock questions 556 SCWCD 5 mock questions 500 OCEJWCD 6 mock questions pdfDownload (java,struts, hibernet etc)

JDBC interview questions

  • Image upload from JSP to DataBase ? view answer
  • How to Upload Image into Data Base ? view answer
  • Q. What is Rowset ? CachedRowSet,JDBCRowSet and WebRowSet ? view answer
  • Q. What is Batch Updates Using Statements in JDBC ? view answer
  • Q.Handling Blob and CLOB data using JDBC ? Insert CLOB and Retrive CLOB , Convert into String ? view answer
  • Q. Calling Stored procedures with Callable Statement ? view answer
  • Q.What is JDBC ? Explain Types Of Drivers with Advantage and Disadvantage ? view answer
  • Q. How java retrive the result returns from stored procedure ? view answer
  • Q.How to retrive the results in java returned by refcursor in Stored procedure ? view answer
  • Q.Reading an Oracle ARRAY from a stored procedure as an out ? view answer
  • What is Metadata and why should I use it? view answer
  • How Class.forName() load the Driver and DriverManager.getConnection() return connection? view answer
  • What will Class.forName do while loading drivers? view answer
  • How to Determining If a Result Set Is Scrollable? view answer
  • How Getting the Number of Rows in a Table Using a Scrollable Result Set? view answer
  • What is Scrollable Result Set ? view answer
  • What does setAutoCommit do? view answer
  • What is the difference between TYPE_SCROLL_INSENSITIVE , and TYPE_SCROLL_SENSITIVE? view answer
  • How to Make Updates to Updatable Result Sets? view answer
  • How can you move the cursor in scrollable result sets? view answer
  • What are the different types of Statements with Example? view answer
  • How can you retrieve data from the ResultSet? view answer
  • How can you create JDBC statements and what are they? view answer
  • How can you make the connection? view answer
  • What will Class.forName do while loading drivers? view answer
  • How can you load the drivers? view answer
  • What is PreparedStatement ? view answer
  • what is rowset? and how does it differ from resultset ? view answer
  • How to find total column from a resultset? view answer
  • What is the fastest type of JDBC driver? view answer
  • What are the different JDB drivers available? view answer
  • Q.What are collection pools? What are the advantages? view answer
  • Q.What are different types of Transaction Isolation Levels? view answer
  • Q. What is Dirty read? view answer
  • Q.Difference between Statement , PreparedStatement and CallableStatement ? view answer
  • Q.What is the advantage of using PreparedStatement? view answer
  • Q.What is Single-Phase Commit ? view answer
  • Q.What is two-phase commit? view answer
  • Q. How JDBC work with REF CURSOR returned by stored procedure and retrive results? view answer
  • Q. How do i get result return from stored procedure in JDBC? view answer
  • Q.How do you call a Stored Procedure from JDBC? view answer
  • Q.How do you handle your own transaction ? view answer
  • Q.What are the steps in the JDBC connection? view answer

!!! JDBC interview questions !!!

Q.What is two-phase commit?



When a transaction involves multiple distributed resources, for example, a database server on each of two different network hosts, the commit process is somewhat complex because the transaction includes operations that span two distinct software systems, each with its own resource manager, log records, and so on. (In this case, the distributed resources are the database servers.)

Two-phase commit is a transaction protocol designed for the complications that arise with distributed resource managers. With a two-phase commit protocol, the distributed transaction manager employs a coordinator to manage the individual resource managers.

Configuring Two-Phase Commit Engine:
When a global transaction involves multiple databases, the changes to these resources must all be committed or rolled back at the same time. That is, when the transaction ends, the transaction manager contacts a coordinator--also known as a two-phase commit engine--to either commit or roll back all changes to all included databases. The two-phase commit engine is an Oracle9i database that is configured with the following:

Fully-qualified database links from itself to each of the databases involved in the transaction. When the transaction ends, the two-phase commit engine communicates with the included databases over their fully-qualified database links.

A user that is designated to create sessions to each database involved and is given the responsibility of performing the commit or rollback. The user that performs the communication must be created on all involved databases and be given the appropriate privileges.

Reviews and Comments


PMP, CAPM, PMI is a registered certification mark of the Project Management Institute, Inc

Copyright © www.techfaq360.com 2016


About US | Contact US | Privacy Policy | Terms and Conditions  | Website disclaimer  | Cancellation and Refund Policy  | Shipping & Delivery Policy