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 Incorrect answer: B group functions on column ignore NULL values C group functions on column ignore NULL values D NVL function can be use for column with NULL values E no such INC_NULLS keyword

Using Functions (Single-Row, Group, Conversion, Conditional)

Question

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 INC_NULLS.

How the community answered

(50 responses)

A
82% (41)
B
10% (5)
C
6% (3)
D
2% (1)

Explanation

group functions on column ignore NULL values Incorrect answer: B group functions on column ignore NULL values C group functions on column ignore NULL values D NVL function can be use for column with NULL values E no such INC_NULLS keyword

Topics

#group functions#NULL values#aggregate functions

Community Discussion

No community discussion yet for this question.

Full 1Z0-007 Practice