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

What is the role of the data page in the db2 database?

0 Answers  


What will the DB2 optimizer do?

2 Answers  


What is phantom read in db2?

0 Answers  


What is the error code -803 ?

3 Answers  


What do you mean by storage group (stogroup)?

0 Answers  






Is ibm db2 free?

0 Answers  


How we create a tables in DB2 ?Previously client has using 7 letters for user id,now he wants to increase the letters from 7 to 12 for user id.How we can do it?

6 Answers   Wipro,


How to handle null values in db2

4 Answers  


what is the use of commit ? and what is the syntax?

2 Answers   Deloitte,


Explain the benefits you can get from mainframe connect?

0 Answers  


How do I import data from excel to db2?

0 Answers  


how can we retrieve the 100 records of the file ?

2 Answers   IBM,


Categories