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...
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?
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
A codec is a compression algorithm that reduces the size of a digital media file
Indicate whether the statement is true or false
Was there a viable algorithm? What analysis led you to this conclusion?
What will be an ideal response?