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.

Assertion. The count(*) will yield a single value while round() will yield number of values equal to the cardinality of the table.

Reason. The count (*) is a multiple-rows function and round() is a single-row 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.

Explain the UCASE() SQL function using suitable examples.

Explain the TRIM() SQL function using suitable examples.