When creating a stored procedure to retrieve a single row with embedded SQL, you must place the procedural code _____.
A) inside a SELECT or WHERE clause
B) within the DELIMITER clause
C) between the BEGIN and END commands
D) after the DECLARE statement

Question

Quizplus · Accepted Answer

Stored procedures in SQL use the BEGIN and END commands to encapsulate the procedural code, including any embedded SQL operations such as retrieving a single row.

When Creating a Stored Procedure to Retrieve a Single Row