Which type of JOIN combines all rows from the left table and all rows from the right table, filling in NULLs wherever a match is missing on either side?
Explanation:
A Full Outer Join combines the behavior of both Left and Right Outer Joins, returning all rows from both tables and applying NULL values where matches do not exist.
Explanation:
An Index is a performance optimization structure created on table columns to search and locate matching rows quickly without performing a full table scan.
No comments yet. Be the first to start the discussion!