What is model database? : sql server architect



What is model database? : sql server architect..

Answer / Girish Chanfra Semwal

"The Model database in SQL Server is a system database that contains the default settings and configurations for a new database. It is used as a template when creating new databases, as it includes the system tables needed for database functionality. The Model database should not be directly modified, but rather used to make changes that can then be applied to other databases by copying them from the Model database."

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More DB Architecture Interview Questions

what are the components of database architecture?

6 Answers   Wipro,


What is a business logic layer?

1 Answers  


What is Query evaluation engine?

1 Answers  


What is Data Model?

1 Answers  


What is a two tier wage system?

1 Answers  


how to find the fifth highest salary?

8 Answers   IBM, Infosys,


What is one tier architecture?

1 Answers  


What is an Extension of entity type?

1 Answers  


What is 1 NF (Normal Form)?

1 Answers  


What are the three levels of database architecture?

1 Answers  


What is DDL Interpreter?

1 Answers  


What is 5NF?

1 Answers  


Categories