Which of the following can a stored procedure use?1 pointA stored procedure cannot accept parameters.Input parametersInput and output parametersOutput parameters

Which of these is NOT required in your code?3 pointsAn inputA call to a procedureA 2 dimensional arrayA function with a parameterClear selection

What is the significance of the IN parameter in a stored procedure declaration?It indicates an input parameterIt indicates an output parameterIt indicates an input/output parameter

In the context of stored procedures, what distinguishes an IN parameter from an OUT parameter?Question 14Answera.IN parameters are used for retrieving values from the stored procedure after its execution, while OUT parameters are used for passing values into the stored procedure.b.IN parameters are mandatory for every stored procedure, while OUT parameters are optional.c.IN parameters are used for passing values into the stored procedure, while OUT parameters are used for retrieving values from the stored procedure before its execution.d.IN parameters are used for passing values into the stored procedure, while OUT parameters are used for retrieving values from the stored procedure after its execution.

A stored procedure can:1 pointBe written in different languagesAccept informationReturn resultsAll of the above

Q10.Which of the following statements about stored procedures are true?*2 pointsProviding a parameter list to CREATE PROCEDURE is optionalStored procedures are case-sensitiveStored procedures cannot be imported from one database system to anotherStored procedures are saved in the table mysql.proc