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

  • AVG – Helpful to find the average of a set of values.
  • COUNT – counts rows in a specified table or view.
  • MIN –  Helpful to find the minimum value in a set of values.
  • MAX – Helpful to find the maximum value in a set of values.
  • SUM – Helpful to find the sum of values.
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

  1. Which of the following is not an aggregate function?
  2. Which of the following is not a Scalar function?
  3. In some database programs, a data file is referred to as a(n) ______.
  4. Which is the common data structure to implement a relational database?