Database Week 3 Quiz
Quiz
•
Instructional Technology
•
University
•
Medium
Gerald Gerald
Used 12+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
Which function would you use to calculate the total revenue from all sales?
COUNT
SUM
AVG
MIN
2.
MULTIPLE CHOICE QUESTION
30 sec • 10 pts
To analyze sales data by product category, you would use the:
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
3.
MULTIPLE CHOICE QUESTION
1 min • 10 pts
If you want to find the average transaction amount for customers who spent more than $1000, you would use the:
WHERE clause
GROUP BY clause
HAVING clause
ORDER BY clause
4.
MULTIPLE CHOICE QUESTION
1 min • 20 pts
To calculate the total revenue and the average transaction amount for each product category, you would use:
GROUP BY product_category
GROUP BY product_category, SUM(revenue), AVG(transaction_amount)
SELECT SUM(revenue), AVG(transaction_amount) GROUP BY product_category
SELECT product_category, SUM(revenue), AVG(transaction_amount)
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the largest country in Africa by land area?
Nigeria
Algeria
South Africa
Democratic Republic of Congo
6.
MULTIPLE CHOICE QUESTION
30 sec • 9 pts
Who was the first African leader to win the Nobel Peace Prize?
Nelson Mandela
Albert Luthuli
Desmond Tutu
Kofi Annan
7.
MULTIPLE CHOICE QUESTION
30 sec • 4 pts
Which African country is known for its traditional Kente cloth?
Ghana
Nigeria
South Africa
Kenya
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
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
Similar Resources on Wayground
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
MINERS Core Values Quiz
Quiz
•
8th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
Discover more resources for Instructional Technology
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
7 questions
Central Idea of Informational Text
Interactive video
•
4th Grade - University
20 questions
Physical or Chemical Change/Phases
Quiz
•
8th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
39 questions
Unit 7 Key Terms
Quiz
•
11th Grade - University
7 questions
Transition Words and Phrases
Interactive video
•
4th Grade - University
18 questions
Plotting Points on the Coordinate Plane
Quiz
•
KG - University
5 questions
Declaration of Independence
Interactive video
•
4th Grade - University
