ExpertHard1 markMultiple Choice
CPA · Question 04 · Area I: Information Systems
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?
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:
A.
It excludes customers who are active but haven't ordered recently.
B.
It may include inactive customers who ordered recently.
C.
It will return duplicate records for active customers with recent orders.
D.
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
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.
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 ...MediumQ02An auditor is reviewing the backup strategy for a financial institution that requires a Recovery ...HardQ03During a walkthrough of the change management process, an auditor observes that developers have w...MediumQ05Which of the following entities is considered a 'Covered Entity' under the HIPAA Privacy Rule?MediumQ06Under GDPR, which principle requires that personal data be adequate, relevant, and limited to wha...Medium