Explanation:
Out of all available candidate keys, the one selected to identify rows uniquely is the primary key, and the remaining unselected candidate keys are called alternate keys.
What type of join returns all rows from the right table, paired with matching records from the left table, or filling in NULL values if no match is found?
Explanation:
A Right Outer Join retains all rows from the right table, pairing them with matching left table entries or supplying NULL values if matches do not exist.
No comments yet. Be the first to start the discussion!