[Solved] Consider this SQL procedure snippet:DECLARE v_age INT DEFAULT 20; IF v_age >= 18 THEN SET @result = 'Adult'; ELSE SET @result = 'Minor'; END IF;What will be the value of @result after execution? | SQL

SQL - Stored Procedures and Functions

Consider this SQL procedure snippet:

DECLARE v_age INT DEFAULT 20;
IF v_age >= 18 THEN
  SET @result = 'Adult';
ELSE
  SET @result = 'Minor';
END IF;

What will be the value of @result after execution?

A'Minor'

BNULL

C'Adult'

DError due to missing ELSE

Step-by-Step Solution

Solution:

Step 1: Check the condition value
v_age is 20, which is greater than or equal to 18.
Step 2: Determine which block runs
The IF block runs, setting @result to 'Adult'.
Final Answer:
'Adult' -> Option C
Quick Check:
Condition true sets 'Adult' = B [OK]

Quick Trick: Condition true runs IF block, else runs ELSE block [OK]

Common Mistakes:

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

More SQL Quizzes

Consider this SQL procedure snippet: