Informatics Practices
Assertion. Single row functions when applied on a column in a table, yield multiple values equal to number of rows in the table.
Reason. Single row functions work with individual rows and yield values accordingly.
- 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
2 Likes
Answer
Both A and R are true and R is the correct explanation of A.
Explanation
When a single row function is applied to a column in a table, it produces output for each row. Therefore, if there are n rows in the table, the single row function will yield n values, one for each row, because single row functions work with individual rows of a table.
Answered By
3 Likes
Related Questions
Date() and Day() return the same thing.
INSTR() and SUBSTR() work identically.
Assertion. Multi-row functions when applied on a column in a table, yield values which are not equal to number of rows in the table.
Reason. Multiple-rows functions do not work with all the rows in the table.
- 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. 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.
- 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.