Consider the following query:
SELECT Name FROM Country WHERE Code = ‘MEX’
What would be the consequence of this query if executed in a stored procedure?
A.
The value would not be available unless stored in a variable.
B.
An error would be issued.
C.
The results would be sent directly to the client
D.
A warning would be issued.
Explanation:
CREATE PROCEDURE q55() SELECT Name FROM Country WHERE Code = ‘MEX’; CALL q55; — executes select and returns result to client.