JobPrax
SQL ALTER, DROP & views — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
ALTER, DROP & views
Change table structure and save queries as views.
Your progress
0
/ 40
Start the first question
All levels
Basic (27)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Add a column
Basic
2
Add a column with a default
Basic
3
Drop a column
Basic
4
Rename a column
Basic
5
Rename a table
Basic
6
Drop a table
Basic
7
Your first view
Basic
8
Add a phone column
Basic
9
Discount starting at zero
Basic
10
Remove a column
Basic
11
New column name
Basic
12
New table name
Basic
13
Delete a whole table
Basic
14
View of Mumbai staff
Basic
15
View of delivered orders
Basic
16
Remove a view
Basic
17
Head count column
Basic
18
Phone becomes mobile
Basic
19
Grade column
Basic
20
Country for everyone
Basic
21
Drop the stock column
Basic
22
Customers become clients
Basic
23
Prices with GST
Basic
24
Prices with decimals
Basic
25
Remote flag
Basic
26
View of running projects
Basic
27
Drop only if it exists
Basic
28
Change a column's type
Intermediate
29
Make a column required
Intermediate
30
Set a default later
Intermediate
31
Add and fill a column
Intermediate
32
View with a join
Intermediate
33
Aggregated view
Intermediate
34
Replace a view
Intermediate
35
Drop a column safely
Intermediate
36
Add a primary key later
Advanced
37
Split a full name
Advanced
38
Rebuild a table with a new column order
Advanced
39
View of department KPIs
Interview
Advanced
40
Views stay up to date
Advanced