ExpertHard1 markMultiple Choice
CPA · Question 33 · Area I: Information Systems
An auditor is reviewing a SQL query that joins two tables: 'Customers' and 'Orders'. The goal is to list ALL customers, including those who have not placed any orders. Which JOIN type should be used?
An auditor is reviewing a SQL query that joins two tables: 'Customers' and 'Orders'. The goal is to list ALL customers, including those who have not placed any orders. Which JOIN type should be used?
Answer options:
A.
INNER JOIN
B.
LEFT JOIN (or LEFT OUTER JOIN)
C.
RIGHT JOIN
D.
CROSS JOIN
How to approach this question
Inner = Intersection. Left = All Left + Intersection. Right = All Right + Intersection.
Full Answer
B.LEFT JOIN (or LEFT OUTER JOIN)✓ Correct
LEFT JOIN (or LEFT OUTER JOIN)
A LEFT JOIN returns all records from the left table (Customers), and the matched records from the right table (Orders). The result is NULL from the right side, if there is no match.
Common mistakes
Using INNER JOIN which excludes customers with no orders.
Practice the full CPA ISC Practice Exam 4
82 questions · hints · full answers · grading
More questions from this exam
Q01A CPA is advising a client who is migrating their legacy on-premise ERP system to a cloud environ...HardQ02An auditor is reviewing the Service Level Agreement (SLA) for a client using a public cloud provi...HardQ03A company uses an Infrastructure as a Service (IaaS) model. During an IT audit, the auditor disco...HardQ04An organization is implementing the COSO Enterprise Risk Management (ERM) framework to govern its...HardQ05During a walkthrough of an order-to-cash process, the auditor observes that the sales manager can...Hard