Interested to Buy Any Domain ? << Click Here >> for more details...
default databases available in sql server and there uses ?
- 4 Answers
- 7070 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
What is checkpoint in sql server?
What is lock escalation? : sql server database administration
do views contain data ?
What are the characteristics of modern DBMS?
What is correlated subquery in sql server?
What is the difference between a clustered index and a non-clustered index?
How many categories of data types used by sql server?
Do you know what is a with(nolock)?
What command is used to delete a table from the database in the sql server and how?
What is #table in sql server?
How do I start sql server 2017?
What is the primary use of the model database?
Types of Authentications in Sql Server? How user gets authenticated through windows authentication?
Explain left outer join and right outer join?
Explain an incremental backup?
