Database Fundamentals — Question 22

This question requires that you evaluate the underlined text to determine if it is correct.
The UNION keyword combines the results of two queries and returns only rows that appear in both result sets.
Instructions: Review the underlined text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct

Answer options

• A. No change is needed
• B. INTERSECT
• C. ALL
• D. JOIN

Correct answer: B

Explanation

The statement is incorrect because the UNION keyword combines the results of two queries and returns all unique rows from both result sets. The correct term that represents the operation which returns only the rows that are present in both queries is INTERSECT, making option B the right choice.