IBM
C2090-610 · Question #127
C2090-610 Question #127: Real Exam Question with Answer & Explanation
Sign in or unlock C2090-610 to reveal the answer and full explanation for question #127. The question stem and answer options stay visible for context.
Question
Given an EMPLOYEES table and a SALES table, a user wants to produce a list of all employees and their associated revenue, even if no revenue exists. Which SQL statement will produce the desired list?
Options
- ASELECT employees.name, sales.revenue
- BSELECT employees.name, sales.revenue
- CSELECT employees.name, sales.revenue
- DSELECT employees.name, sales.revenue
Unlock C2090-610 to see the answer
You've previewed enough free C2090-610 questions. Unlock C2090-610 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.