CompTIA DataSys+ (DS0-001) — Question 7

A database administrator would like to extract a sales performance report from more than one database instance. Which of the following keywords should the database administrator use?

Answer options

• A. UNION ON
• B. UNION AND
• C. JOIN ON
• D. WITH

Correct answer: C

Explanation

The correct answer is C, JOIN ON, because it allows the database administrator to combine rows from multiple tables based on a related column. The other options like UNION ON and UNION AND are incorrect as they do not exist in SQL syntax, and WITH is used for common table expressions, not for joining multiple instances.