IST 272 Module 2
Card Set Information
IST 272 Module 2
database sql server
IST 272 Module 2 Flashcards. Stored Procedures, Triggers, and Functions
What is a view?
A "virtual table" or a stored SELECT query
What is a view used for?
To retrieve and modify data
Name three modifications you can make while using a view?
Insert, update, and delete records
A view that uses these functions will nullify the ability to modify the data contained within
What is an indexed view
This type of view will help you speed up complex queries such as calculations and data manipulation queries
What is the query optimizer?
The component in SQL Server that analyzes your query, compares them with available indexes, and decides which index returns a result set the fastest.
What is a stored procedure?
Predefined batch of code stored as an object in the database to do work.
What is T-SQL and CLR?
Two types of code used for User Stored Procedures
What is the keyword OUTPUT?
If you omit this keyword when you execute the stored procedure, the stored procedure still completes but does not return the modified value.
When SQL Server process a stored procedure, the Query Optimizer first checks the procedure cache for this.
an already in memory execution plan
A trigger has the same functionality as this
Fires automatically when the event where it is defined occurs- it can never be called directly
Two types of triggers found in SQL Server
DDL and DML
These triggers execute automatically when an action such as insert, delete, and/or update executes against a table or view
Names for tables created by a trigger
inserted and deleted
The default behavior of a trigger takes place as this action
These triggers fire on CREATE, ALTER, and DROP statements
Name the two parts of CTEs
WITH clause containing SELECT statement
and outer SELECT statement
Two types of subqueries
correlated and non-correlated
This type of subquery depends and references columns from the outer query