
SQL DML Commands Quiz
Authored by DR MURTHY
Computers
12th Grade
Used 10+ times

AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
30 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a DML command?
CREATE
ALTER
INSERT
DROP
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command is used to modify existing records in a table?
INSERT
UPDATE
DELETE
SELECT
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which clause is used in conjunction with DML commands to filter records?
ORDER BY
WHERE
GROUP BY
HAVING
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which DML statement is used to remove records from a table?
DELETE
TRUNCATE
DROP
REMOVE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What will the following SQL statement do? INSERT INTO Students (ID, Name) VALUES (101, 'John');
Delete the student with ID 101
Insert a new student record with ID 101 and Name 'John'
Update the student name to 'John' where ID is 101
Create a new table called Students
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL statement is used to retrieve data from a database?
SELECT
UPDATE
INSERT
DELETE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is true about the DELETE statement?
It removes the table structure from the database
It removes specific records based on a condition
It permanently removes all records without a condition
It cannot be rolled back
Access all questions and much more by creating a free account
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
28 questions
MAWD 1.01 B
Quiz
•
KG - University
25 questions
Computer Technology - 1.அடோப் பேஜ்மேக்கர்
Quiz
•
12th Grade
25 questions
DMI - Quiz SAS
Quiz
•
12th Grade
25 questions
Basic HTML 2
Quiz
•
7th - 12th Grade
25 questions
TIK SMP
Quiz
•
7th - 12th Grade
25 questions
Intro to Business Computer Applications Final Review
Quiz
•
9th - 12th Grade
25 questions
SPREADSHEET
Quiz
•
12th Grade
25 questions
Ujian PD TIK-1
Quiz
•
12th Grade
Popular Resources on Wayground
7 questions
History of Valentine's Day
Interactive video
•
4th Grade
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
fractions
Quiz
•
3rd Grade
15 questions
Valentine's Day Trivia
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
Discover more resources for Computers
18 questions
Valentines Day Trivia
Quiz
•
3rd Grade - University
20 questions
-AR -ER -IR present tense
Quiz
•
10th - 12th Grade
21 questions
Presidents Day Trivia
Quiz
•
6th - 12th Grade
10 questions
Valentine's Day: History and Modern Celebration
Interactive video
•
9th - 12th Grade
11 questions
Valentine's Day Trivia
Quiz
•
8th - 12th Grade
10 questions
Factor Quadratic Expressions with Various Coefficients
Quiz
•
9th - 12th Grade
18 questions
Success Strategies
Quiz
•
9th - 12th Grade
10 questions
Valentine's Day Trivia
Quiz
•
9th - 12th Grade