CompTIACompTIA
DS0-001 · Question #12
DS0-001 Question #12: Real Exam Question with Answer & Explanation
Sign in or unlock DS0-001 to reveal the answer and full explanation for question #12. The question stem and answer options stay visible for context.
Database Fundamentals
Question
A business analyst is using a client table and an invoice table to create a database view that shows clients who have not made purchases yet. Which of the following joins is most appropriate for the analyst to use to create this database view?
Options
- AINNER JOIN ON Client.Key = Invoice.Key
- BRIGHT JOIN ON Client.Key = Invoice.Key WHERE BY Client.Key IS NULL
- CLEFT JOIN ON Client.Key = Invoice.Key
- DLEFT JOIN ON Client.Key = Invoice.Key WHERE BY Invoice.Key IS NULL
Unlock DS0-001 to see the answer
You've previewed enough free DS0-001 questions. Unlock DS0-001 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.
Topics
#SQL Joins#Outer Joins#Data Retrieval#NULL Values