Correct Answer : FORWARD_ONLY STATIC
Explanation : A FORWARD_ONLY STATIC Cursor is populated at the time of creation and cached the data to the cursor lifetime. It is not sensitive to any changes to the data source.
Correct Answer : Master
Explanation : The master database records all of the system level information for a SQL Server system.
Correct Answer : Model
Explanation : When a CREATE DATABASE statement is issued, the first part of the database is created by copying in the contents of the model database.
Correct Answer : Msdb
Explanation : The msdb database is used by SQL Server Agent for scheduling alerts and jobs, and recording operators.
