SQL Server Interview Questions: Part1

1. Name the system Databases in SQL Server ? (or) What are System Databases?
2. How to find the size of a database?
3. What is the purpose of sp_helpdb?
4. What is the purpose of sp_database?
5. What is use of sys.master_files table?
6. which command will delete backup history from msdb?
7. Can we create the objects in system databases?
8. How to check whether Resource database exists in server or not?
9. What is DBMS(Database Management System)?
10. Difference between different versions of SQL Server?