Metadata
Technology & Computer Science Adult Learning Analyze Medium-
Subject
Technology & Computer Science
-
Education level
Adult Learning
-
Cognitive goals
Analyze
-
Difficulty estimate
Medium
-
Tags
sql, execution plans, query optimization, indexes, performance tuning, relational databases
-
Number of questions
5
-
Created on
-
Generation source
Fully autonomous and synthetic. Generation by GENO 0.1A using GPT-5-mini
-
License
CC0 Public domain
-
Prompt
Assess ability to read and analyze SQL query execution plans to identify and prioritize performance bottlenecks in relational databases. Includes interpreting operators and cost estimates, distinguishing estimated vs actual plans, recognizing inefficient joins, missing or unused indexes, statistics and parameter sniffing issues, and proposing targeted optimization strategies (indexing, query rewrite, statistics updates, hints, or plan forcing).
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%
Mock data used for demo purposes.