11. What is Master database?
12. What is Model database?
Model database it acts as template to create the new database. This new database contains some options of model database.
13. What is MSDB database?
Msdb contains information about 1.jobs, 2.alerts.3.operation
14. What is TEMPdb database?
It is user for store the temporary transactins. Whenever create sql server new TEMPdb created.
15. What is Restore database?
Restore is introduced from 2005 onwards. It contains system objects .It is hidden database.Restore database id is 32767.
16. What is User Databese?
User Database are Created and Maintainced by the user .
17.History of SQL Server?
Sql server originally developed and implemented by Sybase database. But licensed by Microsoft in 1988 for OS/2 operating system and began implementing it for windows o/s in the early 1990
18. Important Features of Sql Server?
19. Version of sql server?
The versions are
20. How many types of files?
Ans .Every database is a collection of two files