Multiple choice technology databases

What is a child stored procedure?

  1. A procedure that is very small

  2. A procedure being invoked by another procedure

  3. A procedure that is not used by application

  4. System stored procedures

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

A child stored procedure is a procedure that is called (invoked) by another stored procedure. This is a common design pattern for modularizing complex database logic into reusable components.