gs gs113 Select Statement - The Order by Clauses - Quiz No.2
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 9 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: Keyword “ASC” and “DESC” cannot be used without which clause in Mysql?
ORDER BY
GROUP BY
SELECT
HAVING
Question 2: What is the significance of “ORDER BY emp_id DESC” in the following MySQL command?
SELECT emp_id, fname, lname FROM person ORDER BY emp_id DESC;
Data of emp_id will be sorted in descending order
Data of emp_id will be sorted in ascending order
Data of emp_id will be sorted in either ascending or descending order
All of the mentioned
Question 3: What is the significance of “ORDER BY emp_id ASC” in the following MySQL command?
SELECT emp_id, fname, lname FROM person ORDER BY emp_id ASC;
Data of emp_id will be sorted in descending order
Data of emp_id will be sorted in ascending order
Data of emp_id will be sorted in either ascending or descending order
All of the mentioned
Question 4: 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 command?
SELECT emp_id FROM person ORDER BY emp_id DESC;
{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
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 command?
SELECT emp_id FROM person ORDER BY emp_id ASC;
{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
Question 6: Find odd one out?
GROUP BY
DESC
ASC
ORDER BY
Question 7: Is there any error in the following MySQL command?
SELECT emp_id, title, start_date, fname, fed_id FROM person ORDER BY RIGHT (fed_id, 3);
Yes
No error
Depends
None of the mentioned
Question 8: Is there any error in the following MySQL command?
SELECT emp_id, title, start_date, fname, fed_id FROM person ORDER BY left (fed_id, 3);
Yes
No error
Depends
None of the mentioned
Question 9: Is there any error in the following MySQL command?
SELECT emp_id, title, start_date, fname, fed_id FROM person ORDER BY 2, 5;
Yes
No
Depends
None of the mentioned
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
