SQL Administrator Question:

Tell us what is a system database and what is a user database?

SQL Administrator Interview Question
SQL Administrator Interview Question

Answer:

System databases are the default databases that are installed when the SQL Server is installed. Basically, there are 4 system databases: Master, MSDB, TempDB, and Model. It is highly recommended that these databases are not modified or altered for a smooth functioning of the SQL System.
A user database is a database that we create to store data and start working with the data.


Previous QuestionNext Question
Tell us how do you trace the traffic hitting a SQL Server?Tell us when setting Replication, is it possible to have a Publisher as 64 Bit SQL Server and Distributor or Subscribers as a 32 Bit SQL Server?