What are system databases in ms sql server?



What are system databases in ms sql server?..

Answer / Nikul Singh

System databases in MS SQL Server are databases that are created automatically during installation and are used to store system objects, configuration settings, and other important data. Examples of system databases include master, model, tempdb, and msdb.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration

1 Answers  


What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,


What are clustered and non-clustered index?

1 Answers  


What is scan table/view and seek table/view when its occurs? : sql server database administration

1 Answers  


What is database architecture? : SQL Server Architecture

1 Answers  


What is trigger explain with program?

1 Answers  


How to change the system date and time from SQL Plus Terminal ?

1 Answers   MCN Solutions,


can any body tell me how to know the password of current user in sql server

1 Answers   Crea, HCL,


What is difference between clustered and non clustered index?

1 Answers  


How do you create a clustered index?

1 Answers  


How many types of built in functions are there in sql server 2012?

1 Answers  


is it important for a database administrator to understand the operating system and file access? : Sql server administration

1 Answers  


Categories