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

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

0 Answers   Satyam,


Are connections to sql server encrypted?

0 Answers  


What is page in sql server?

0 Answers  


What is difference between line feed ( ) and carriage return ( )?

0 Answers  


what is the primary use of the model database? : Sql server administration

0 Answers  






What is DCL?

0 Answers  


What are statistics, under what circumstances they go out of date, how do you update them?

2 Answers   HCL,


What do you mean by sql server agent?

0 Answers  


What is the query optimization statistics?

1 Answers  


How many types of triggers in sql server?

0 Answers  


How many full-text indexes can a table have?

0 Answers  


Mention the different authentication modes in sql server.

0 Answers  


Categories