What does an outer join do?
Answer / guest
Includes unmatched rows from both tables. If any column of
the result table does not have a value, that column has the
null value in the result table.
Is This Answer Correct ? | 12 Yes | 1 No |
How will you return the number of records in table?
What is meant by isolation level?
If I have a view which is a join of two or more tables, can this view be updateable?
Define buffer pool.
What is a thread?
What is a NULL value? What are the pros and cons of using NULLS?
What is the role of union all and union
how we will do null data selection in cobol-db2 program
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
What is the role of schema in the db2 database?
What are db2 objects?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?