Technical Question Bank · Peer-Reviewed

Job Interview Questions and Answers Directory

Search and filter frequently asked interview questions across technical, programming, and behavioral domains. Tailor your interview preparation by difficulty for freshers or experienced developers (3 available).

Filters

Keyword Category Difficulty Type Sort by

Reset

Active: Tag: locking ×

Redis Hard coding

Q1. How do you implement a distributed lock with Redis?

A common implementation is SET key value NX PX ttl. NX sets the key only if it does not exist, and PX gives the lock an expiry so a crashed holder cannot deadlock the sys...

2 Answer

DBMS Medium technical

Q2. What causes a database deadlock and how do you prevent one?

A database deadlock is a cycle where two or more transactions each hold a lock the other needs, so neither can proceed. ```text T1: UPDATE a; UPDATE b; T2: UPDATE b; UPDA...

1 Answer

DBMS Medium technical

Q3. Compare optimistic and pessimistic locking.

Both approaches handle concurrent updates to the same data. Pessimistic locking assumes conflicts are likely, so it locks a row when read: `SELECT ... FOR UPDATE` or a sh...

0 Answer