Question 1

Question 1Assertion. 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.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationWhen 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.

Question 2

Question 2Assertion. 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.

Accepted Answer

A is true but R is false.ExplanationMultiple row functions when applied on a column in a table, work on multiple rows together and return a summary result for a group of rows. Hence, the result values are not equal to number of rows in the table.

Question 3

Question 3Assertion. 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.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationMultiple 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.

Question 4

Question 4Assertion. 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.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.

Accepted Answer

Both A and R are true and R is the correct explanation of A.ExplanationThe count(*) function returns a single value, while round() will yield number of values equal to the cardinality (rows) of the table. This is because count() operates on all rows in a table (or a group of rows), producing a single result. In contrast, round() operates on each row individually, producing multiple results depending on the cardinality of the table.

Question 5

Question 1Which function can be used to concatenate two strings ?

Accepted Answer

The CONCAT() function is used to concatenate two strings in a query result.

Question 6

Question 2Which function(s) can be used for extracting a substrings ?

Accepted Answer

The SUBSTRING()/SUBSTR() and MID() functions can be used for extracting a substrings.

Question 7

Question 3What is the difference between Trim() and Rtrim() ?

Accepted Answer

The difference between the TRIM() and RTRIM() functions is that the TRIM() function removes both leading and trailing spaces from a given string, performing the combined functions of LTRIM() and RTRIM(). On the other hand, the RTRIM() function only removes trailing spaces, i.e., spaces from the right side of the given string.

Question 8

Question 4What is the difference between round() and truncate() ?

Accepted Answer

The difference between the ROUND() and TRUNCATE() functions is that the ROUND() function returns a number rounded off according to the given specifications. On the other hand, the TRUNCATE() function returns a number with some digits truncated. The TRUNCATE() function simply removes the specified digits without rounding them off.

Question 9

Question 5Which function returns the current date and current time ?

Accepted Answer

The NOW() function returns the current date and current time.

Question 10

Question 6What is the difference between sysdate() and now() functions ?

Accepted Answer

The difference between the SYSDATE() and NOW() functions is that the SYSDATE() function returns the exact time at which the function executes. On the other hand, the NOW() function returns the current date and time at the beginning of the statement execution.

Question 11

Question 1The functions that work with one row at a time are called single row functions.

Accepted Answer