[Solved] Consider this SQL code:CREATE FUNCTION addTax(amount DECIMAL) RETURNS DECIMAL AS $ BEGIN RETURN amount * 1.... $ LANGUAGE plpgsql;SELECT addTax(100);What will be the output of the SELECT statement? | SQL

SQL - Stored Procedures and Functions

Consider this SQL code:

CREATE FUNCTION addTax(amount DECIMAL) RETURNS DECIMAL AS $$ BEGIN RETURN amount * 1.1; END; $$ LANGUAGE plpgsql;
SELECT addTax(100);

What will be the output of the SELECT statement?

A110.0

B100

C1.1

DError: function not found

Step-by-Step Solution

Solution:

Step 1: Understand the function logic
The function multiplies the input amount by 1.1 to add 10% tax.
Step 2: Calculate the output for input 100
100 * 1.1 = 110.0, so the function returns 110.0.
Final Answer:
The output will be 110.0 -> Option A
Quick Check:
Function output = 110.0 [OK]

Quick Trick: Function returns calculated value directly [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 code: