Explanation:On gives the condition for the join expression. 2. Which of the join operations do not preserve non matched tuples.
A. Left outer join
B. Right outer join
C. Inner join
D. Natural join
Answer:A
Explanation:On gives the condition for the join expression. 2. Which of the join operations do not preserve non matched tuples.
A. Left outer join B. Right outer join C. Inner join D. Natural join
Explanation:INNER JOIN: Returns all rows when there is at least one match in BOTH tables. 3. Select *