SQL Server Database Administrator Question:
Download Job Interview Questions and Answers PDF
What purpose does the model database serve?
Answer:
The model database, as its name implies, serves as the model (or template) for all databases created on the same instance. If the model database is modified, all subsequent databases created on that instance will pick up those changes, but earlier created databases will not. Note that TEMPDB is also created from model every time SQL Server starts up.
Download SQL Server DB Administrator Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How many bits IP Address consist of? | Tell me what is blocking and how would you troubleshoot it? |