Autocoder

CS Fundamentals Interview Questions: DBMS, OS and More

Last updated 2026-11-19

Technical interviews for freshers rarely stop at coding. Interviewers move to the subjects you studied for your degree: database management systems, operating systems, computer networks and object-oriented programming. These subjects are tested because they explain how real systems behave, and because they are a quick way to tell whether a candidate understood the course or only passed it.

The guides in this section take each subject and, where it is large, split it into subtopics such as normalisation and transactions in DBMS, or scheduling and deadlocks in operating systems. Each question has a worked answer written the way you could say it in an interview: a definition, a reason it matters and a short example.

How to answer a fundamentals question

Use a three-part structure: say what it is in one sentence, say why it exists or what problem it solves, then give a short example. For instance, a deadlock is a state where processes wait on each other forever; it arises when four conditions hold together; and a classic example is two threads each holding one lock and wanting the other. That structure sounds confident and leaves the interviewer a natural follow-up to ask.

The subjects that come up most

Prefer understanding to definitions

Textbook definitions are a starting point, but follow-up questions test understanding. If you say that an index speeds up queries, expect to be asked what it costs on writes and when it would not help. When you practise, ask yourself the follow-up before reading the worked answer.

Pair theory with something you can run

Where possible, try the idea on a real system. Write a small SQL schema and run a join, observe a query plan, use a command line tool to inspect a connection, or write two threads that deadlock on purpose. Hands-on memory is more durable than reading, and it gives you real examples to mention.

Where this fits in your preparation

Fundamentals usually come after the coding round in a typical technical interview, so they are where a borderline candidate is decided. Cover them alongside DSA practice and the language guides, and revisit them in the final week before any interview.

All 50 guides in this section

Frequently asked questions

Which CS subjects matter most for placements?

DBMS, operating systems, computer networks and object-oriented programming appear most often, with DBMS and SQL being the most reliably tested.

How detailed should my answers be?

Give a one-sentence definition, the reason it exists and one example. Stop there and let the interviewer ask for more.

Do I need to memorise every normal form?

Know the first three normal forms and BCNF well enough to explain with a small table. Higher forms are rarely asked at fresher level.

Are networks questions asked for software roles?

Yes, usually at a basic level such as TCP versus UDP, HTTP and what happens when you open a web page. Know those thoroughly.

Related guides