.
SQL profiler
SQL replication
SQL agent
Update statistics
Transaction
Transformation
Snapshot
Merge
Merge
Transformation
Transaction
Snapshot
By using the SQL agent
By using the SQL scheduler
By using checkpoints
By calling update statistics
A nested query not linked with an outer query
An outer query linked with a nested query
A nested sub query linked with an outer query
An outer query not linked to a nested query
4
5
2
7
Single
Multiple rows
Multiple columns
Double rows
UNION ALL
FLOOR
IDENTITY
UNION
Error
Insert
Delete
Update
To change a table
To specify order in a table
To collect data from a table
To create rows in a table