gs gs113 Select Statement - The Order by Clauses - Quiz No.1
gs gs113 MySQL Quiz
This quiz belongs to book/course code gs gs113 MySQL of gs organization. We have 126 quizzes available related to the book/course MySQL. This quiz has a total of 10 multiple choice questions (MCQs) to prepare and belongs to topic Select Statement. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
Question 1: Is “GROUP BY” clause is similar to “ORDER BY” clause?
Yes
No
Depends
None of the mentioned
Question 2: What is the meaning of “ORDER BY” clause in Mysql?
Sorting your result set using column data
Aggregation of fields
Sorting your result set using row data
None of the mentioned
Question 3: What is the significance of “ORDER BY” in the following MySQL statement?
SELECT emp_id, fname, lname FROM person ORDER BY emp_id;
Data of emp_id will be sorted
Data of emp_id will be sorted in descending order
Data of emp_id will be sorted in ascending order
All of the mentioned
Question 4: What will be the order of sorting in the following MySQL statement?
SELECT emp_id, emp_name FROM person ORDER BY emp_id, emp_name;
Sorting {emp_id, emp_name}
Sorting {emp_name, emp_id}
Sorting (emp_id} but not emp_name
None of the mentioned
Question 5: If emp_id contain the following set {9, 7, 6, 4, 3, 1, 2}, what will be the output on execution of the following MySQL statement?
SELECT emp_id FROM person ORDER BY emp_id;
{1, 2, 3, 4, 6, 7, 9}
{2, 1, 4, 3, 7, 9, 6}
{9, 7, 6, 4, 3, 1, 2}
None of the mentioned
Question 6: If emp_id contain the following set {1, 2, 3, 4, 1, 1}, what will be the output on execution of the following MySQL statement?
SELECT emp_id FROM person ORDER BY emp_id;
{1, 1, 1, 2, 3, 4}
{1, 2, 3, 4, 1, 1}
{1, 1, 2, 3, 4, 1}
None of the mentioned
Question 7: If emp_id contain the following set {1, 2, 2, 3, 3, 1}, what will be the output on execution of the following MySQL statement?
SELECT emp_id FROM person ORDER BY emp_id;
{1, 1, 2, 2, 3, 3}
{1, 2, 3, 3, 2, 1}
{2, 2, 1, 1, 3, 3}
None of the mentioned
Question 8: If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement?
SELECT emp_id FROM person ORDER BY emp_id;
{-3, -2, -1, 1, 2, 3}
{-1, 1, -2, 2, -3, 3}
{1, 2, 3, -1, -2, -3}
None of the mentioned
Question 9: Which keyword is used for sorting the data in descending order in Mysql?
DESC
ASC
ALTER
MODIFY
Question 10: Which keyword is used for sorting the data in ascending order in Mysql?
DESC
ASC
ALTER
MODIFY
Online Quizzes of gs113 MySQL
MySQL Programs Using C - Using the Embedded Server Library - Quiz No.1
gs gs113
MySQL Online Quizzes
System, Status and User Variables - User-Defined Variables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.1
gs gs113
MySQL Online Quizzes
Using SQL to Manage Data - Populating and Modifying Tables - Quiz No.2
gs gs113
MySQL Online Quizzes
