Assertion. The PRIMARY KEY and FOREIGN KEY constraints are similar.

Reason. The FOREIGN KEY constraint links a column of a table with the PRIMARY KEY constraint of another table.

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. Data types varchar and char are the same as they both represent the string data.

Reason. The VARCHAR datatype stores variable string length while CHAR datatype stores the string always as fixed length strings.

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. 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.

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. 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.

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. 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.

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.

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. 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.

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 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.

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 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.

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.