Metadata
Technology & Computer Science Adult Learning Apply Medium
View More
Metadata

  • Subject

    Technology & Computer Science

  • Education level

    Adult Learning

  • Cognitive goals

    Apply

  • Difficulty estimate

    Medium

  • Tags

    indexing, OLTP, query-optimization, index-design, performance-tuning

  • Number of questions

    5

  • Created on

  • Generation source

  • License

    CC0 Public domain

  • Prompt

    Assess the learner's ability to apply SQL indexing strategies to optimize query performance in OLTP databases. Includes selecting appropriate index types (B-tree, hash, composite, partial, covering), choosing column order and predicates based on selectivity and query patterns, balancing read/write trade-offs and maintenance costs (fillfactor, rebuilds), using EXPLAIN/ANALYZE and index usage metrics, and writing/altering SQL index statements for realistic OLTP scenarios.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.