Multiple choice technology databases

Analytic functions compute an aggregate value based on a group of rows and return a single row for each group.

  1. True

  2. False

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The statement describes aggregate functions (GROUP BY) which return one row per group. Analytic functions use OVER() and maintain row granularity - they compute aggregates without collapsing rows.