nerdexam
Oracle

1Z0-061 · Question #244

What is true of using group functions on columns that contain NULL values?

The correct answer is A. Group functions on columns ignore NULL values. group functions on column ignore NULL values

Reporting Aggregated Data using the Group Functions

Question

What is true of using group functions on columns that contain NULL values?

Options

  • AGroup functions on columns ignore NULL values.
  • BGroup functions on columns returning dates include NULL values.
  • CGroup functions on columns returning numbers include NULL values.
  • DGroup functions on columns cannot be accurately used on columns that contain NULL values.
  • EGroup functions on columns include NULL values in calculations if you use the keyword

How the community answered

(49 responses)
  • A
    84% (41)
  • B
    4% (2)
  • C
    8% (4)
  • D
    2% (1)
  • E
    2% (1)

Explanation

group functions on column ignore NULL values

Topics

#group functions#NULL values#aggregate functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-061 Practice