SQL Data Manipulation Commands Quiz
Authored by Benhar undefined
Information Technology (IT)
University
Used 6+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What command is used to add new rows to a table?
UPDATE
SELECT
INSERT INTO
DELETE
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command retrieves values from a table?
SELECT
INSERT
UPDATE
DELETE
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What does the DISTINCT operator do in a SELECT statement?
Retrieves values in order
Retrieves values with conditions
Retrieves unique values
Retrieves all values
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL clause is used to filter records based on a condition?
ORDER BY
WHERE
DISTINCT
LIKE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the purpose of the IS NULL operator in SQL?
To sort records
To retrieve all records
To check if a field is not empty
To check if a field is empty
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
How would you select all students in sections IT101, IT102, and IT103?
SELECT * FROM Students WHERE Section BETWEEN 'IT101' AND 'IT103'
SELECT * FROM Students WHERE Section LIKE 'IT10%'
SELECT * FROM Students WHERE Section IN ('IT101', 'IT102', 'IT103')
SELECT * FROM Students WHERE Section = 'IT101' OR Section = 'IT102' OR Section = 'IT103'
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What SQL command would you use to modify existing records?
SELECT
UPDATE
DELETE
INSERT
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 Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
