gs gs113 Select Statement - The group by and having Clause - 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 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: What is the meaning of “GROUP BY” clause in Mysql?
Group data by column values
Group data by row values
Group data by column and row values
None of the mentioned
Question 2: Which clause is similar to “HAVING” clause in Mysql?
SELECT
WHERE
FROM
None of the mentioned
Question 3: What is the meaning of “HAVING” clause in Mysql?
To filter out the row values
To filter out the column values
To filter out the row and column values
None of the mentioned
Question 4: “COUNT” keyword belongs to which categories in Mysql?
Aggregate functions
Operators
Clauses
All of the mentioned
Question 5: Which among the following belongs to an “aggregate function”?
COUNT
UPPER
LOWER
All of the mentioned
Question 6: Which of the following belongs to an “aggregate function”?
COUNT
SUM/AVG
MIN/MAX
All of the mentioned
Question 7: Which clause is used with an “aggregate functions”?
GROUP BY
SELECT
WHERE
Both GROUP BY and WHERE
Question 8: What is the significance of the statement “GROUP BY d.name” in the following MySQL statement?
SELECT d.name, count (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name
Aggregation of the field “name” of both table
Aggregation of the field “name” of table “department”
Sorting of the field “name”
None of the mentioned
Question 9: What is the significance of the statement “HAVING COUNT (emp_id)>2” in the following MySQL statement?
SELECT d.name, count (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name HAVING COUNT (emp_id)>2
Filter out all rows whose total emp_id below 2
Selecting those rows whose total emp_id>2
Filter out all rows whose total emp_id below 2 & Selecting those rows whose total emp_id>2
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
