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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

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

Good Job!

Oops!

  • PrepInsta Explanation
  • User Explanation
Once you attempt the question then PrepInsta explanation will be displayed.

Please login to submit your explanation

Start

["0","40","60","80","100"]
["Need more practice!","Keep trying!","Not bad!","Good work!","Perfect!"]
×

Please login to report

Personalized Analytics only Availble for Logged in users

Analytics below shows your performance in various Mocks on PrepInsta

Your average Analytics for this Quiz

Rank

-

Percentile

0%

Start Preparing
Detailed performance

Completed

0/0

Accuracy

0%

January 22, 2022