Bird
0
0

Identify the error in this SQL procedure snippet:

medium📝 Debug Q14 of 15
SQL - Stored Procedures and Functions
Identify the error in this SQL procedure snippet:
IF score > 50
  SELECT 'Pass';
ELSE
  SELECT 'Fail';
END IF;
AMissing semicolon after ELSE
BMissing BEGIN keyword
CIncorrect END IF syntax
DMissing THEN after IF condition
Step-by-Step Solution
Solution:

  1. Step 1: Check IF statement syntax

    In SQL procedures, IF must be followed by THEN after the condition.

  2. Step 2: Verify given code

    The code has IF score > 50 but no THEN keyword.

  3. Final Answer:

    Missing THEN after IF condition -> Option D

  4. Quick Check:

    IF condition THEN is required [OK]
Quick Trick: Always put THEN after IF condition [OK]
Common Mistakes:
  • Omitting THEN after IF
  • Adding semicolon after ELSE incorrectly
  • Misusing END IF syntax

Want More Practice?

15+ quiz questions · All difficulty levels · Free

Free Signup - Practice All Questions
More SQL Quizzes
Advanced Query Patterns - Pivot and unpivot concepts - Quiz 5medium Advanced Query Patterns - Finding duplicates efficiently - Quiz 1easy Common Table Expressions (CTEs) - Recursive CTE concept - Quiz 6medium Database Design and Normalization - Denormalization and when to use it - Quiz 6medium Indexes and Query Performance - Index impact on INSERT and UPDATE - Quiz 15hard Indexes and Query Performance - Unique index behavior - Quiz 9hard SQL Security Basics - Why prepared statements exist - Quiz 4medium SQL Security Basics - How SQL injection exploits queries - Quiz 10hard Stored Procedures and Functions - User-defined functions - Quiz 1easy Stored Procedures and Functions - WHILE loops in procedures - Quiz 10hard