InfyTQ SQL Functions, Sorting and Grouping Data Quiz 1

Group data by column values

Group data by row values

Group data by column and row values

None of the mentioned

To filter out the row values

To filter out the column values

To filter out the row and column values

None of the mentioned

None of the mentioned

UPPER

LOWER

COUNT

GROUP BY

SELECT

WHERE

Both GROUP BY and WHERE

Yes

No

Depends

None of the mentioned

Sorting your result set using column data

Aggregation of fields

Sorting your result set using row data

None of the mentioned

DESC

ASC

ALTER

MODIFY

DESC

ASC

ALTER

MODIFY

Data of stu_id will be sorted in descending order

Data of stu_id will be sorted in ascending order

Data of stu_id will be sorted in either ascending or descending order

All of the mentioned

{9, 7, 6, 4, 3, 1, 2}

{1, 2, 3, 4, 6, 7, 9}

{2, 1, 3, 4, 6, 7, 9}

None of the mentioned