Interested to Buy Any Domain ? << Click Here >> for more details...
What is the basic functions for master, msdb, tempdb databases?
- 2 Answers
- 17063 Views
- CSC, I also Faced
- E-Mail Answers
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
Mention the 3 ways to get a count of the number of records in a table.
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
Explain primary key and foreign key constraints?
Why de-normalization required?
What is the bookmark lookup and rid lookup?
Do you know what are the properties of the relational tables?
what are the disadvantages of cursors? : Sql server database administration
Which autogrowth database setting is good?
how to create “alternate row colour”?
Describe in brief authentication modes in sql server.
How to create a testing table with test data in ms sql server?
What are the tables in sql?
What are different backups available in sql server?
How to optimize stored procedure optimization?
Explain trigger classes i.e. Instead of and after trigger?
