Which Command is used to call a Stored P..;@SP

Q2. Where are Stored Procedures Stored?

 Database Memory Execution Log tempdb SQL Profiler

Q3. Does a Stored Procedure have to have Input Parameters

 YES NO

Q4. What is the purpose of SET NO COUNT. ON?

 Shows Stored Procedure Executed Successfully Shows total rows affected Don't show total rows affected. Displays Error Doesn't Display Errors

Q5. Which statement about OUTPUT Parameters is true?

 Output is needed to return data from a Stored Procedure. Output Parameters can return multiple Scalar Values Output Parameters must be returned 1st Allows users to capture the results in a variable. SET NOCOUNT ON Allows you to stop data from returning in the OUTPUT parameter

Q6. True of False: Output parameters should always be declare at the beginning of the Stored Procedure.

 TRUE FALSE

Q7. Can an Input Parameter also be used as an Output Parameter?

 YES NO