All aggregate functions except __________ ignore null values in their – McqOptions

MCQOPTIONS

1.	All aggregate functions except __________ ignore null values in their input collection.
A.	Count(attribute)
B.	Count(*)
C.	Avg
D.	Sum
Answer» B. Count(*)

Discussion

No Comment Found

Related MCQs

A Boolean data type that can take values true, false, and ____________
All aggregate functions except __________ ignore null values in their input collection.
If we do want to eliminate duplicates, we use the keyword __________in the aggregate expression.
Which of the following is not a aggregate function ?
The ________ keyword is used to access attributes of preceding tables or subqueries in the from clause.
SQL applies predicates in the _______ clause after groups have been formed, so aggregate functions may be used.