MSSQL%20Interview%20Questions%20and%20Answers
Question: What are system databases in MS SQL Server?Answer: System databases are created by the SQL Server itself during the installation process. System databases are used by the SQL server to help manage other user databases and client execution sessions. SQL Server 2005 Express Edition uses 4 system databases:* master - The brain of a SQL server - Stores server configuration, runtime information, and database metadata. * model - An empty database model - Used to clone new databases. * msdb - The background job scheduler - Used for background jobs and related tasks. * tempdb - The temporary database - Used by the server as a scratch pad. |
Is it helpful?
Yes
No
Most helpful rated by users:
- What is Microsoft SQL Server?
- What is the simplest way to create a new database in MS SQL Server?
- How to delete a database in MS SQL Server?
- How to download and install Microsoft .NET Framework Version 2.0?
- How To Get a List of Columns using the "sp_help" Stored Procedure in MS SQL Server?