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:

INNER JOIN

LEFT JOIN (or LEFT OUTER JOIN)

RIGHT JOIN

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

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.

Question 32 All questions Question 34

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...Hard Q02An auditor is reviewing the Service Level Agreement (SLA) for a client using a public cloud provi...Hard Q03A company uses an Infrastructure as a Service (IaaS) model. During an IT audit, the auditor disco...Hard Q04An organization is implementing the COSO Enterprise Risk Management (ERM) framework to govern its...Hard Q05During a walkthrough of an order-to-cash process, the auditor observes that the sales manager can...Hard

View all 82 questions →