Results 1 to 3 of 3

Thread: Db

  1. #1
    Junior Member
    Join Date
    Jul 2007
    Answers
    1

    Db

    hai...
    The Technical difference between rollback and commit?


  2. #2

    Re: Db

    http://www.geekinterview.com/question_details/35092

    Please See the Link which will help u to know about the Diff. between Rollback and Commit.

    According to me--
    Rollback:- From the Start of the Transaction till the end there may be multiple update Insert etc.. Operations to be performed on Several Tables. And if one of the operation in between the transaction fails , the whole transaction performed with current transaction will be cancelled. this type is required when a change in one table affects several other tables record.

    Commit:-Commit is reverse of the Rollback. This will make the actual changes in the table if all the operations specified in the transaction are executed successfully. if not so, it rollbacks all the changes for that transaction.

    if you find any suggesstion for my reply reply to me....

    thanks..


  3. #3
    Junior Member
    Join Date
    Sep 2005
    Answers
    2

    Re: Db

    Rollback will cancel all the DML operation done earlier. Commit will make the changes permenant.

    If any DDL operation is done, Commit will automatically done.


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact