1.

Explain How The Auto Commit Property Works In Pb?

Answer»

When the Auto Commit property is set to FALSE (default) or 0, PB issues SQL statements inside the scope of a transaction. 1(TRUE) implies statements outside the scope of a transaction (for example when your application requires creating TEMPORARY TABLES).

  • If you want to execute STORED procedures containing DDL (CREATE, ALTER, DROP etc) statements, then Auto Commit = TRUE.
  • If Auto Commit = TRUE, then rollback cannot be issued, it should be set to FALSE after completing the DDL operation.

When Auto Commit is set from FALSE to TRUE, then PB issues a COMMIT STATEMENT by default.

When the Auto Commit property is set to FALSE (default) or 0, PB issues SQL statements inside the scope of a transaction. 1(TRUE) implies statements outside the scope of a transaction (for example when your application requires creating temporary tables).

When Auto Commit is set from FALSE to TRUE, then PB issues a COMMIT statement by default.


Discussion

No Comment Found

Related InterviewSolutions