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?

Question

Options

• AUNION ON
• BUNION AND
• CJOIN ON
• DWITH

• A
  2% (1)
• B
  16% (7)
• C
  74% (32)
• D
  7% (3)

Explanation

JOIN ON is the correct SQL keyword combination because it enables combining rows from multiple tables across different database instances using fully qualified object names (e.g., db1.schema.table JOIN db2.schema.table ON ...), making it the right tool for consolidating a cross-instance sales report.

Why the distractors are wrong:

• A. UNION ON - not valid SQL syntax; UNION is a real keyword but it doesn't take an ON clause
• B. UNION AND - also invalid syntax; this combination does not exist in SQL
• D. WITH - introduces a Common Table Expression (CTE) for structuring a single query, not for pulling data across database instances

Memory tip: Think of JOIN ON as a bridge - it connects two tables (or databases) together based on a matching condition specified after ON. If you see a fake UNION ON or UNION AND, remember that UNION stacks rows vertically and never uses ON.

No community discussion yet for this question.