JobPrax
SQL Constraints — practice questions · JobPrax
JobPrax
Practice
Live projects
Guided projects
For colleges
Pricing
Log in
Start free
All SQL topics
SQL
Constraints
PRIMARY KEY, NOT NULL, UNIQUE, CHECK, DEFAULT and FOREIGN KEY.
Your progress
0
/ 40
Start the first question
All levels
Basic (27)
Intermediate (8)
Advanced (5)
All
To do
Solved
1
Primary key
Basic
2
Required columns
Basic
3
Unique email
Basic
4
Default value
Basic
5
No negative prices
Basic
6
Rating between 1 and 5
Basic
7
Allowed values only
Basic
8
Text primary key
Basic
9
Two required columns
Basic
10
Unique phone
Basic
11
Default status
Basic
12
Adults only
Basic
13
Positive quantity
Basic
14
Start at zero
Basic
15
Required and unique
Basic
16
Link to another table
Basic
17
Percent from 0 to 100
Basic
18
Not done yet
Basic
19
Let the default work
Basic
20
Allowed sizes
Basic
21
Seat bookings
Basic
22
Menu prices
Basic
23
Today by default
Basic
24
Newsletter subscribers
Basic
25
Six-digit PIN code
Basic
26
Phones and brands
Basic
27
Minimum stipend
Basic
28
Composite primary key
Intermediate
29
Foreign key
Intermediate
30
Unique across two columns
Intermediate
31
Dates in the right order
Intermediate
32
Default date and flag
Intermediate
33
Salary rules
Intermediate
34
Find the broken rows
Intermediate
35
Which emails are duplicated?
Intermediate
36
Orders with line items
Advanced
37
Self-referencing manager
Advanced
38
Valid Indian mobile numbers
Interview
Advanced
39
Load only valid rows
Advanced
40
Library design
Interview
Advanced