An auditor is reviewing a SQL query used to generate a list of active customers for a marketing campaign. The query is:<br/>SELECT * FROM Customers WHERE Status = 'Active' OR LastOrderDate > '2023-01-01'.<br/>What is the potential issue with this query regarding data accuracy?

Answer options:

It excludes customers who are active but haven't ordered recently.

It may include inactive customers who ordered recently.

It will return duplicate records for active customers with recent orders.

The syntax is invalid for standard SQL.

How to approach this question

Analyze the logic of the OR operator. True OR False = True.

Full Answer

B.It may include inactive customers who ordered recently.✓ Correct

It may include inactive customers who ordered recently.

The OR operator includes records meeting either criteria. If the goal is 'Active' customers, the query should likely use AND or rely solely on the Status field. Currently, it pulls Inactive customers if they have a recent LastOrderDate.

Common mistakes

Confusing OR with AND logic.

Question 03 All questions Question 05

Practice the full CPA ISC Practice Exam 2

82 questions · hints · full answers · grading

More questions from this exam

Q01A service organization provides a cloud-based payroll platform where clients access the software ...Medium Q02An auditor is reviewing the backup strategy for a financial institution that requires a Recovery ...Hard Q03During a walkthrough of the change management process, an auditor observes that developers have w...Medium Q05Which of the following entities is considered a 'Covered Entity' under the HIPAA Privacy Rule?Medium Q06Under GDPR, which principle requires that personal data be adequate, relevant, and limited to wha...Medium

View all 82 questions →