JobPrax
SQL INSERT, UPDATE & DELETE — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
INSERT, UPDATE & DELETE
Add, change and remove rows safely.
Your progress
0
/ 40
Start the first question
All levels
Basic (27)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Insert one row
Basic
2
Insert several rows
Basic
3
Insert into chosen columns
Basic
4
Update one row
Basic
5
Update with a calculation
Basic
6
Delete rows
Basic
7
Update several columns
Basic
8
New department
Basic
9
New project
Basic
10
Change one salary
Basic
11
Moved to a new city
Basic
12
Cancel a project
Basic
13
Remove the interns
Basic
14
Raise for a role
Basic
15
Office move
Basic
16
10% raise for HR
Basic
17
Project finished
Basic
18
Drop small assignments
Basic
19
Order delivered
Basic
20
Restock
Basic
21
Add a product
Basic
22
Clear cancelled orders
Basic
23
Stationery sale
Basic
24
Add a phone number
Basic
25
Two new subjects
Basic
26
Correct a mark
Basic
27
Fee received
Basic
28
Fill in missing values
Intermediate
29
Insert from a query
Intermediate
30
Update using another table
Intermediate
31
Delete using another table
Intermediate
32
Conditional update
Intermediate
33
Remove exact duplicates
Intermediate
34
Stock after an order
Intermediate
35
Archive and delete
Intermediate
36
Upsert a price list
Advanced
37
Keep the latest record
Interview
Advanced
38
Salary band correction
Advanced
39
Reassign a manager's team
Advanced
40
Monthly summary table
Interview
Advanced