MCQs – Stored Procedure and SQL function

(Last Updated On: March 13, 2019)

MCQ – Multiple choice questions on stored procedure sql and function with answers and explanation. Objective questions are asked in Software jobs written interviews.


Q) A stored procedure in SQL is a___________
  1. Block of functions
  2. Group of SQL statements.
  3. None
View Answer
Answer: B

Q) Advantage of SQL stored procedure
  1. Maintainability
  2. Re-use of code
  3. Security
  4. All
View Answer
Answer: D

Q) Syntax to create stored procedure is/are
  1. B & C
  2. B only
View Answer
Answer: D

Q) Which statement(S) is/are incorrect
  1. Stored procedure may return a value and function must return a value.
  2. Function has only IN parameter.
  3. Try and Catch can be used with both stored procedure and function.
  4. Stored procedure has IN and OUT parameter.
View Answer
Answer: C