Multiple choice technology mainframe

Which of the following functional field usage will calculate the total number of employees in department?

  1. MAX

  2. MIN

  3. CNT

  4. SUM

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

In Query/400 or related IBM query tools, the CNT (Count) function field usage calculates the number of records (such as employees) in a group. SUM computes the numeric total of a field, while MIN and MAX retrieve the minimum and maximum values, making them incorrect.