DWQA QuestionsCategory: SQL________ is a program that performs some common action on database data and also stored in the database.
Editor Staff asked 9 months ago

________ is a program that performs some common action on database data and also stored in the database.

  1. Stored Procedure
  2. Trigger
  3. Stored Function
  4. None of the above
1 Answers
Editor Staff answered 9 months ago

Answer: 

  1. Stored Procedure

Explanation: A stored procedure is a precompiled set of SQL commands that we can save in our database. It can be reused over and over again whenever we need to perform some common tasks.
A trigger is also the set of SQL commands that reside in a system catalog, but it will be invoked automatically in response to an event. It is a special kind of stored procedure.
A stored function is one of the types of stored programs used to encapsulate the common business rules or formulas reusable in stored programs. It returns a single value or sometimes does not produce any result.
Hence the option A is the correct choice.