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 many buffer pools are available in db2?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
When Can you be sure that a query will return only one row?
What is meant by dclgen?
What is the significance of DB2 free space and what parameters control it?
What is the maximum number of columns in a db2 table?
what types of copies can be made with the COPY Utility ?
What is the information associated with sysibm.syslinks table?
what is dynamic cursor?gives syntax for this?
What will the FREE command do to a plan?
What is package in db2 mainframe?
What is the use of with ur in db2?