InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
What Is A System Database And What Is A User Database? |
|
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 smooth functioning of the SQL System. A USER DATABASE is a database that we create to STORE data and START working with the data. 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 smooth functioning of the SQL System. A user database is a database that we create to store data and start working with the data. |
|