MySQL- group by and foreign key

MySQL- group by and foreign key

12th Grade

13 Qs

quiz-placeholder

Similar activities

RDBMS - 2

RDBMS - 2

12th Grade

15 Qs

MOS Word 2016 Learn by Doing Part 4 Working with Tables

MOS Word 2016 Learn by Doing Part 4 Working with Tables

8th - 12th Grade

12 Qs

SQL

SQL

10th - 12th Grade

11 Qs

SQL_RDBMS

SQL_RDBMS

12th Grade

12 Qs

MYSQL

MYSQL

12th Grade

15 Qs

MySQL

MySQL

11th Grade - University

12 Qs

MySQL Practice

MySQL Practice

12th Grade

9 Qs

Pandas - CSV file

Pandas - CSV file

12th Grade

10 Qs

MySQL- group by and foreign key

MySQL- group by and foreign key

Assessment

Quiz

Computers

12th Grade

Hard

Created by

Pavani (CBSE)

Used 20+ times

FREE Resource

13 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

Which clause is used with an "aggregate" function?

GROUP BY

SELECT

WHERE

Both GROUP BY and WHERE

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

What is the meaning of "GROUP BY" clause?

Group data by column values

Group data by row values

Group data by column and row values

None of the mentioned

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

How to select number of employees - department wise from Emp table (EmpNo, DeptNo, EmpName)?

Select empno, count(*) from Emp Group By deptno;

Select deptno, count(*) from Emp Group By deptno;

Select empno, count(*) from Emp Order By deptno;

Select deptno, count(*) from Emp Order By deptno;

4.

MULTIPLE CHOICE QUESTION

20 sec • 1 pt

Null values in GROUP BY fields are omitted.

True

False

5.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

Which statements are true about Group By?

Group By is used to group set of values based on one or more values

Group By is used when we use aggregate functions

Group by does not guarantee sorting the data in any order

All of above

6.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

How to select Maximum Salary of Employee from each Department in Emp table(empno, ename, deptno, sal)?

Select deptno, sal from Emp Group By deptno Order By Max(Sal);

Select deptno, sal from Emp Group By deptno having sal = max(sal);

Select deptno, max(sal) from Emp Group By deptno;

Select deptno, max(sal) from Emp Order By Max(Sal);

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

Which of the following is correct to count the total salary dept wise where there are more than two employees in a dept from emp table (empno, ename, deptno, sal)

SELECT deptno, sum(sal) As totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) = 2

SELECT deptno, sum(sal) As totalsal FROM emp where COUNT(empno) = 2 GROUP BY deptno

SELECT deptno, sum(sal) As totalsal FROM emp GROUP BY deptno HAVING COUNT(empno) > 2

SELECT deptno, sum(sal) As totalsal FROM emp where COUNT(empno) > 2 GROUP BY deptno

Create a free account and access millions of resources

Create resources
Host any resource
Get auto-graded reports
or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?