Bright Tutorials Bright Tutorials
CBSE Class 12 Informatics Practices Question 3 of 81

MySQL Functions — Question 3

Back to all questions
3
Question

Question 3

Assertion. Multiple rows functions when applied on a column in a table, yield values which are not equal to number of rows in the table.

Reason. The multi-row functions work with data of multiple rows at a time and return aggregated value.

  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
Multiple row functions, when applied to a column in a table, yield values that are not equal to the number of rows in the table. This is because these functions work on multiple rows together and return a summary result or aggregated value for a group of rows.