nerdexam
IBM

C2020-010 · Question #8

Assume you have four fields, 4, A, C and D and you wish to find the sum of the values even if there are $null$ missing values in one or more fields. Which expression would accomplish this task?

The correct answer is C. sum_n([A, B, C, D]). See the full explanation below for the reasoning.

Question

Assume you have four fields, 4, A, C and D and you wish to find the sum of the values even if there are $null$ missing values in one or more fields. Which expression would accomplish this task?

Options

  • ASum_n((ABCIJ))
  • BA+B+C+D
  • Csum_n([A, B, C, D])
  • Dto_real(A) + to_real(B) + to_real(C) + to_real(D)

How the community answered

(36 responses)
  • A
    6% (2)
  • B
    8% (3)
  • C
    72% (26)
  • D
    14% (5)

Community Discussion

No community discussion yet for this question.

Full C2020-010 Practice