How do aggregate functions like COUNT(), SUM(), and AVG() handle NULL values?
Answer options
A
They treat NULL as zero
B
They skip NULL values (except COUNT(*))
C
They return NULL if any value is NULL
D
They throw an error
Correct answer: They skip NULL values (except COUNT(*))
Explanation
Quick AnswerThe correct answer is They skip NULL values (except COUNT(*)) because it directly addresses the core logic of Database Management.
This question has been retained as-is due to its unique context.