What will the COMMIT accomplish?

Answers were Sorted based on User's Feedback



What will the COMMIT accomplish?..

Answer / jdriley

It will make the edits you made to the tables using INSERT,
UPDATE, and DELETE permanent.

Is This Answer Correct ?    2 Yes 0 No

What will the COMMIT accomplish?..

Answer / abhisek

COMMIT will save/commit the changes made to a database
while INSERT, DELETE and UPDATE operations.

Is This Answer Correct ?    1 Yes 0 No

What will the COMMIT accomplish?..

Answer / as

Commit will clear the content of DB2 buffers.

This point comes to use when you are updating huge nbr of
records without using commit. If the buffer become full
before you commit, then it will cause problem.

Is This Answer Correct ?    1 Yes 0 No

What will the COMMIT accomplish?..

Answer / s

COMMIT will write the updates out to DASD.

Is This Answer Correct ?    0 Yes 0 No

What will the COMMIT accomplish?..

Answer / urta

issuing the command "commit" means u have saved the
transaction..

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB2 Interview Questions

how do you resolve -805?

3 Answers   HCL,


What is the use of DELGEN in DB2? Can we Write the program with out using it?

6 Answers   Cap Gemini,


How to resolve deadlock issue

5 Answers   IBM,


what's the error code for Unique Index Violation?

2 Answers  


What are db2 error codes -305 and -407. What is the difference between these 2 error codes ?

1 Answers  






What is Call attach facility? How does it work?

1 Answers   Syntel,


How does the processing of a correlated subquery differ from a non correlated subquery?

1 Answers  


what needs to be done if a table is in copy pending / check pending status?

5 Answers   Xansa,


Why db2 is called db2?

0 Answers  


How do I connect my db2 database to ibm?

0 Answers  


in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,


how to delete perticular row from table for ex. how you will delete 3rd row from table please answer THANKS IN ADVANCE

10 Answers   IBM,


Categories