Multiple choice technology

Number of records in a file can be counted using rollup component with key parameter as

  1. All fields in the record

  2. NULL

  3. {}

  4. By selecting unique field.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

To count all records without grouping, Rollup uses an empty key specification denoted as {}. This tells Rollup to treat all records as one group and apply count() aggregation. Using all fields would group by every unique record combination. NULL is not valid syntax, and selecting a unique field would group by that field's values.

Keep practicing — related questions