Clauses in MySQL

Clauses in MySQL

12th Grade

10 Qs

quiz-placeholder

Similar activities

MYSQL FUNCTIONS

MYSQL FUNCTIONS

12th Grade

15 Qs

SQL JOIN, Order By, Group By

SQL JOIN, Order By, Group By

12th Grade

15 Qs

2022-10-19_12D_SQL

2022-10-19_12D_SQL

9th - 12th Grade

15 Qs

Citizenship

Citizenship

9th - 12th Grade

13 Qs

Bits and Bytes

Bits and Bytes

9th - 12th Grade

15 Qs

SQL check

SQL check

12th Grade

11 Qs

Excel Formatting

Excel Formatting

12th Grade

11 Qs

SQL Quiz 3

SQL Quiz 3

12th Grade

10 Qs

Clauses in MySQL

Clauses in MySQL

Assessment

Quiz

Computers

12th Grade

Medium

Created by

Prathima Agraharapu

Used 23+ times

FREE Resource

10 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

salary between 1000 and 30000

where

group by

having

none

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

group by is used to

group similar records

group null values only

to add the records

to delete the records

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

aggregate function

instr()

min()

date()

pow()

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

aggregate functions are applied on multiple rows and they generate single value

True

False

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

having is used only when

string functions are there

numeric functions are there

aggregate functions are there

date functionsa re there

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

average salary

distinct

where

avg(sal)

group by

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

number of students under each grade

where

group by

having

none

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?