[Solved] Given this procedure:CREATE PROCEDURE updateStock(productId INT, qty INT) AS $ BEGIN UPDATE products SET stock = stock +... $ LANGUAGE plpgsql;What happens when you run CALL updateStock(5, 10);? | SQL

SQL - Stored Procedures and Functions

Given this procedure:

CREATE PROCEDURE updateStock(productId INT, qty INT) AS $$ BEGIN UPDATE products SET stock = stock + qty WHERE id = productId; END; $$ LANGUAGE plpgsql;

What happens when you run CALL updateStock(5, 10);?

AThe procedure returns the new stock value

BAn error occurs because procedures cannot update tables

CThe stock of product with id 5 increases by 10

DNothing happens because procedures cannot be called

Step-by-Step Solution

Solution:

Step 1: Understand procedure purpose
The procedure updates the stock column by adding qty for the given productId.
Step 2: Analyze the CALL statement
CALL executes the procedure, increasing stock of product 5 by 10.
Final Answer:
The stock of product with id 5 increases by 10 -> Option C
Quick Check:
Procedure updates data, no return value [OK]

Quick Trick: Procedures perform actions, no direct return value [OK]

Common Mistakes:

Expecting procedure to return a value
Thinking procedures cannot update tables
Confusing CALL with SELECT

Master "Stored Procedures and Functions" in SQL

9 interactive learning modes - each teaches the same concept differently

Learn Why Deep Visual Try Challenge Project Recall Time

More SQL Quizzes

Given this procedure:

Step 1: Understand procedure purpose

Step 2: Analyze the CALL statement

Final Answer:

Quick Check:

Want More Practice?