CSE Core Subjects Interview Questions (DBMS,CN,OS..)

Here in this post we will discuss CSE important interview questions,CSE core subjects interview questions like important Database Management System (DBMS) interview questions, important Operating Systems (OS) interview questions,important Computer Networks (Network and Communication) interview questions, important Software Engineering interview questions.

Before Going to the Questions Let me remind you that it is important that you read the JOB DESCRIPTIONS before you start preparing for example some companies like D.E. Shaw  Generally They Don’t Ask Computer Networks Most of the Time but Read Job Description First , If Necessary in Job Description or You Have time to prepare for it then You Can Prepare. (CISCO Company Focus on Computer Networks, so For that You Must Have to Study this subject.)

Important Database Management System (DBMS) Interview Questions

1. What is DBMS ? How it is Different from Data Structures.
2. Difference Between Database and Database Management System ?
3. Main Memory and Secondary Memory.
4. Basic Functionality and Advantages of DBMS i.e. Data Retrieve , Delete , Insert
(Functionality) and Remove Redundancy , Easy access ( Advantages)
5. DBMS Two Level and Three Level Architecture.
6. Entity Relationship Model (ER Model , Know the Basics i.e What is Entity , Attributes
and Cardinality) (Hint : They won’t ask You to make Complex ER diagram)
7. Relational Model ( Difference b/w ER model and Relational Model)
8. All type of Keys in Relational Model ( Primary Key , Super Key , Candidate Key , Foreign
Key) (Hint : Important)
9. Armstrong Axioms and All type of Functional Dependencies (Transitive and Relative)
10. Database Anomalies ( Insert , Delete and Update)
11. Normalization -> What is Normalization ? Why do we need Normalization ?
12. All the Types of Normalization , 1NF , 2NF , 3NF and BCNF. (Hint : They won’t ask you
to Convert the Functions into 1NF , 2NF and All , Just Know the Basics of Each Normal
Form & It Would Be Better if you Understand Every NF Form with an Example)
(Important topic)
13. SQL Queries ( Learn with one example of Each Query , Not Much, Best Resource :
SQL w3 Resource )
14. File Structures in Database ( Indexing , Sparse Indexing , B- Tree , B+ trees) (Source
GFG)
15. Transactions , Operations of Transactions , Transaction’s ACID Properties
(Important)
16. State of Transactions i.e Committed , partially Committed
17. Concurrency Control , Lock and all over Transactions

Main topics  from DBMS that you should never miss

1. Normalization .All the Types of Normalization , 1NF , 2NF , 3NF and BCNF
2. SQL Queries
3. Transactions , Operations of Transactions , Transaction’s ACID Properties
4. . File Structures in Database ( Indexing , Sparse Indexing , B- Tree , B+ trees)

Important Computer Networks (CN) Interview Questions

1. What is Computer Networks (LAN , WAN and MAN)
2. Network Topologies (Star , Bus etc.)
3. Translation Modes in Networks (Simplex , Duplex and Half Duplex)
4. TCP/IP vs OSI Model (Most Important)
5. Functionality of All the OSI Layers (Important : Those are Mentioned Below 6 – )
6. Stop and Wait HRQ , Selective Repeat Protocol , Sliding Window , Go Back N (Data Link
   Layer)
7. IPV4 vs IPV6 (Network Layer) (Important)
8. . TCP vs UDP (Transport Layer) (Important)
9. Domain Name System (DNS) ,HTTP ,DHCP (Application Layer) (Important)
10. (Optional : Have some basic Knowledge of Subnetting and IP Addressing)

Main topics  from Computer Networks (CN) that you should never miss

1. TCP/IP vs OSI Model
2. Functionality of All the OSI Layers
3. TCP vs UDP
4. Network Topologies
5. IPV4 vs IPV6

YOU MIGHT ALSO LIKE :

PAYPAL INTERVIEW AND CODING QUESTIONS

