What is the basic functions for master, msdb, tempdb databases?
Answer Posted / pinak
the basics function of master is "it stores all sytem level
information in it, all databases which need for user
defineed database.
msdb is microsoft database.it works just like a recorder.
tempdb is a temprary database.
| Is This Answer Correct ? | 8 Yes | 10 No |
Post New Answer View All Answers
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
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?
How column data types are determined in a view?
How to execute the cursor queries with "open" statements?
What is CTE in SQL
How to use “drop” keyword in sql server and give an example?
What is serializable?
What is cte (common table expression)?
What is a transact-sql statement batch in ms sql server?
What is dynamic cursor in SQL SERVER?
What is query processing?
what are the different types of SSRS reports?
How do you create an execution plan?
Describe the functionalities that views support.
What is the command to change the recovery model?