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