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 :

  1. Procedures can be invoked either from an SQL procedure or from embedded SQL by the Declarestatement
  2. stored -procedure is compiled & executed whenever itiscalled.
  3. May contain multiple SQL statements between begin andend.
  4. the Function allows a single point of change in case the business rules change without changing other parts oftheapplication
  5. Assignments are performed using a set statement
  6. Functions can be used to implement certain integrity constraints that cannot be specified using the constraint mechanismofSQL.
  7. 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
  8. 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 blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Mathematics Questions!