Database Fundamentals — Question 111

This question requires that you evaluate the underlined text to determine if it is correct.
The JOIN 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. UNION

Correct answer: B

Explanation

The statement is incorrect because the JOIN keyword does not return only rows that appear in both result sets; it combines rows from two tables based on a related column. The correct operation that returns only the rows present in both sets is INTERSECT.