Question:We are creating Stored Procedure in Database and using "sp_" prefix in its name. Which of the following statements is correct in accordance with the performance of the Stored Procedure execution? 

A The prefix will speed up the execution as it is in cache and will always get executed with high priority 
B The prefix will slow down the execution as the prefix is reserved for system stored procedures 
C The performance will not be affected as "sp_" is just a prefix for a stored procedure 
D The prefix will speed up the execution as prefix "sp_" is used for stored procedures by default 

+ Answer
B 

+ Report

Md. Habib Ullah

Editor, VCampus

Your Name

Your Email

Type of Report
Spelling MistakeIncorrect AnswerGrammar MistakeContent MissingImproper Text FormatInsufficient AnswerDuplicate QuestionImproper Sentence StructureImproper Equation/FormulaOther

Description