MCQs: Which is not a valid Scalar function?
(A). exp()
(B). MIN
(C). abs()
(D). sqrt()
Solved Answer: (B). MIN
Aggregate Function  Scalar functions
( Arithmetic Function) 
Scalar function 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 scalar function?
(A). MAX
(B). MIN
(C). sum
(D). power()
Solved Answer: (D). power()
MCQs: Which is not a valid nonaggregate function?
(A). MAX
(B). AVG
(C). sum
(D). All of these
Solved Answer: (D). All of these
Highly Recommended Database Important MCQs with Explanation