Informatics Practices
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.
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.
Related Questions
The SQL keyword GROUP BY instructs the DBMS to group together those rows that have the same value in a column.
Assertion. The ORDER BY clause of SELECT statement is carried out in the last after executing other clauses of the SELECT statement.
Reason. The ORDER BY clause is carried out on the final result of the SELECT query.
- 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.
Assertion. The GROUP BY clause can use any type of function.
Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.
- 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.
Assertion. The GROUP BY clause yields summary results using group functions.
Reason. The GROUP BY clause combines a number of rows in a group and applies functions on it.
- 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.