89. Database - SQL Insert, Update, Delete Quiz

Passage
•
Computers
•
9th Grade
•
Medium
Andy Workman
Used 5+ times
FREE Resource
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'
Create a free account and access millions of resources
Similar Resources on Wayground
10 questions
G9_Troubleshooting

Quiz
•
9th Grade
12 questions
Python Level 1 Quiz #6

Quiz
•
5th - 12th Grade
7 questions
Minecraft 1.16.0

Quiz
•
KG - Professional Dev...
15 questions
Soal tentang Blog kelas 9

Quiz
•
9th Grade
10 questions
Social Engineering or Malware?

Quiz
•
9th Grade
15 questions
A-Level Comp Sci 9618 Databases

Quiz
•
9th - 12th Grade
7 questions
QUIZZ TIK KLS 9

Quiz
•
9th Grade
15 questions
F3 ICT

Quiz
•
KG - 10th Grade
Popular Resources on Wayground
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
10 questions
Nouns, nouns, nouns

Quiz
•
3rd Grade
10 questions
9/11 Experience and Reflections

Interactive video
•
10th - 12th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
11 questions
All about me

Quiz
•
Professional Development
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
9 questions
Tips & Tricks

Lesson
•
6th - 8th Grade
Discover more resources for Computers
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade
20 questions
Digital Citizenship

Quiz
•
8th - 12th Grade
30 questions
Introduction to Computers

Quiz
•
8th - 9th Grade
35 questions
Computer Baseline Examination 2025-26

Quiz
•
9th - 12th Grade
13 questions
Problem Solving Process

Quiz
•
9th - 12th Grade
20 questions
Hardware vs. Software Quiz

Quiz
•
7th - 10th Grade
10 questions
Understanding Algorithms with Pseudocode and Flowcharts

Interactive video
•
9th - 12th Grade