InfyTQ SQL Functions, Sorting and Grouping Data Quiz 1

Question 1

Time: 00:00:00
What is the use of the “GROUP BY” clause in SQL ?

Group data by column values

Group data by column values

Group data by row values

Group data by row values

Group data by column and row values

Group data by column and row values

None of the mentioned

None of the mentioned

Question 2

Time: 00:00:00
What is the use of the “HAVING” clause in SQL ?

To filter out the row values

To filter out the row values

To filter out the column values

To filter out the column values

To filter out the row and column values

To filter out the row and column values

None of the mentioned

None of the mentioned

Question 3

Time: 00:00:00
Which among the following are the aggregate functions ?

None of the mentioned

None of the mentioned

UPPER

UPPER

LOWER

LOWER

COUNT

COUNT

Question 4

Time: 00:00:00
Which clause is used with “aggregate functions”?

GROUP BY

GROUP BY

SELECT

SELECT

WHERE

WHERE

Both GROUP BY and WHERE

Both GROUP BY and WHERE

Question 5

Time: 00:00:00
Is the “GROUP BY” clause same as compared to the “ORDER BY” clause?

Yes

Yes

No

No

Depends

Depends

None of the mentioned

None of the mentioned

Question 6

Time: 00:00:00
What is the use of the “ORDER BY” clause in ORACLE Database ?

Sorting your result set using column data

Sorting your result set using column data

Aggregation of fields

Aggregation of fields

Sorting your result set using row data

Sorting your result set using row data

None of the mentioned

None of the mentioned

Question 7

Time: 00:00:00
Which among the following keywords is used for sorting the data in descending order in ORACLE ?

DESC

DESC

ASC

ASC

ALTER

ALTER

MODIFY

MODIFY

Question 8

Time: 00:00:00
Which among the following keywords is used for sorting the data in ascending order in Mysql?

DESC

DESC

ASC

ASC

ALTER

ALTER

MODIFY

MODIFY

Question 9

Time: 00:00:00
What will be the result of “ORDER BY stu_id DESC” in the following MySQL command?
SELECT stu_id, fname, lname
FROM students
ORDER BY stu_id DESC;

Data of stu_id will be sorted in descending order

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 ascending order

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

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

All of the mentioned

All of the mentioned

Question 10

Time: 00:00:00
Given the stu_id the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL command?
SELECT stu_id
FROM students
ORDER BY stu_id ASC;

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

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

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

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

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

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

None of the mentioned

None of the mentioned

null
null
×

Please login to report