Course module
Paper 2 | DataBase Management System/DBMS — IOCL Engineers/Officers (Grade A) 2026 – Computer Science (Paper 1 + Paper 2)
Explore the module outline and lessons below. Enroll free to begin studying here.
Return to /learn/IOCL-ENGINEERS-OFFICERS-GRADE-A-PAPER-2/database-management-systemdbms after enrolling
- Lessons
- 267
- Duration
- 22 hr 37 min
- PYQs
- 0
- Practice
- 1242
Exam importance: 4.2% of the exam, based on section capacity, PYQ history and paper recency.
Syllabus index
Lessons in this module
Basics of DBMS
DBMS Fundamentals
Types & DBA Functions
Data Model, Architecture & Components
FoxPro
ER Diagram
ER Modeling Fundamentals
Cardinalities, Participation & Entity Strength
Conversion of ER Diagram into Relational Model
Relational Model & Functional Dependencies
Basics of Relational Model & Anomalies
Functional Dependencies & Axioms
- Functional Dependencies & AxiomsPdf
- What Is Functional DependencyDrm Video
- Understanding Functional Dependency FurtherDrm Video
- What Is Trivial Functional DependencyDrm Video
- Practice Questions Functional DependencyDrm Video
- Understanding Armstong Axioms notesPdf
- Understanding Armstrong's AxiomsDrm Video
- Gate 2000Drm Video
Attribute Closure & Equivalence of Sets
- Attribute Closure & Equivalence of SetsPdf
- Closure Set of AttributesDrm Video
- Practice Questions Functional DependencyDrm Video
- Comparing Two Set Of Functional DependenciesDrm Video
- Practice QuestionsDrm Video
- Practice Questions on Functional DependenciesDrm Video
- Practice Questions Functional DependencyDrm Video
Minimal Cover (Canonical Cover)
Keys & Integrity Constraints
Super Key, Candidate Key & Primary Key
Foreign Key & Referential Integrity
Composite & Alternate Keys
Normalization (1NF - BCNF)
Codd’s 12 Rules
Introduction to Normalization & 1NF
Second Normal Form (2NF)
Third Normal Form (3NF)
Decomposition Properties & 4NF
Multivalued Dependency (MVD) & 4NF
Fifth Normal Form (5NF)
Lossless Join Decomposition
Dependency Preserving Decomposition
File Organization & Indexing
Basics & Types of Indexing
- Basics & Types of IndexingPdf
- BackGround of IndexingDrm Video
- What is IndexingDrm Video
- Practice Question - Primary IndexingDrm Video
- Practice Question - Primary Indexing Cont...Drm Video
- Important Terminology of IndexingDrm Video
- Primary IndexingDrm Video
- Clustered IndexingDrm Video
- Practice Question - Clustered IndexingDrm Video
- Secondary IndexingDrm Video
- Practice question on secondary indexingDrm Video
- Multilevel Indexing notesPdf
- Multilevel indexingDrm Video
B-Trees & B+ Trees (Structure & Insertion)
Relational Algebra
Introduction to Query Languages
Unary Operators (Selection & Projection)
Set Operations & Cartesian Product
Join Operations (Inner & Outer)
Rename Operation
SQL
Introduction, Components & Structure
Select, Where, Distinct
Datatypes, Operators & Null
DDL, DML, DCL, TCL & Desc
Order By & Rename Operation (Alias)
Library Functions (Math, Aggregate, String, Date)
Set Operations & Cartesian Product
Join Operations (Inner & Outer)
Group By Clause
Nested & Correlated Subqueries
Views & PLSQL Basics
Relational Calculus
Tuple Relational Calculus (TRC)
Domain Relational Calculus (DRC)
Safety of Expressions & Power
Transaction Management
Introduction & ACID Properties
Transaction States
Concurrency Problems
Schedules & Conflict Serializability
View Serializability
Concurrency Control
Introduction to Concurrency Control
Timestamp Ordering Protocols
Lock-Based Protocols & Basic 2PL
Variations of 2PL (Strict, Rigorous, Conservative)
Database Recovery
Failure Types & Recovery Fundamentals
Log-Based Recovery Techniques
Advanced Recovery Algorithms
- Advanced Recovery AlgorithmsPdf
- Checkpoints & Shadow PagingDrm Video
- Deferred UpdateDrm Video
- Example (Deferred Approach)Drm Video
- Immediate UpdateDrm Video
- Example (Immediate Approach)Drm Video
- Example (Immediate DB Update)Drm Video
- ARIES Recovery Algorithm - Part 1Drm Video
- ARIES Recovery Algorithm - Part 2Drm Video
Module lessons
Explore the course
- About Course
- Paper 1 | Quantitative Aptitude
- Paper 1 | Logical Reasoning
- Paper 1 | English Language
- Paper 1 | Unit Tests
- Paper 1 | Full-Length Mock Tests
- Paper 2 | Engineering Mathematics
- Paper 2 | Digital Logic
- Paper 2 | Computer Architecture
- Paper 2 | Programming and Data Structures
- Paper 2 | Algorithms
- Paper 2 | Theory Of Computation/Automata Theory
- Paper 2 | Compiler Design
- Paper 2 | Operating System
- Paper 2 | Computer Networks
- Paper 2 | CS/IT Sectional Mock Tests
- Complete Paper Full Mock Test

