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
- SUM – Helpful to find the sum of values.
- MIN – Helpful to find the minimum value in a set of values.
- MAX – Helpful to find the maximum value in a set of values.
- AVG – Helpful to find the average of a set of values.
- COUNT – counts rows in a specified table or view.
|
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 non-aggregate function?
(A). MAX
(B). AVG
(C). sum
(D). All of these
Solved Answer: (D). All of these
Highly Recommended Database Important MCQs with Explanation
- Which of the following is not an aggregate function?
- Which of the following is not a Scalar function?
- In some database programs, a data file is referred to as a(n) ______.
- Which is the common data structure to implement a relational database?
Related Posts:
- Divide the Scalar Matrix A=[(5,0),(0,5)]A=[(5,0),(0,5)] by the Scalar Matrix B=[(2,0),(0,2)]B=[(2,0),(0,2)].
- Which of the following is not an aggregate function?
- Which of the following is not the function of conducting part of respiratory system?
- Which of the following is not a function of vacuole?
- Multiply the Scalar Matrices A and B
- Scalar Matrix Exercise (with Solution)