
89. Database - SQL Insert, Update, Delete Quiz
Authored by Andy Workman
Computers
9th Grade
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 keyword is used to insert data into a table in SQL?
add
insert
update
select
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What keyword is used to update information in a table in SQL?
modify
change
set
update
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What keyword is used to delete records from a table in SQL?
remove
erase
delete
clear
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
When inserting data into a table, what keyword is used to specify the values being inserted?
input
values
set
define
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In SQL, what keyword is used to specify the condition for updating or deleting records?
where
if
condition
check
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct SQL command to add a new record to the 'world' table with the given information: name of the country - ours, capital - Emerald City, population - 1 million?
add to world values ('ours', 'Emerald City', 1 million')
insert into world ('ours', 'Emerald City', 1 million')
add record to world ('ours', 'Emerald City', 1 million')
insert into world values ('ours', 'Emerald City', 1 million')
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the correct SQL command to update the population to 2 million and the name to Wonderland for any country with the capital of Emerald City?
update world set population = 2 million, name = Wonderland where capital = Emerald City
update world set population = '2 million', name = 'Wonderland' where capital = 'Emerald City'
update world set population = 2 million, name = 'Wonderland' where capital = 'Emerald City'
update world set population = '2 million', name = 'Wonderland' where capital = 'Emerald City'
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
11 questions
ICT
Quiz
•
5th - 9th Grade
14 questions
History of Technology
Quiz
•
7th - 12th Grade
12 questions
Types of Computers - Super - Desktop
Quiz
•
9th Grade
15 questions
Information Technology 1- Class 9
Quiz
•
5th - 10th Grade
10 questions
Online Communication
Quiz
•
6th - 9th Grade
10 questions
Why digital portfolios?
Quiz
•
KG - 12th Grade
7 questions
LAN and WAN
Quiz
•
8th - 12th Grade
11 questions
Code.org CS Discoveries U3L12 Sprite Movement
Quiz
•
9th Grade
Popular Resources on Wayground
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
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
20 questions
Figurative Language Review
Quiz
•
6th Grade