Interested to Buy Any Domain ? << Click Here >> for more details...
which SQL comment successfully removes uncommitted changes
from a DB2 database
A) rollback
B) delete
C) drop
D) decommit
- 2 Answers
- 12926 Views
- Accenture, Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
Explain in brief how does db2 determine what lock-size to use?
Can you define an Index if the table size less than 10 PAGES?
What is meant by isolation level?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
How to handle null values in db2
How many Buffer pools are there in DB2 and what are they?
What is buffrpool? Where we use it ?
what are the bind parameters?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
What is the use of runstats in db2?
what is difference between random and sequence file access
COBOL 
