MCQs: Which is not a valid Scalar function?
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|
mod(): remainder from a division
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?
Solved Answer: (D). power()
MCQs: Which is not a valid non-aggregate function?
(D). All of these
Solved Answer: (D). All of these
Highly Recommended Database Important MCQs with Explanation