[Solved] Identify the error in this block:DO $ BEGIN RAISE EXCEPTION 'Error!'; EXCEPTION WHEN division_by_zero THEN RAISE NOTICE 'Handled division by zero'; END $; | PostgreSQL

PostgreSQL - Advanced PL/pgSQL

Identify the error in this block:

DO $$
BEGIN
  RAISE EXCEPTION 'Error!';
EXCEPTION
  WHEN division_by_zero THEN
    RAISE NOTICE 'Handled division by zero';
END $$;

ARAISE EXCEPTION syntax is incorrect

BMissing END statement

CException type does not match raised error

DEXCEPTION block must be empty

Step-by-Step Solution

Solution:

Step 1: Check raised exception type
The block raises a generic exception with message 'Error!'.
Step 2: Check exception handler
The handler only catches division_by_zero, which does not match the raised exception.
Final Answer:
Exception type does not match raised error -> Option C
Quick Check:
Exception mismatch error = C [OK]

Quick Trick: Exception handler must match raised error type [OK]

Common Mistakes:

Master "Advanced PL/pgSQL" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Identify the error in this block: