Answer and Explanation:
<u>Stored Procedure</u> : It is an object that is pre-compiled. It seems to be the initially compile as well as those files are saved. It executes that compilation file while this has been called.
<u>Functions </u>: Through, when the function is called it is compiled as well as executed.
<u>The differences between the both is that</u> -
- Stored Procedure return null, singular, or various values while Function only return one value at a time.
- Transactions cannot used in the function but it can be used in stored procedure.
- Functions may be named from such a stored procedure, but still not likewise.
- Stored procedures may have an input or output arguments, but the function still contain arguments for input.
- With the Academic Database situation, this is useful to use saved protocol anytime you choose to update / delete a participant, course, teachers, etc. Stored procedures are useful where the information or tables layout is to be altered.
Answer:
Liza is making a presentation on the sales revenue of her surfboard company’s most popular surfboard models. She wants to emphasize the model names as they appear one by one on the presentation slide. She also wants to depict the sales data for each model. "Goal seek" options can she use to achieve these goals.
Answer:
ELECTRIC GEYSER
1. Electric geyser works with the help of electricity
2. Electric geyser is widely used by all over the world
3. Electric geyser is expensive
4. Electric geyser is a consumes high watts
GAS GEYSER
1.Gas geyser works with the help of lpg (liquid petroleum gas)
2.Gas geyser is used less by the people all over the world
3. Gas is not expensive
4. Gas geyser consumes gas like liquid petroleum gas etc