Quiz - C# Mastery Hub

Precompiled T-SQL saved in the database

A function that returns a value

A view that shows data

A type of table

They prevent SQL injection and improve performance

They are slower than inline SQL

They can't be reused

They are less secure

EXEC ProcedureName

SELECT ProcedureName

CALL ProcedureName

RUN ProcedureName

CREATE PROCEDURE

CREATE FUNCTION

CREATE VIEW

CREATE TABLE

Parameters are never concatenated into the query text

They are not executed

They delete all user input

They only allow SELECT statements

SQL Server - Lesson 7: Stored Procedures Quiz