[Solved] You want to sum all elements of an integer array nums using FOREACH. Which code correctly does this?DECLARE nums integer[] := ARRAY[5, 10, 15]; total integer := 0;... | PostgreSQL

PostgreSQL - PL/pgSQL Fundamentals

You want to sum all elements of an integer array nums using FOREACH. Which code correctly does this?

DECLARE
  nums integer[] := ARRAY[5, 10, 15];
  total integer := 0;
BEGIN
  FOREACH n IN ARRAY nums LOOP
    -- What goes here? --
  END LOOP;
  RAISE NOTICE '%', total;
END;

Atotal := n;

Btotal := total + n;

Ctotal := total * n;

Dtotal := total - n;

Step-by-Step Solution

Solution:

Step 1: Understand summing logic
To sum, add each element to total inside the loop.
Step 2: Choose correct operation
total := total + n; adds n to total, accumulating sum correctly.
Final Answer:
total := total + n; -> Option B
Quick Check:
Sum requires adding each element [OK]

Quick Trick: Add each element to total inside FOREACH [OK]

Common Mistakes:

Replacing total instead of adding
Multiplying instead of adding
Subtracting elements by mistake

Master "PL/pgSQL Fundamentals" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

You want to sum all elements of an integer array nums using FOREACH. Which code correctly does this?

Step 1: Understand summing logic

Step 2: Choose correct operation

Final Answer:

Quick Check:

Want More Practice?