Course module
DBMS (Technical MCQs + Interview) — LTI MINDTREE Superset Course
- Lessons
- 112
- Duration
- 8 hr 31 min
- PYQs
- 2
- Practice
- 752
2% 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 Control
Introduction to Concurrency Control
Timestamp Ordering Protocols
Lock-Based Protocols & Basic 2PL
Database Security & Authorization
Introduction to Database Security
Mandatory Access Control (MAC)
Role-Based Access Control (RBAC)
Previous-year questions
Explore the course
- Quantitative Ability
- Logical Ability
- Verbal Ability
- Basic Analytical Ability
- Coding (Technical Assessment)
- Pseudocode & Debugging (Technical Assessment)
- OOPs (Technical MCQs + Interview)
- SQL (Technical MCQs + Interview)
- OS (Technical MCQs + Interview)
- Computer Networks (Technical MCQs)
- Data Structures (Technical MCQs + Interview)
- Software Engineering (Technical MCQs + Interview)
- Communication Assessment
- HR Interview
Loading lesson…