Course module
DBMS (MCQs + Interview) — HEXAWARE Superset
- Lessons
- 184
- Duration
- 14 hr 15 min
- PYQs
- 2
- Practice
- 1203
0% of this course's PYQ weight is covered in this module.
Syllabus index
Lessons in this module
Basics of DBMS
DBMS Fundamentals
Types & DBA Functions
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
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
Keys & Integrity Constraints
Super Key, Candidate Key & Primary Key
Foreign Key & Referential Integrity
Composite & Alternate Keys
Normalization (1NF - BCNF)
Introduction to Normalization & 1NF
Second Normal Form (2NF)
Third Normal Form (3NF)
Transaction Management
Introduction & ACID Properties
Transaction States
Concurrency Problems
Schedules & Conflict Serializability
Recoverability, Cascadeless & Strict Schedules
Decomposition Properties & 4NF
Lossless Join Decomposition
Dependency Preserving Decomposition
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
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
Database Security & Authorization
Introduction to Database Security
Mandatory Access Control (MAC)
Role-Based Access Control (RBAC)
Previous-year questions
Explore the course
- Quantitative Ability
- Reasoning Ability
- Verbal Ability
- Programming Basics (MCQs + Interview)
- OOPs (MCQs + Interview)
- SQL (MCQs + Interview)
- Operating Systems (MCQs + Interview)
- Computer Networks (MCQs + Interview)
- Coding
- HR Interview
Loading lesson…