Which of the following is known to be true if the command EXEC abcCust @Cost = 5 is used to invoke a stored procedure in the Microsoft SQL Server Management Studio?
A)Cost = 5 is a CHECK constraint.
B)The name of the stored procedure is abcCust.
C)The name of the stored procedure is abc.
D)Cust is given the value 5.
E)abcCust is the name of a table or view in the database.

Question

Quizplus · Accepted Answer

The command EXEC abcCust @Cost = 5 is used to invoke a stored procedure named abcCust with a parameter @Cost that is set to 5. Thus, option B is the correct choice. Option A is incorrect because it refers to a CHECK constraint, which is unrelated to the stored procedure being invoked. Option C is incorrect because it suggests that the name of the stored procedure is only abc, which is not the case. Option D is incorrect because it suggests that Cust is a parameter, which is not the case. Option E is incorrect because it refers to a table or view, which is unrelated to the stored procedure being invoked.

Which of the Following Is Known to Be True If