Explanation:An equi-join is a specific type of comparator-based join, that uses only equality comparisons in the join-predicate. 8. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
A. Left outer join
B. Right outer join
C. Full outer join
D. Half outer join
Answer:A
Explanation:An equi-join is a specific type of comparator-based join, that uses only equality comparisons in the join-predicate. 8. Which join refers to join records from the write table that have no matching key in the left table are include in the result set:
A. Left outer join B. Right outer join C. Full outer join D. Half outer join
Explanation:A right outer join will return all the rows that an inner join returns plus one row for each of the other rows in the second table that did not have a match in the first table. It is the same as a left outer join with the tables specified in the opposite order.