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

Computer Science & Information Technology

You might also like to view...

List some attributes and operations that might be defined for a class called Course that represents a college course (not a particular offering of a course, just the course in general).

What will be an ideal response?

Computer Science & Information Technology

What is the content of the Xfile after the following command is executed? cat Afile Bfile > Xfile

a: Afile and Bfile b: only Afile c: only Bfile d: nothing e: an error message

Computer Science & Information Technology

A codec is a compression algorithm that reduces the size of a digital media file

Indicate whether the statement is true or false

Computer Science & Information Technology

Was there a viable algorithm? What analysis led you to this conclusion?

What will be an ideal response?

Computer Science & Information Technology