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 2Question 53
    Easy1 markMultiple Choice
    Area I: Information SystemsData ManagementSQLArea I

    CPA · Question 53 · Area I: Information Systems

    Which SQL aggregate function is used to count the number of rows in a result set?

    Answer options:

    A.

    SUM()

    B.

    TOTAL()

    C.

    COUNT()

    D.

    NUMBER()

    How to approach this question

    Identify the counting function.

    Full Answer

    C.COUNT()✓ Correct
    COUNT()
    SELECT COUNT(*) FROM table returns the number of rows.

    Common mistakes

    Using SUM (which adds the values inside the rows).
    Question 52All questionsQuestion 54

    Practice the full CPA ISC Practice Exam 2

    82 questions · hints · full answers · grading

    Sign up freeTake the exam

    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...MediumQ04An auditor is reviewing a SQL query used to generate a list of active customers for a marketing c...HardQ05Which of the following entities is considered a 'Covered Entity' under the HIPAA Privacy Rule?Medium
    View all 82 questions →