ExpertEasy1 markMultiple Choice
CPA · Question 25 · Area I: Information Systems
An auditor wants to extract all customers from the 'Sales' table who live in 'NY' and spent more than $1,000. Which SQL clause is required to filter the data?
An auditor wants to extract all customers from the 'Sales' table who live in 'NY' and spent more than $1,000. Which SQL clause is required to filter the data?
Answer options:
A.
SELECT
B.
FROM
C.
WHERE
D.
ORDER BY
How to approach this question
Recall SQL syntax functions.
Full Answer
C.WHERE✓ Correct
WHERE
The WHERE clause is used to filter records and extract only those that fulfill a specified condition.
Common mistakes
Confusing SELECT (columns) with WHERE (rows/conditions).
Practice the full CPA ISC Practice Exam 5
82 questions · hints · full answers · grading
More questions from this exam
Q01A service organization provides a cloud-based payroll processing application to its user entities...MediumQ02An auditor is reviewing the shared responsibility model for a client using an Infrastructure as a...HardQ03A financial institution requires a cloud deployment model that offers the highest level of contro...MediumQ04During an IT audit, you observe that a company uses a 'Hybrid Cloud' architecture. Which scenario...MediumQ05Which component of IT architecture is primarily responsible for translating domain names (like ww...Easy