Wells Fargo Interview Experience

Amdocs Recruitment process , Amdocs Interview Questions

 

Important Operating System (OS) Interview Questions

1. 1. What is Operating System and Its Types (MultiProcessing ,MultiTasking and All)
2. 2. Process and Threads in OS , Process State , Process Control Block and Context
3. Switching (Threading is Important Topic)
4. Process Scheduling ( All the Job Scheduling Algorithms )
5. Important Scheduling Algos ( SJF , SRTF , FCFS , LJF(Longest Job First) and Round Robin Scheduling)
6. Process Synchronization , Critical Section , Inter Process Communication , Locks for Synchronization (Semaphore and Mutex) and Monitors (Important)
7. DeadLock , Characteristics of DeadLock , Handling and Recovery from Deadlock
8. Memory Management in Operating System
9. First Fit , Best Fit, Next Fit and Worst Fit in Operating System (Important)
10. Paging in Memory Management (Concept of Virtual memory) (Important)
11. Demand Paging , Thrashing and Page Replacement Algo (FCFS and LRU Algorithm)
12. Segmentation in Memory Management and Translation Lookaside Buffer (TLB)

YOU MIGHT ALSO LIKE :

PAYPAL INTERVIEW AND CODING QUESTIONS

Wells Fargo Interview Experience

Amdocs Recruitment process , Amdocs Interview Questions

 

Main topics  from  Operating System (OS) that you should never miss

1.  Process and Threads in OS , Process State , Process Control Block and Context
2. Important Scheduling Algos ( SJF , SRTF , FCFS , LJF(Longest Job First) and Round Robin Scheduling)
3. Process Synchronization , Critical Section,Locks for Synchronization (Semaphore and Mutex)
4. Paging in Memory Management (Concept of Virtual memory) (Important)
5. Demand Paging , Thrashing and Page Replacement Algo (FCFS and LRU Algorithm)
6. PROCESS VS THREADS( most asked in interview)
7. user level threads vs kernel level threads

Important Software Engineering (SE) Interview Questions(According to Job Description if Necessary / Imp. in HR Round)

1. What is Software Engineering and why do we need it ? (HR Question)
2. Software Development Life Cycle (SDLC)
3. SDLC Models (Important)
4. Waterfall Model , V Model , Iterative Model , Spiral Model and Agile Model(Important)
5. Why is the Agile Model Important and Better ?

6. Quality assurance and testing (QTE) – If You are Applying for this Post then You
Should have Knowledge about BlackBox and Whitebox Testing.
7. What is Software Requirement Specification (SRS Document)
8. Use Software Engineering Basics While giving Explanation of Your Projects (Example
Below)
9. Example : Me and My Team thought of Making this XYZ Project . So I made one SRS
Document for requirements. Which Model You Used (Tell agile Cause it is Best Model) .
Then tell We Tested this. ( Complete Idea with Software Engineering) (Very Much Important in CV and HR Round)

YOU MIGHT ALSO LIKE :

PAYPAL INTERVIEW AND CODING QUESTIONS

Wells Fargo Interview Experience

Amdocs Recruitment process , Amdocs Interview Questions

 

IMPORTANT NOTE: No Need to Go Deep in Any of the Topic Mentioned Above. Just try to Understand the Meaning and working of every topic with an Example.Majorly Questions will be  Basic Only. Don’t Fear Much. Just Cover the Basics.

Here we have discussed Important  CSE Core subject interview questions ( important Database Management System (DBMS) interview questions, important Operating Systems (OS) interview questions,important Computer Networks (Network and Communication) interview questions, important Software Engineering interview questions).For any information you can Connect with me on LinkedIn for More updates.

LINKEDIN LINK:https://www.linkedin.com/in/soubhik-baral-b82a87133/

YOU CAN ALSO CHECK OUR INTERVIEW QUESTION SECTION FOR MORE COMPANY QUESTIONS