ExpertEasy1 markMultiple Choice
CPA · Question 53 · Area I: Information Systems
Which SQL aggregate function is used to count the number of rows in a result set?
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
SELECT COUNT(*) FROM table returns the number of rows.
Common mistakes
Using SUM (which adds the values inside the rows).
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...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