Home | Submit an interview question | Filter by category | Filter by job function | Filter by company
 
Member Information
User Id
Password
 
Forgot Password
Technology Category
.NET (1202)
Languages (103)
Database (146)
Operating System (48)
Reporting (5)
Third-Party Tools (2)
Testing (91)
OOP (75)
Web Development (40)
Design Patterns (89)
General (9)
Networking (88)
Hardware (63)
Brain Exercise (2)
Others (37)
 Our Network
.NET Heaven
C# Corner
Interview Corner
Longhorn Corner
Mindcracker
VB.NET Heaven
Home » Database » Database
What does COMMIT do ?
Posted by Pradeep Sep 14, 2009
Viewed : 401 times
Major Category : Database
Minor Category : Oracle
Total Replies : 2
Become a Sponsor
 EDITORIAL ANSWER  
No Reply Yet
 ANSWERS BY USERS  
Asad Butt
Sep 14, 2009
Commit basically refers to an action which makes all the changes permanant since the last commit.
commit is alos availabale for non-Sql transanctions, like a method  available with Installer class which finalises
installation after all installation steps have been carried out successfully

public override void Commit(System.Collections.IDictionary savedState)
{
    base.Commit(savedState);
}

so commit simplly is a mechanism to finalise what you have done and make changes permanant

Sapna Malik
Sep 14, 2009
COMMIT makes permanent the changes resulting from all SQL statements in the transaction. The changes made by the SQL statements of a transaction become visible to other user sessions transactions that start only after transaction is committed. 
  
1

 

 Hosted by MaximumASP  |  Found a broken link?  |  Contact Us  |  Terms & conditions  |  Privacy Policy  |  Advertise with us
Current Version: 2.2009.3.2
 © 1999 - 2009  Mindcracker LLC. All Rights Reserved