Question 1

Question 1Assertion. 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.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.ExplanationIn SQL, the execution order of a SELECT statement is such that the ORDER BY clause is processed last, after all other clauses like FROM, WHERE, GROUP BY, HAVING, and SELECT have been executed. This is because the ORDER BY clause sorts the final result set produced by these earlier steps.

Question 2

Question 2Assertion. 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.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.ExplanationMOD() and MIN() are numeric functions, but they are different types. MOD() is a single-row function, meaning it operates on individual rows and returns a result for each row. In contrast, MIN() is a group function (an aggregate function), which operates on a set of rows and returns a single result for the entire set.

Question 3

Question 3Assertion. 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.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 false but R is true.ExplanationThe GROUP BY clause uses aggregate functions. It combines all those records that have identical values in a particular field or a group of fields and applies group-functions, resulting in one summary record per group.

Question 4

Question 4Assertion. 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.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 GROUP BY clause yields summary results using group functions because it combines all records that have identical values in a particular field or a group of fields. This grouping results in one summary record per group if group functions are used with it.

Question 5

Question 5Assertion. Both WHERE and HAVING clauses work with GROUP BY in a SELECT statement.Reason. The WHERE clause is applied before forming groups of rows and HAVING clause is applied after forming the groups.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.ExplanationBoth the WHERE and HAVING clauses can be used with the GROUP BY clause in a SELECT statement to filter and specify conditions for rows and groups, respectively. The WHERE clause filters rows before they are grouped, while the HAVING clause filters groups of rows after they have been grouped by the GROUP BY clause. This is because WHERE conditions cannot include aggregate functions, whereas HAVING conditions can include them.

Question 6

Question 6Assertion. Both WHERE and HAVING clauses are used for specifying conditions.Reason. WHERE and HAVING clauses of the SELECT query can be used interchangeably.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 but R is not the correct explanation of A.ExplanationBoth WHERE and HAVING clauses are used to specify conditions in a SELECT query, they operate at different levels. The WHERE clause filters rows based on conditions applied to individual rows before grouping, while the HAVING clause filters groups based on conditions applied to the result of aggregation functions after grouping. Hence, they are not interchangeable.

Question 7

Question 7Assertion. Both WHERE and HAVING clauses are used for specifying conditions.Reason. The WHERE condition is applicable on individual rows and HAVING condition is applicable on a group of rows.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 but R is not the correct explanation of A.ExplanationBoth WHERE and HAVING clauses are used to specify conditions in a SELECT query, they operate at different levels. The WHERE clause filters rows based on conditions applied to individual rows before grouping, while the HAVING clause filters groups based on conditions applied to the result of aggregation functions after grouping.

Question 8

Question 1Can you arrange the result set of an SQL query on multiple columns ?

Accepted Answer

Yes, we can arrange the result set of an SQL query on multiple columns. We should specify the multiple column names in the ORDER BY clause along with the desired sort order.For example, the following statement will sort the records in the data table first by the section column in ascending order and then by the marks column in descending order.SELECT * FROM data
ORDER BY section ASC, marks DESC;

Question 9

Question 2What is the significance of "ORDER BY" in the given query?SELECT emp_id, fname, lname
FROM person
ORDER BY emp_id;(a) Data of table person on the basis of column emp_id will be sorted in descending order(b) Data of table person on the basis of column emp_id will be sorted in ascending order(c) Only data of column emp_id will be sorted in descending order(d) Only data of column emp_id will be sorted in ascending order

Accepted Answer

Data of table person on the basis of column emp_id will be sorted in ascending orderReason — The significance of the ORDER BY clause in the given query is to sort the result set based on the values in the emp_id column in ascending order by default.

Question 10

Question 3What will be the order of sorting in the given query?SELECT emp_id, emp_name 
FROM person
ORDER BY emp_id, emp_name;(a) Firstly on emp_id and then on emp_name(b) Firstly on emp_name and then on emp_id(c) Firstly on emp_id but not on emp_name(d) None of the mentioned

Accepted Answer

Firstly on emp_id and then on emp_nameReason — The ORDER BY emp_id, emp_name clause sorts the result set firstly by the emp_id column. If there are rows with the same emp_id, those rows are further sorted by the emp_name column.

Question 11

Question 4If column emp_id contains the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the given query?SELECT emp_id 
FROM person 
ORDER BY emp_id;(a) {9, 7, 6, 4, 3, 1, 2}(b) {1, 2, 3, 4, 6, 7, 9}(c) {2, 1, 4, 3, 7, 9, 6}(d) None of these

Accepted Answer

{1, 2, 3, 4, 6, 7, 9}Reason — The ORDER BY clause in SQL sorts the result set based on the specified column(s) in ascending order by default. In the given query, the emp_id column is specified in the ORDER BY clause. Therefore, the query will sort the emp_id values in ascending order.

Question 12

Question 5Which function can you use with ORDER BY clause to specify custom sort order ?(a) SORT()(b) CUSTOM()(c) FIELD()(d) All of these

Accepted Answer

FIELD()Reason — The FIELD() function in SQL allows to specify a custom sort order by listing the values in the order we want them to appear.For example, the following statement selects column fruit_name from the fruits table and orders the result set based on the custom sort order specified by the FIELD() function.SELECT * FROM fruits
ORDER BY FIELD(fruit_name, 'Apple', 'Banana', 'Orange', 'Grapes');

Question 13

Question 1To sort the rows of the result table, the ORDER BY clause is specified.

Accepted Answer