adspace


What is master database? : SQL Server Architecture

Answer Posted / Rohit Kumar Kele

"Master Database" is a system database in SQL Server that stores important system objects and metadata, such as server-level security, system configuration settings, and system databases. It does not store user data. The Master database helps manage the overall architecture of the SQL Server instance.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why should you use or avoid select * statements?

1112


How do I create a trace in sql server?

1121


What is sql or structured query language?

1228


What are the kinds of subquery?

1109


What are the different SQL Server Versions you have worked on?

1080


How to convert character strings into numeric values?

1192


Why we use the openxml clause?

1080


explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration

1134


do you know how to configure db2 side of the application? : Sql server database administration

1125


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

1048


List out the different types of locks available in sql server?

1051


How can we solve concurrency problems?

1123


What kind of problems occurs if we do not implement proper locking strategy?

1501


what is spatial nonclustered index

1060


How do I find query history in sql server?

1026