Core CS Subjects Interview Revision

Campus & Technical Rounds

High-yield Operating Systems, DBMS & SQL, Computer Networks, and OOP interview cheat sheets.

Revision Progress
0/ 6 Questions
Operating Systems
0/ 2 Reviewed

Threads, Deadlocks, Virtual Memory

DBMS & SQL
0/ 2 Reviewed

ACID, Indexing, B-Trees, Normalization

Networks & OOP
0/ 2 Reviewed

TCP Handshake, DNS, SOLID Principles

Operating SystemsProcesses vs Threads

What is the fundamental difference between a Process and a Thread?

Operating SystemsDeadlocks

What are the 4 Coffman conditions required for a Deadlock to occur?

DBMS & SQLACID Properties

Explain the ACID properties of relational database management systems.

DBMS & SQLB-Tree vs B+ Tree Indexing

Why do modern databases (PostgreSQL, MySQL InnoDB) use B+ Trees instead of B-Trees for disk indexing?

Computer NetworksTCP 3-Way Handshake & 4-Way Teardown

How does the TCP 3-Way Handshake establish a reliable connection?

Computer NetworksHTTP/1.1 vs HTTP/2 vs HTTP/3

What performance problems in HTTP/1.1 did HTTP/2 and HTTP/3 solve?