Which of the following is not an aggregate function?
MCQs: Which is not a valid aggregate function?
(A). MAX
(B). MIN
(C). power()
(D). COUNT
Solved Answer: (C). power()
| Aggregate Function | Non-aggregate functions ( Arithmetic Function) | Non-aggregate functions ( Character Function) |
| Aggregate functions run on many records and produce a summary | Scalar functions run on each record individually and independently | |
Examples
| Examples
ceil(): floor() power() sqrt() mod(): remainder from a division abs(): | Examples translate(): replaces a sequence of characters in a string with another sequence of characters. trim(): removes leading and trailing characters(or both) from a character string. lower(): convert all characters of a string to lower case upper(): convert all characters of a string to uppercase.
|
MCQs: Which of the following is a valid aggregate function?
(A). MAX
(B). MIN
(C). sum
(D). All of these
Solved Answer: (D). All of these
MCQs: Which is not a valid aggregate function?
(A). MAX
(B). MIN
(C). sum
(D). None of these
Solved Answer: (D). None of these
Highly Recommended Database Important MCQs with Explanation