Explain what are the basic functions for master, msdb, model, tempdb databases?


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

Post New Answer

More SQL Server Interview Questions

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database?

0 Answers  


What does indexation mean?

0 Answers  


write a query to remove duplicate records without using primary key column?

2 Answers   ABCO,


What is the difference between 2-Tier architecture and 3-Tier architecture

15 Answers   CTS, MCN Solutions, Oracle,


What do you understand by the analysis services in sql server?

0 Answers  






hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution

2 Answers  


How do I find the sql server database version?

0 Answers  


What is data compression? : sql server database administration

0 Answers  


What does this statement do @@rowcount?

0 Answers  


Can you please explain the difference between function and stored procedure?

0 Answers  


You have several tables, and they are joined together for querying. The tables contain both clustered indexes and non clustered indexes to optimize performance, how should you distribute the tables and their indexes onto different file groups?

0 Answers  


How to access the inserted record of an event?

0 Answers  


Categories