List and describe three of the five system databases found in an SQL Server 2012 system.
What will be an ideal response?
master - Stores information on the structure of other databases and their components; maintains configuration settings, including security
tempdb - Stores temporary data that is generated when the database engine executes processes
model - Stores a database template that is used as a blueprint when creating a new user database
resource - Stores the system objects in a read-only database; these logically appear in each database in the sys schema
msdb - Stores information related to jobs, schedules, and database backups
You might also like to view...
To open an existing outline file created in a program other than PowerPoint 2013, click the ________ tab
Fill in the blank(s) with correct word
In ____ execution, one group of statements are performed to the exclusion of another group.
A. selective B. repetitive C. parallel D. sequential