What are the basic functions for master, msdb, model, tempdb and resource databases?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

How do I clean up sql server transaction log?

0 Answers  


How can I track the changes or identify the latest insert-update-delete from a table?

0 Answers  


wht's the differece between sqlserver05 and sqlserver2000

3 Answers  


If no size is defined while creating the database, what size will the database have?

0 Answers  


What is a data source file?

0 Answers  






How display code or Text of Stored Procedure using Sql query in Sql Server ?

0 Answers   Wipro,


what is a stored procedure and trigger?

3 Answers  


What is the Difference Between Primary and Foreign Key?

0 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,


After removing a table from database, what other related objects have to be dropped explicitly?

0 Answers  


What is an extended stored procedure? Can you instantiate a COM object by using T-SQL?

3 Answers   HCL,


What is nested transaction?

0 Answers  


CREATE a table from another table

2 Answers  


Categories