An auditor is reviewing a SQL query that joins two tables: 'Customers' and 'Orders'. The query uses an 'INNER JOIN'. Which records will be included in the result?

Answer options:

All customers, even if they have no orders.

All orders, even if they have no customer.

Only records where there is a match in BOTH tables.

All records from both tables, regardless of matches.

How to approach this question

Inner = Intersection (Both). Left = All Left + Matching Right. Right = All Right + Matching Left.

Full Answer

C.Only records where there is a match in BOTH tables.✓ Correct

An INNER JOIN returns records that have matching values in both tables. If a customer has no orders, they are excluded. If an order has no customer, it is excluded.

Common mistakes

Confusing Inner with Left/Outer joins.

Question 70 All questions Question 72

Practice the full CPA ISC Practice Exam

82 questions · hints · full answers · grading

More questions from this exam

Q01A CPA is performing a risk assessment for a client that uses a public cloud provider for its core...Hard Q02During a walkthrough of a client's change management process, the auditor notes that developers h...Hard Q03A service organization provides a real-time transaction processing platform. The service level ag...Hard Q04An auditor is reviewing a SQL query used by the finance team to generate a report of all sales tr...Hard Q05A healthcare clearinghouse is preparing for a SOC 2® engagement. They utilize a private cloud dep...Hard

View all 82 questions →