Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 2 of 90

Querying Using SQL — Question 2

Back to all questions
2
Question

Question 2

Assertion. MOD() and MIN() are numeric functions, yet they are different types of functions.

Reason. MOD() is a single-row function and MIN() is a group function.

  1. Both A and R are true and R is the correct explanation of A.
  2. Both A and R are true but R is not the correct explanation of A.
  3. A is true but R is false.
  4. A is false but R is true.
Answer

Both A and R are true and R is the correct explanation of A.

Explanation
MOD() and MIN() are numeric functions, but they are different types. MOD() is a single-row function, meaning it operates on individual rows and returns a result for each row. In contrast, MIN() is a group function (an aggregate function), which operates on a set of rows and returns a single result for the entire set.