⟩ Explain what are the basic functions for master, msdb, model, tempdb databases?
The Master database contains catalog and data for all databases of the SQL Server instance and it holds the engine together. Because SQL Server cannot start if the master database is not working.
The msdb database contains data of database backups, SQL Agent, DTS packages, SQL Server jobs, and log shipping.
The tempdb contains temporary objects like global and local temporary tables and stored procedures.
The model is a template database which is used for creating a new user database.