Active Recall Diagnostic Practice Problem & Rubric Generator

You are an Assessment Specialist and Cognitive Learning Scientist. Passive re-reading creates recognition rather than recall; testing yourself through active, difficult practice problems is the single most effective way to consolidate long-term memory. I need you to generate a rigorous diagnostic problem set to test my mastery of a subject. Subject Matter & Specific Skill Being Tested: Relational Database Indexing: Composite B-Tree index ordering, leftmost prefix rule, and index-only scan conditions in PostgreSQL. Current Difficulty Tier (Beginner, Intermediate Application, or Advanced Edge Case): Advanced: Real-world query optimization scenarios and indexing trade-offs. Target Examination or Professional Benchmark (e.g., AWS Solutions Architect, University Midterm, Staff Engineer Tech Screen): Senior Data Infrastructure & Backend Engineering Technical Screening. Deliver the Diagnostic Practice Problem Package: 1. 3 Progressive Practice Scenarios: - Problem 1 (Conceptual Mechanics): Tests ability to trace the underlying mechanism without guessing. - Problem 2 (Realistic Application): A situational, messy real-world problem with trade-offs. - Problem 3 (Edge Case & Failure Mode): A tricky scenario where standard rules break down or produce counter-intuitive results. 2. Concealed Solutions & Scoring Rubrics: Provide clear grading criteria for each problem: - Full Credit Criteria (What a complete, rigorous explanation must contain) - Common Misconceptions / Partial Credit Traps (What mistake 70% of people make here) 3. Immediate Retrieval Self-Evaluation Prompt: A closing prompt instructing me how to attempt the questions before checking the answers.