default databases available in sql server and there uses ?

Answer Posted / rajesh bhawsar

1.Model
Model database is templete. when u create new database
system gives u a copy of model database
2.Tempdb
Tempdb is scratchpad of sql server
3.msdb
4.master

Is This Answer Correct ?    5 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is table constraint?

541


Please illustrate physical database architecture? : SQL Server Architecture

535


How can you find out which stored procedures are recompiling?

516


Which feature in sql server 2008 has surprised you? You can name just one. : sql server database administration

502


What is the return type of executeupdate ()?

525






Explain the difference between control flow and data flow?

529


How do you open a cluster administrator?

628


explain how to create a new schema in a database? : Sql server database administration

584


what information is maintained within the msdb database? : Sql server administration

511


What is your recommendation for a query running very slow? : sql server database administration

595


Why is sql server log file full?

540


Which are new data types introduced in sql server 2008?

605


What are trace flags and mention a few common trace flags used with sql server?

554


what are the critical issues you have resloved in your company

1552


What is the default order of an order by clause?

584