GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Tech FAQs  >  Oracle

 Print  |  
Question:  When we commit a transaction what sort of things happen in the oracle server ?



March 03, 2009 04:29:52 #3
 vijaydeep   Member Since: February 2009    Total Comments: 2 

RE: When we commit a transaction what sort of things happen in the oracle server ?
 
Ends the current transaction by making all pending data changes permanent.
Is the simplest way to define.
Transaction means start with an DML SQL Statement and end with one of the following 
1) A commit or rollback statement is issued, or
2) DML OR DCL Statement executes (AUTO COMMIT) or
3) The System crashes.
     

 

Back To Question