1.
What are INSTEAD OF triggers used for?
2.
What mechanism is typically used to automatically update other tables, generate or transform values for inserted or updated rows, and perform tasks such as issuing alerts?
3.
Which data type should be used to store data in a column that represents money and accurately returns a two position scale?
4.
Which statement about a deadlock is true?
5.
What takes place when a process accesses a data object on which it already holds a lock, and the access mode requires a more restrictive lock than the one currently held?
6.
What is the act of releasing a large number of row-level locks that an application holds on a single table to acquire a table-level lock known as?
7.
The EXCLUSIVE MODE option of the LOCK TABLE statement is used to prevent which of the following?
8.
What factor influences lock conversion/promotion?
9.
If no isolation level is specified, what is the default isolation level used?
10.
What isolation level prevents dirty reads, nonrepeatable reads, and phantoms?