Clauses in MySQL
Quiz
•
Computers
•
12th Grade
•
Practice Problem
•
Medium
Prathima Agraharapu
Used 23+ times
FREE Resource
Enhance your content in a minute
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

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
JSPS Competition Hackathon - Scratch Language - Grade 1
Quiz
•
2nd Grade - University
10 questions
cybercrime
Quiz
•
12th Grade - University
10 questions
Microcontroller
Quiz
•
11th Grade - University
10 questions
Review Quiz #2- Productivity Tools
Quiz
•
11th - 12th Grade
11 questions
Chapter 6 Part 2 - 4
Quiz
•
11th - 12th Grade
10 questions
BTEC IT L3 The implications of using on Cloud Services online
Quiz
•
12th Grade
10 questions
Initial Assessment
Quiz
•
12th Grade - University
11 questions
Ms. Excel
Quiz
•
12th Grade
Popular Resources on Wayground
5 questions
This is not a...winter edition (Drawing game)
Quiz
•
1st - 5th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
10 questions
Identify Iconic Christmas Movie Scenes
Interactive video
•
6th - 10th Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
11 questions
How well do you know your Christmas Characters?
Lesson
•
3rd Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
20 questions
How the Grinch Stole Christmas
Quiz
•
5th Grade
Discover more resources for Computers
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
15 questions
Christmas Song Emoji Pictionary
Quiz
•
7th - 12th Grade
20 questions
Christmas Movies
Quiz
•
1st - 12th Grade
55 questions
CHS Holiday Trivia
Quiz
•
12th Grade
20 questions
Christmas Movie Trivia
Quiz
•
9th - 12th Grade
29 questions
christmas facts
Lesson
•
5th - 12th Grade
20 questions
Christmas Trivia
Quiz
•
5th - 12th Grade
20 questions
Stages of Meiosis
Quiz
•
9th - 12th Grade
