What is a lock?
Answer / s
Lock is a DB2 structure used to ensure data integrity when
applications, utilities, commands are all accessing the
same data.
| Is This Answer Correct ? | 2 Yes | 1 No |
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
Q4. How will you get the count of record without using COUNT verb in query?
What is concurrency in db2?
What is lock contention?
can you use symbolic parameters in JOB?
What is a bind in db2?
What are the functions of Bind?
What's The Percentage Free Space ?
How does DB2 use multiple table indexes?
What is CHECK PENDING ?
Can you tell me how can you find out the # of rows updated after an update statement?
What is dbrm? What it contains?