OOPs DBMS OS topics
OOPs, DBMS, OS Most Frequuently asked topics in interviews for technical rounds
Here’s a well-organized list of the most frequently asked topics in interviews for OOPs, DBMS, and
OS technical rounds, based on patterns from companies like TCS, Infosys, Accenture, IBM, and other IT
firms.
1. OOPs (Object-Oriented Programming)
Focus on concepts, design, and practical scenarios.
Core Topics:
1. Class & Object – Definition, examples, difference between class and object.
2. Inheritance – Types: single, multiple, multilevel, hierarchical; super keyword; method overriding.
3. Polymorphism
Compile-time (Method Overloading)
Runtime (Method Overriding)
4. Encapsulation – Access modifiers, getters and setters, benefits.
5. Abstraction – Abstract classes vs interfaces, usage.
6. Constructors & Destructors – Types and order of execution.
7. Static vs Non-static members – Variables, methods, and blocks.
8. Association, Aggregation, Composition – Differences and examples.
9. Access Modifiers – Private, Protected, Public, Default.
10. OOP Design Principles – SOLID principles (sometimes asked in advanced interviews).
Frequently Asked OOP Questions:
Difference between abstraction and encapsulation.
Difference between interface and abstract class.
Real-life example of polymorphism.
Diamond problem in multiple inheritance (C++/Java context).
Why use final keyword in Java.
2. DBMS (Database Management System)
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 1/3
Focus on SQL basics, normalization, and transactions.
Core Topics:
1. Normalization – 1NF, 2NF, 3NF, BCNF; examples.
2. SQL Queries – SELECT, JOINs (INNER, LEFT, RIGHT, FULL), GROUP BY, HAVING.
3. Indexes – Clustered vs Non-clustered, benefits, drawbacks.
4. Transactions & ACID properties – Atomicity, Consistency, Isolation, Durability.
5. Keys – Primary, Foreign, Candidate, Composite.
6. Views & Stored Procedures – Uses and examples.
7. Triggers – When and why used.
8. DBMS Concepts – DBMS vs RDBMS, normalization vs denormalization.
9. Locking & Concurrency – Deadlock, pessimistic vs optimistic locking.
10. ER Diagrams – Entities, attributes, relationships.
Frequently Asked DBMS Questions:
Difference between DELETE, TRUNCATE, and DROP.
Difference between PRIMARY KEY and UNIQUE key.
Difference between INNER JOIN and OUTER JOIN.
Example of normalization.
Explain isolation levels (Read Uncommitted, Read Committed, Repeatable Read, Serializable).
3. OS (Operating System)
Focus on core OS concepts and process management.
Core Topics:
1. Process & Thread – Difference, lifecycle, states.
2. CPU Scheduling Algorithms – FCFS, SJF, Round Robin, Priority.
3. Deadlock – Conditions, prevention, avoidance, detection.
4. Memory Management – Paging, Segmentation, Virtual Memory.
5. File System – Types of files, file operations.
6. Multithreading & Synchronization – Mutex, Semaphore, Critical Section.
7. Paging & Segmentation – Address translation, page table.
8. Interrupts – Types and uses.
9. Deadlock Handling – Banker’s algorithm.
10. Processes vs Threads – Differences, benefits of multithreading.
Frequently Asked OS Questions:
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 2/3
Difference between process and thread.
Explain context switching.
Difference between preemptive and non-preemptive scheduling.
Explain a page fault.
Explain semaphore vs mutex.
✅ Tips for Preparation:
Revise concepts first, then look at most common interview questions.
Practice real-time examples for OOP and OS.
Write SQL queries manually and understand output.
Be ready to explain your answer clearly with a small example.
If you want, I can create a single-page “Most Important Topics + Questions Cheat Sheet” for OOPs,
DBMS, and OS that covers 90% of what companies ask in technical rounds.
Do you want me to do that?
Printed using ChatGPT to PDF, powered by PDFCrowd HTML to PDF API. 3/3