Which of the following is not an aggregate function?

By: Prof. Dr. Fazal Rehman | Last updated: February 3, 2024

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?
All Copyrights Reserved 2025 Reserved by T4Tutorials