Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

One table Test with single column. These are the values in the table a b c d e f g h I need a query (without using any variable) with output as - a b c d e f g h

1 Answers  


What is identity?

0 Answers  


Explain database normalization?

0 Answers  


Which index created when Create Index on table(col), Why

2 Answers   CGI,


You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?

0 Answers  






What do you understand by coalesce in sql server?

0 Answers  


What are the advantages of mirroring?

0 Answers  


How sql server enhances scalability of the database system?

0 Answers  


How do I start and stop sql server?

0 Answers  


How do I create a trace in sql server?

0 Answers  


What are the different types of columns types constraints in the sql server?

0 Answers  


How to view existing indexes on an given table using sp_help?

0 Answers  


Categories