
MySQL Easy-Advanced Mix
Quiz
•
Other
•
University
•
Practice Problem
•
Hard
ICS Med.
Used 2+ times
FREE Resource
Enhance your content in a minute
75 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which command is used to create a new database in MySQL?
MAKE DATABASE
NEW DATABASE
CREATE DATABASE
BUILD DATABASE
2.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What command is used to display all available databases?
SHOW DATABASES
LIST DATABASE
DISPLAY DATABASE
SELECT DATABASE
3.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which SQL statement is used to add new records to a table?
INSERT NEW
INSERT INTO
ADD RECORD
CREATE ROW
4.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which clause is used to filter records in a SELECT statement?
ORDER BY
WHERE
GROUP BY
HAVING
5.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What command deletes all rows from a table but not the table itself?
DROP TABLE
REMOVE TABLE
DELETE TABLE
TRUNCATE TABLE
6.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
Which function returns the total number of rows in a result set?
SUM()
TOTAL()
COUNT()
NUMBER()
7.
MULTIPLE CHOICE QUESTION
20 sec • 1 pt
What type of JOIN returns all records that have matching values in both tables?
FULL JOIN
LEFT JOIN
RIGHT JOIN
INNER JOIN
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
75 questions
Brainbusters
Quiz
•
University
71 questions
What is the Criminal Process?
Quiz
•
8th Grade - University
75 questions
Rita4,5 PM
Quiz
•
University - Professi...
71 questions
HSC 109 Promotion of Safety/Infection Control
Quiz
•
University
70 questions
Static GK Quiz-1 (History, Geography, General Science)
Quiz
•
11th Grade - Professi...
80 questions
Reviewer Long Quiz ELEC 02 LC
Quiz
•
University
70 questions
Introduction to Psychology Sensations & Perceptions QUIZ
Quiz
•
University
79 questions
chapter 17: Hair Styling
Quiz
•
University
Popular Resources on Wayground
25 questions
Multiplication Facts
Quiz
•
5th Grade
15 questions
4:3 Model Multiplication of Decimals by Whole Numbers
Quiz
•
5th Grade
10 questions
The Best Christmas Pageant Ever Chapters 1 & 2
Quiz
•
4th Grade
12 questions
Unit 4 Review Day
Quiz
•
3rd Grade
20 questions
Christmas Trivia
Quiz
•
6th - 8th Grade
18 questions
Kids Christmas Trivia
Quiz
•
KG - 5th Grade
14 questions
Christmas Trivia
Quiz
•
5th Grade
15 questions
Solving Equations with Variables on Both Sides Review
Quiz
•
8th Grade
Discover more resources for Other
26 questions
Christmas Movie Trivia
Lesson
•
8th Grade - Professio...
7 questions
Different Types of Energy
Interactive video
•
4th Grade - University
7 questions
Transition Words and Phrases
Interactive video
•
4th Grade - University
7 questions
Force and Motion
Interactive video
•
4th Grade - University
7 questions
Biomolecules (Updated)
Interactive video
•
11th Grade - University
34 questions
Unit 5 Review - The Middle Ages in Europe-B
Quiz
•
9th Grade - University
26 questions
Day2 classwork: Permutation and combination
Quiz
•
2nd Grade - University
5 questions
Using Context Clues
Interactive video
•
4th Grade - University
