SQL Basics Quiz
Authored by Nikko Nicdao
Other
University
Used 6+ 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
What does SQL stand for?
Structured Query List
Simple Query Language
Structured Query Language
Standard Query Language
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL clause is used to filter records based on a specific condition?
SELECT
WHERE
FILTER
ORDER
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL statement is used to insert a new record into a table?
ADD
INSERT INTO
UPDATE
NEW RECORD
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL constraint ensures that all values in a column are unique?
NOT NULL
FOREIGN KEY
UNIQUE
DEFAULT
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command is used to delete all records from a table but keep its structure?
DELETE
DROP
CLEAR
TRUNCATE
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL JOIN returns all records when there is at least one match in both tables?
LEFT JOIN
RIGHT JOIN
FULL JOIN
INNER JOIN
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following triggers is executed before inserting a new row?
AFTER INSERT
BEFORE INSERT
AFTER UPDATE
BEFORE DELETE
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
Already have an account?
