ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 53 discussion

Actual exam question from Microsoft's 98-364
Question #: 53
Topic #: 1
[All 98-364 Questions]

A named group of SQL statements that can be executed in a database is called a:

  • A. Subroutine
  • B. Formula
  • C. Stored procedure
  • D. Method
Show Suggested Answer Hide Answer
Suggested Answer: C 🗳️
by syed5 at July 9, 2020, 2:22 p.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
syed5
Highly Voted 4 years, 11 months ago
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again. So if you have an SQL query that you write over and over again, save it as a stored procedure, and then just call it to execute it. You can also pass parameters to a stored procedure, so that the stored procedure can act based on the parameter value(s) that is passed. Stored Procedure Syntax CREATE PROCEDURE procedure_name AS sql_statement GO;
upvoted 8 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel