DBMS Quizzes (MCQs)Phase 1 Foundations & Design Architecture & ModelingDBMS Architecture 3-Tier, Data Independence, DBA vs. User01_ARCH Models & Keys Relational, Primary, Foreign, Composite Keys02_KEYS ER Modeling Entities, Cardinality, Weak Entities, Mapping03_ER Normalization Functional Dependencies, 1NF, 2NF, 3NF, BCNF04_NORM Phase 2 Querying & Logic SQL & Relational AlgebraRelational Algebra Selection, Projection, Joins, Set Ops05_ALG SQL Basics DDL (Create/Drop) & DML (Insert/Select)06_SQL Advanced SQL Joins, Subqueries, Group By, Aggregates07_SQL+ Procedural SQL Stored Procs, Triggers, Cursors, Views08_PLSQL Phase 3 Internals Performance & ReliabilityTransactions ACID Properties, States, Serializability09_ACID Concurrency Control Locks, 2-Phase Locking (2PL), Deadlocks10_LOCKS Indexing & Hashing B-Trees, B+ Trees, Clustered Indexes11_INDEX DB Recovery Log-based Recovery, Checkpoints, Shadow Paging12_RECOV Phase 4 Modern Trends Big Data & DistributionNoSQL Systems CAP Theorem, BASE, MongoDB vs Redis13_NOSQL Distributed DBs Columnar Stores, Replication, Sharding14_DIST