If the DISTINCT keyword is not included in the VARIANCE function,the ____ keyword will be assumed.
A) UNIQUE
B) ALL
C) NULLS ONLY
D) NONULLS

Question

If the DISTINCT keyword is not included in the VARIANCE function,the ____ keyword will be assumed.​
A) ​UNIQUE
B) ​ALL
C) ​NULLS ONLY
D) ​NONULLS

Quizplus · Accepted Answer

If the DISTINCT keyword is not included in the VARIANCE function, the ALL keyword will be assumed by default. This means that the VARIANCE function will consider all the rows in the specified column, including any duplicates. Therefore, the best choice would be B (ALL).

If the DISTINCT Keyword Is Not Included in the VARIANCE