What is the key difference between INNER JOIN and OUTER JOIN in DB2?
- INNER JOIN retains unmatched rows
- INNER JOIN selects only the matching rows
- OUTER JOIN retains unmatched rows
- OUTER JOIN selects only the matching rows
The key difference lies in how they handle unmatched rows. INNER JOIN returns only the rows that have matching values in both tables, whereas OUTER JOIN returns all rows from both tables, with unmatched rows filled with NULL values.
Loading...
Related Quiz
- Analyzing and optimizing the ________ can lead to better overall DB2 performance.
- What factors should be considered before running the Reorg utility in DB2?
- What is the purpose of user-defined functions (UDFs) in DB2?
- The EXPORT utility in DB2 is used to ________ data from database tables to an external file.
- How does the Reorg utility improve database performance in DB2?