1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
juin [17]
4 years ago
7

What is the difference between a stored procedure and a user-defined function? Based on the Academic Database, identify and desc

ribe a scenario where it would be necessary to use a stored procedure or a user-defined function. Your answer should be addressed in 100 to 150 words.
Computers and Technology
1 answer:
bulgar [2K]4 years ago
6 0

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.
You might be interested in
Maya is preparing a presentation for her science class on how solar panels produce energy. Why would a
astra-53 [7]
A.) it the best way to show how something functions
5 0
3 years ago
Read 2 more answers
What is a WYSIWIG program
jeyben [28]

Answer:

WYSIWYG means "what you see is what you get ".

Explanation:

It is type of editor or program that helps while creating a document. This program allows us to see the end result while creating a document i terms of who document will look like after completion.

4 0
3 years ago
Which item is used in Excel to identify the row of a particular cell? letter number type sheet
Alik [6]

It can be any letter or number as long as its validated.

7 0
4 years ago
Read 2 more answers
Match the function to its purpose.
schepotkina [342]

Answer:

  • Median :Calculates the average of the two  numbers in the middle of a set of even count of numbers.
  • Mode : This function shows the most frequently  occurring number in a set of numbers
  • Standard deviation : You can see how far each number  varies, on average, from the average  value of the list
  • Rank : With this function, you can determine  the position of a number in an  unarranged array or set.

Explanation:

8 0
4 years ago
Charlotte is using her teaching skills to train new employees on how to use software. The software is typically used in the Engi
kondaur [170]
The fact that Charlotte is <span>using her teaching skills to train new employees on how to use software and the software is typically used in the Engineering and Technology pathway means that </span>Charlotte is most likely using computer-aided design skills, or referred to as CAD (computer-aided design) skills.
<span>The term denotes use of computer systems (or workstations) (in this scenario a specific software) to aid in the creation, modification, analysis, or optimization of a </span>design.
7 0
3 years ago
Read 2 more answers
Other questions:
  • Sometimes your Internet is slow and sluggish, what are some common problems that affect network functionality. Check all that ap
    14·1 answer
  • bro this scared me, i thought i just got hacked, could someone explain why when i went to ask a question, it kicked me out my ac
    9·2 answers
  • Write a Java program that reads two numbers from the console. Based on the example in the textbook, write five methods (min, max
    14·2 answers
  • List three social implications of the wider range of piracy​
    15·1 answer
  • ______allow you to select elements that are in a certain state, such as when the mouse if hovering over an element
    14·1 answer
  • This is the number of items arranged in an order.
    7·2 answers
  • What is an algorithm?
    11·1 answer
  • Which is the fastest memory in computer​
    9·2 answers
  • A trial-and-error method of problem solving used when an algorithmic or mathematical approach is called
    7·1 answer
  • Sftp uses which mechanism to provide security for authentication and data transfer?
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!