which SQL comment successfully removes uncommitted changes
from a DB2 database
A) rollback
B) delete
C) drop
D) decommit

Answer Posted / jeetu

A. of course

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is reorg?

619


Mention the different locking levels that are available in db2.

647


How and when does the db2 enforces the unique key?

616


What is ibm db2 client?

523


define clustering index.

619






How can record locking be achieved in those DB2 versions which do not support it?

627


Explain about rct in db2?

640


How do I add a column in db2?

596


Define buffer pool.

628


What is the use of runstats in db2?

579


What is the maximum No of rows per page?

628


Explain about open switch business continuity software?

565


How does a cursor work?

558


What is a page in db2?

612


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1628