DBT: ARIES Recovery
Exam-style ARIES practice focused on Analysis, Redo, and Undo with transaction table and dirty page table reasoning.
0/4 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~80 min
- Remaining
- 12 questions
← Back to classes
Course dossier
Database Technology
Learn each chapter, work through guided checkpoints, then test recall in the linked quiz.
Progress overview
- Lessons
- 25
- Questions
- 896
- Completed
- 0
- Active
- 0
Estimated quiz time: about 2637 minutes, plus guided reading. Progress remains local to this browser.
Chapter learning paths
DBT: 3 - Caching
Practice questions on caching architecture, buffer managers, replacement policies, CLOCK, and modern challenges.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~80 min
- Remaining
- 30 questions
DBT: 10 Concurrency Control
Practice questions on ACID properties, serializability, 2PL, deadlocks, isolation levels, OCC, and MVCC.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~95 min
- Remaining
- 30 questions
DBT: 2 - Data Layout
Practice questions on storage linearization, page/record layouts, NSM/DSM/PAX, and alignment calculations.
0/11 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~75 min
- Remaining
- 31 questions
DBT: Exam Day Ultimate Quiz
Comprehensive DBT exam drill across all lecture PDFs with non-trivial conceptual and numeric questions, each answer grounded in exact slide references.
0/25 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~180 min
- Remaining
- 73 questions
DBT: Execution, Optimization, Concurrency Control, Recovery, Distributed Databases
Question set on query execution, optimization, relational algebra laws, and processing models (part 1).
0/17 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~120 min
- Remaining
- 49 questions
DBT: 5 Indexing 2 (B-Trees)
Practice questions on B+ Trees, balancing, fan-out, splits/merges, bulk loading, and performance properties.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~95 min
- Remaining
- 30 questions
DBT: 6 Indexing 3 (Hash Tables)
Practice questions on hash indexes, collision handling, open addressing, and dynamic hashing (extensible and linear hashing).
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~95 min
- Remaining
- 30 questions
DBT: 4 Indexing Basics
Practice questions on search keys, dense/sparse indices, multilevel indexing, clustering, and index trade-offs.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~85 min
- Remaining
- 30 questions
DBT: INDEXING
Practice set based on indexing screenshots: bitmap index matching, sparse/dense index sizing, extensible hashing, B/B+ trees, and grid-file/hash-index reasoning.
0/7 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~50 min
- Remaining
- 19 questions
DBT: Mock Exam Prep II (Integrated)
Second integrated mock exam with fresh scenarios across storage/layouts/caching, indexing, optimization, concurrency/recovery, and distributed databases.
0/11 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~150 min
- Remaining
- 32 questions
DBT: Mock Exam Prep (Integrated)
Integrated exam-style preparation set inspired by Storage/Layouts/Caching, Indexing, and Execution/Optimization/CC/Recovery/Distributed topics.
0/12 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~150 min
- Remaining
- 36 questions
DBT: 7 Multidimensional Indexing
Practice questions on multidimensional indexing: Grid Files, kd-Trees, Quad-Trees, R-Trees, bitmap indices, and query types.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~95 min
- Remaining
- 30 questions
DBT: 12 Parallel Databases & Big Data
Self-assessment on recovery basics, WAL/ARIES, parallel databases, distributed databases, and scaling calculations.
0/11 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~100 min
- Remaining
- 32 questions
DBT: 13 Prallel DB and Big Data
Parallel Databases & Big Data Systems concept review with exam-style questions on scaling, architectures, parallelism, partitioning, distributed transactions, and distributed query processing.
0/11 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~120 min
- Remaining
- 31 questions
DBT: 8 Query Execution
Practice questions on relational algebra operators, iterator/materialization/vectorization models, pipelining, and compilation-based query execution.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~95 min
- Remaining
- 30 questions
DBT: 9 Query Optimization
Practice questions on parsing and preprocessing, logical and physical query optimization, cardinality estimation, statistics, and Selinger-style dynamic programming.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~95 min
- Remaining
- 30 questions
DBT: 11 Recovery
Self-assessment questions on database recovery: failure types, buffer policies, shadow paging, WAL, checkpointing, and ARIES.
0/11 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~95 min
- Remaining
- 31 questions
DBT: 100 Slide-Referenced Concept Questions
A standard-mode set of 100 lecture-referenced conceptual questions with exact PDF page citations.
0/34 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~220 min
- Remaining
- 100 questions
DBT: Slide-Referenced Concepts (Standard Mode)
A new standard-mode quiz with conceptual DBT questions grounded in lecture slides, each answer citing exact PDF pages.
0/14 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~85 min
- Remaining
- 41 questions
DBT: Slide-Referenced Concept Drill (50 Questions)
A 50-question conceptual quiz across all DBT lecture decks, with exact PDF page references in each answer explanation.
0/17 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~120 min
- Remaining
- 50 questions
DBT: Hard Mode Slide-Referenced Concepts (50x4 T/F)
Hard mode: for each of 50 prompts, evaluate four statements as True/False. Explanations cite exact PDF pages.
0/17 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~180 min
- Remaining
- 50 questions
DBT: Slide-Referenced Concept Check
Conceptual DBT questions with answer explanations that cite exact lecture PDF pages.
0/6 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~40 min
- Remaining
- 18 questions
DBT: Storage, Layouts, Caching
Memory hierarchy, storage layouts, caching concepts, and record/page-size calculations.
0/7 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~62 min
- Remaining
- 21 questions
DBT: 1 - Storage
Practice questions on memory hierarchy, disk mechanics, I/O cost model, failures, and RAID.
0/10 lesson sections0% learned
- Status
- Not started
- Quiz recall
- 0%
- Duration
- ~75 min
- Remaining
- 30 questions