Database Technology
DBT: 1 - Storage
Practice questions on memory hierarchy, disk mechanics, I/O cost model, failures, and RAID.
Estimated time: 75 min
0/30 answered0%
Not started
Quizmaster
Database Technology
Choose a quiz from this class.
Database Technology
DBT: 2 - Data Layout
Practice questions on storage linearization, page/record layouts, NSM/DSM/PAX, and alignment calculations.
Estimated time: 75 min
0/31 answered0%
Not started
Database Technology
DBT: 3 - Caching
Practice questions on caching architecture, buffer managers, replacement policies, CLOCK, and modern challenges.
Estimated time: 80 min
0/30 answered0%
Not started
Database Technology
DBT: 4 Indexing Basics
Practice questions on search keys, dense/sparse indices, multilevel indexing, clustering, and index trade-offs.
Estimated time: 85 min
0/30 answered0%
Not started
Database Technology
DBT: 5 Indexing 2 (B-Trees)
Practice questions on B+ Trees, balancing, fan-out, splits/merges, bulk loading, and performance properties.
Estimated time: 95 min
0/30 answered0%
Not started
Database Technology
DBT: 6 Indexing 3 (Hash Tables)
Practice questions on hash indexes, collision handling, open addressing, and dynamic hashing (extensible and linear hashing).
Estimated time: 95 min
0/30 answered0%
Not started
Database Technology
DBT: 7 Multidimensional Indexing
Practice questions on multidimensional indexing: Grid Files, kd-Trees, Quad-Trees, R-Trees, bitmap indices, and query types.
Estimated time: 95 min
0/30 answered0%
Not started
Database Technology
DBT: 8 Query Execution
Practice questions on relational algebra operators, iterator/materialization/vectorization models, pipelining, and compilation-based query execution.
Estimated time: 95 min
0/30 answered0%
Not started
Database Technology
DBT: 9 Query Optimization
Practice questions on parsing and preprocessing, logical and physical query optimization, cardinality estimation, statistics, and Selinger-style dynamic programming.
Estimated time: 95 min
0/30 answered0%
Not started
Database Technology
DBT: 10 Concurrency Control
Practice questions on ACID properties, serializability, 2PL, deadlocks, isolation levels, OCC, and MVCC.
Estimated time: 95 min
0/30 answered0%
Not started
Database Technology
DBT: 11 Recovery
Self-assessment questions on database recovery: failure types, buffer policies, shadow paging, WAL, checkpointing, and ARIES.
Estimated time: 95 min
0/31 answered0%
Not started
Database Technology
DBT: 12 Parallel Databases & Big Data
Self-assessment on recovery basics, WAL/ARIES, parallel databases, distributed databases, and scaling calculations.
Estimated time: 100 min
0/32 answered0%
Not started
Database Technology
DBT: Execution, Optimization, Concurrency Control, Recovery, Distributed Databases
Question set on query execution, optimization, relational algebra laws, and processing models (part 1).
Estimated time: 120 min
0/49 answered0%
Not started
Database Technology
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.
Estimated time: 50 min
0/19 answered0%
Not started
Database Technology
DBT: Storage, Layouts, Caching
Memory hierarchy, storage layouts, caching concepts, and record/page-size calculations.
Estimated time: 62 min
0/21 answered0%
Not started