Question: solve just true false : Procedures can be invoked either from an SQL procedure or from embedded SQL by the Declarestatement stored -procedure is compiled
solve just true false :
- Procedures can be invoked either from an SQL procedure or from embedded SQL by the Declarestatement
- stored -procedure is compiled & executed whenever itiscalled.
- May contain multiple SQL statements between begin andend.
- the Function allows a single point of change in case the business rules change without changing other parts oftheapplication
- Assignments are performed using a set statement
- Functions can be used to implement certain integrity constraints that cannot be specified using the constraint mechanismofSQL.
- The drawback of the function is the code to implement the function may need to be loaded into the database system and executed in the database system'saddressspace
- Loading data from a backup copy is the type of unintended execution riskoftriggers.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
