Login / Sign Up

SQL Questions

View All Languages
Filters:
Tricky

Dirty Read

Open to read the full question, answer, code and follow-ups.

SQL151
#practice#learning
Read
Medium

Non-repeatable Read

Open to read the full question, answer, code and follow-ups.

SQL152
#practice#learning
Read
Tricky

Phantom Read

Open to read the full question, answer, code and follow-ups.

SQL153
#practice#learning
Read
Hard

Serializable

Open to read the full question, answer, code and follow-ups.

SQL154
#practice#learning
Read
Tricky

Read Committed

Open to read the full question, answer, code and follow-ups.

SQL155
#practice#learning
Read
Tricky

Repeatable Read

Open to read the full question, answer, code and follow-ups.

SQL156
#practice#learning
Read
Hard

MVCC

Open to read the full question, answer, code and follow-ups.

SQL157
#practice#learning
Read
Medium

Optimistic Locking

Open to read the full question, answer, code and follow-ups.

SQL158
#practice#learning
Read
Medium

Pessimistic Locking

Open to read the full question, answer, code and follow-ups.

SQL159
#practice#learning
Read
Hard

Deadlocks

Open to read the full question, answer, code and follow-ups.

SQL160
#practice#learning
Read
Hard

Distributed Transactions

Open to read the full question, answer, code and follow-ups.

SQL161
#practice#learning
Read
Hard

Two Phase Commit

Open to read the full question, answer, code and follow-ups.

SQL162
#practice#learning
Read
UltraHard Scenario Based

Banking Transaction Scenario

Open to read the full question, answer, code and follow-ups.

SQL163
#practice#learning
Read
Hard

Recovery

Open to read the full question, answer, code and follow-ups.

SQL164
#practice#learning
Read
Hard

Transaction Logs

Open to read the full question, answer, code and follow-ups.

SQL165
#practice#learning
Read
UltraHard Scenario Based

API is slow because of SQL

Open to read the full question, answer, code and follow-ups.

SQL166
#practice#learning
Read
UltraHard Scenario Based

Find root cause of slow query

Open to read the full question, answer, code and follow-ups.

SQL167
#practice#learning
Read
UltraHard Scenario Based

Optimize JOIN performance

Open to read the full question, answer, code and follow-ups.

SQL168
#practice#learning
Read
UltraHard Scenario Based

High CPU due to SQL

Open to read the full question, answer, code and follow-ups.

SQL170
#practice#learning
Read
UltraHard Scenario Based

Memory issue due to query

Open to read the full question, answer, code and follow-ups.

SQL171
#practice#learning
Read
UltraHard Scenario Based

Missing Index scenario

Open to read the full question, answer, code and follow-ups.

SQL172
#practice#learning
Read
UltraHard Scenario Based

Deadlock investigation

Open to read the full question, answer, code and follow-ups.

SQL173
#practice#learning
Read
Tricky

Customers with no orders

Open to read the full question, answer, code and follow-ups.

SQL174
#practice#learning
Read
Tricky

Second Highest Salary

Open to read the full question, answer, code and follow-ups.

SQL175
#practice#learning
Read
Tricky

Find Duplicate Records

Open to read the full question, answer, code and follow-ups.

SQL177
#practice#learning
Read
Medium

Remove Duplicate Records

Open to read the full question, answer, code and follow-ups.

SQL178
#practice#learning
Read
Hard

Running Balance

Open to read the full question, answer, code and follow-ups.

SQL179
#practice#learning
Read
Hard

Employee Hierarchy

Open to read the full question, answer, code and follow-ups.

SQL180
#practice#learning
Read