Interested to Buy Any Domain ? << Click Here >> for more details...
When do you specify the isolation level? How?
- 1 Answers
- 5063 Views
- I also Faced
- E-Mail Answers
Answer / s
Isolation level can be specified at BIND time using the
ISOLATION parameter or in the SQL statement using the WITH
clause
WITH UR;
| Is This Answer Correct ? | 5 Yes | 0 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?
Explain in detail about buffer manager and its functionalities?
Explain about rct in db2?
What is cursor stability?
What does sqlcabc has?
What is filter factor?
What are the two types of logging in the db2 database? Explain them.
Mention and explain the contention situations caused by locks?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
What is a thread?
What is the difference between using bind () and rebind () methods of naming class?
Q4. How will you get the count of record without using COUNT verb in query?
COBOL 
