Class - 12 CBSE Computer Science — Assertion Reason Type Questions
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.
- Both A and R are true and R is the correct explanation of A.
- Both A and R are true but R is not the correct explanation of A.
- A is true but R is false.
- A is false but R is true.
SQL Queries
3 Likes
Answer
Both A and R are true and R is the correct explanation of A.
ExplanationMOD()
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.
Answered By
1 Like