Parameters (IN, OUT, INOUT) in SQL - Cheat Sheet & Quick Revision

Recall & Review

beginner

What does an IN parameter do in a SQL stored procedure?

An IN parameter allows you to pass a value into the stored procedure. It is used to provide input data that the procedure can use but cannot change.

beginner

What is the purpose of an OUT parameter in SQL procedures?

An OUT parameter is used to return a value from the stored procedure back to the caller. It allows the procedure to send data out after processing.

intermediate

Explain an INOUT parameter in SQL stored procedures.

An INOUT parameter acts as both input and output. It passes a value into the procedure and can also return a modified value back to the caller.

beginner

Can an IN parameter be modified inside the stored procedure?

No, an IN parameter cannot be changed inside the procedure. It is read-only and only used to provide input values.

intermediate

How do OUT and INOUT parameters differ in their usage?

OUT parameters only return values from the procedure and do not accept input. INOUT parameters accept input and can also return modified values.

Which parameter type is used only to send data into a SQL stored procedure?

A OUT

B INOUT

C IN

D RETURN

IN parameters are used to pass input values into the procedure.

What type of parameter allows a stored procedure to return a value back to the caller?

A OUT

B DECLARE

C INOUT

D IN

OUT parameters are designed to send values back from the procedure.

Which parameter type can both accept input and return output?

A VAR

B OUT

C IN

D INOUT

INOUT parameters work as input and output parameters.

Can an IN parameter be changed inside the procedure?

A Yes, always

B No, it is read-only

C Only if declared as INOUT

D Only in some SQL dialects

IN parameters are read-only inside the procedure.

If you want to modify a value inside a procedure and send it back, which parameter type should you use?

A INOUT

B OUT

C IN

D CONST

INOUT parameters allow modification and returning of values.

Describe the differences between IN, OUT, and INOUT parameters in SQL stored procedures.

Think about how data flows in and out of the procedure.

Explain why you might choose an INOUT parameter instead of separate IN and OUT parameters.

Consider when input needs to be changed and sent back.