If the DISTINCT keyword is not included in the STDDEV function,the ____ keyword will be assumed.
A) UNIQUE
B) ALL
C) NONULLS
D) none of the above

Question

If the DISTINCT keyword is not included in the STDDEV function,the ____ keyword will be assumed.​
A) ​UNIQUE
B) ​ALL
C) ​NONULLS
D) ​none of the above

Quizplus · Accepted Answer

If the DISTINCT keyword is not included in the STDDEV function, the ALL keyword is assumed, which calculates the standard deviation of all values in the column, including duplicates. Therefore, the best choice is B, which represents the ALL keyword.

If the DISTINCT Keyword Is Not Included in the STDDEV