Answer Posted / Payal Agrawal
The model database serves as a template for creating new databases in SQL Server. It contains default settings and system objects that will be used when a new database is created.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Why use identity in sql server?
What is clustered index
what is spatial nonclustered index
List out the different types of locks available in sql server?
How do I start sql server 2017?
Explain system functions or built-in functions? What are different types of system functions?
What is a scheduled job or what is a scheduled task?
Explain “row_number()” in sql server with an example?
What is the difference between for xml raw and for xml auto?
How to convert numeric expression data types using the cast() function?
How to provide default values to function parameters?
What is sql server query analyzer?
Can we do dml on views?
How do I find the sql server version?
Can you index views?