For IndividualsFor Educators
ExpertMinds LogoExpertMinds
ExpertMinds

Ace your certifications with Practice Exams and AI assistance.

  • Browse Exams
  • For Educators
  • Blog
  • Privacy Policy
  • Terms of Service
  • Cookie Policy
  • Support
  • AWS SAA Exam Prep
  • PMI PMP Exam Prep
  • CPA Exam Prep
  • GCP PCA Exam Prep

© 2026 TinyHive Labs. Company number 16262776.

    PracticeCPA®CPA ISC Practice Exam 5Question 25
    Easy1 markMultiple Choice
    Area I: Information SystemsData ManagementSQLArea I

    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?

    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
    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).
    Question 24All questionsQuestion 26

    Practice the full CPA ISC Practice Exam 5

    82 questions · hints · full answers · grading

    Sign up freeTake the exam

    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
    View all 82 questions →