-
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
Aggregate functions
-
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
stored procedure
-
Fires automatically when the event where it is defined occurs- it can never be called directly
trigger
-
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
DML triggers
-
Names for tables created by a trigger
inserted and deleted
-
The default behavior of a trigger takes place as this action
AFTER action
-
These triggers fire on CREATE, ALTER, and DROP statements
DDL triggers
-
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
correlated
|
|