Explain about system database?



Explain about system database?..

Answer / Gangadhar Choudhary

The System Database (sysdb) in SQL Server is a hidden, system-only database that is created when the instance of SQL Server is installed. It contains various system objects and metadata used by SQL Server itself. It cannot be accessed directly by users or applications. Instead, users interact with the master database which has a read-only view of some of the system objects in the System Database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is compound operators?

1 Answers  


what is a check constraint?

1 Answers  


What are different types of raid levels?

1 Answers  


What is a primary index?

1 Answers  


write the query for find the top 2 highest salary in sql server

36 Answers   Cranes, Jayanti Software, Medi Assist, Rmax, TCS,


find 2nd highest salary of person using cursor concept?

6 Answers   HCL,


 Explain what is sql override for a source taLle in a mapping?

1 Answers   Informatica,


What are logical database components? : SQL Server Architecture

1 Answers  


what stored procedure can you use to display the current processes? : Sql server administration

1 Answers  


Delete duplicate records from the table?(Table must have unique id)

7 Answers   TCS, Thomson Reuters,


What are the main control-of-flow T-SQL constructs?

1 Answers  


When would you use it?

1 Answers  


Categories