Which of the following is not a Scalar function?

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

  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?
Prof.Fazal Rehman Shamil (Available for Professional Discussions)
1. Message on Facebook page for discussions,
2. Video lectures on Youtube
3. Email is only for Advertisement/business enquiries.