Key Terms

Question 1

View

Answer 1

reusable named query or table expression whose definition is stored as an object in the database

Question 2

Schemabinding

Answer 2

prevents structural changes to dependent tables and columns while the view exists

Question 3

user-defined function

Answer 3

a routine that accepts parameters, applies calculations and returns either a scalar-valued or table-values result

Question 4

savepoint

Answer 4

a marker within an open transaction that you can later roll back to, undoing only the changes that took place since the savepoint and not the rest of the changes that took place in the transaction

Question 5

Mark

Answer 5

Defines a marker name in the transaction log

Question 6

lag function

Answer 6

returns an element from the row in the current partition that is requested number of rows before the current row. With 1 assumed as the default offset

Question 7

tablock

Answer 7

specifies that the acquired lock is applied at table level

Question 8

updlock

Answer 8

specifies that update locks are to be taken and help until the transaction completes