Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 7128 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / selvam
There are 5 default DB's in Sql server
1. Master - Contains all of the system level information
2. Model- Used as a template db for all db instances created in SQL Server
3. Msdb -- It used by sql server agent, Mail Service
4. Tempdb -- Contains temporary objects and intermediate results
5. Resource -- it is read only db that contains system objects that are included with sql server
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain the functionalities that views support?
What are the different types of subquery?
Explain the purpose of indexes?
What are page splits?
What is meant by indexing?
Why Master database is required?
How to create dbo table in sql server?
What do you mean by normalisation?
Is the primary key column of a table an index in ms sql server?
Why use sub query in sql server and list out types of sub queries?
What are acid properties of transaction?
Why we use functions in sql server?
What does it mean to manipulate data?
Why do we use non clustered index?
Give an example of why you would want to denormalize a database
