Stored Procedures

Question 1

Which SQL keyword is used to create a stored procedure in a database?

A.

A) CREATE FUNCTION

B.

B) CREATE PROCEDURE

Explanation: **CREATE PROCEDURE** is the correct keyword for defining a stored procedure. CREATE FUNCTION creates functions, CREATE TRIGGER creates triggers, and CREATE TABLE creates tables.

C.

C) CREATE TRIGGER

D.

D) CREATE TABLE

Question 2

Why is **DELIMITER //** necessary when creating a stored procedure?

A.

A) To mark the end of the database connection

B.

B) To separate multiple procedures in one script

C.

C) To prevent internal semicolons from terminating the procedure definition prematurely

Explanation: Semicolons (;) normally mark the end of SQL statements. Inside a stored procedure, multiple SQL statements may contain semicolons. **DELIMITER //** temporarily changes the statement terminator to //, allowing the entire procedure definition to be treated as one statement.

D.

D) To optimize the procedure's execution speed

Question 3

In the context of stored procedures, what is the primary purpose of the **BEGIN...END** block?

A.

A) To group multiple SQL statements into a single logical unit

Explanation: The **BEGIN...END** block encapsulates all SQL statements and logic within a stored procedure, treating them as a single executable unit. This allows multiple statements to be grouped together logically.

B.

B) To declare variables only

C.

C) To define the procedure name

D.

D) To establish the database connection

Question 4

In the syntax for creating a stored procedure with parameters, what precedes the parameter name and data type?

A.

A) OUT

B.

B) IN, OUT, or INOUT

Explanation: Parameters are prefixed by **IN**, **OUT**, or **INOUT** followed by the name and data type, such as `IN custID INT`.

C.

C) @

D.

D) DELIMITER

Question 5

What keyword is used to execute a stored procedure with arguments?

A.

A. EXECUTE

B.

B. RUN

C.

C. CALL

Explanation: The CALL statement, followed by the procedure name and arguments in parentheses, executes the procedure.

D.

D. INVOKE

Question 6

Which keyword is used to declare a variable inside a stored procedure in MySQL?

A.

A) DEFINE

B.

B) DECLARE

Explanation: The **DECLARE** keyword is used to create variables within the **BEGIN...END** block of a stored procedure. It specifies the variable name and its data type.

C.

C) SET

D.

D) INITIALIZE

Question 7

What happens if the condition in an **IF** statement is false?

A.

A. The statements in the IF block execute.

B.

B. The procedure terminates immediately.

C.

C. No statements execute.

D.

D. The statements in the ELSE block execute.

Explanation: The **IF-ELSE** structure executes the ELSE block when the condition evaluates to false.

📝 Stored Procedures

Quiz Complete!