a2zinterviews

41.	What is the use of DBCC commands?
	DBCC stands for database consistency checker. We use these commands to check the consistency of the databases, i.e., maintenance, validation task and status checks.
	Discuss Your Name Your Email-ID Your Answer

42.	What is a Linked Server?
	Linked Servers is a concept in SQL Server by which we can add other SQL Server to a Group and query both the SQL Server dbs using T-SQL Statements. With a linked server, you can create very clean, easy to follow, SQL statements that allow remote data to be retrieved, joined and combined with local data.
	Discuss Your Name Your Email-ID Your Answer

43.	What is Collation?
	Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.
	Discuss Your Name Your Email-ID Your Answer

44.	What are different type of Collation Sensitivity?
	The different phases of transaction are Case sensitivity Accent sensitivity Kana Sensitivity Width sensitivity
	Discuss Your Name Your Email-ID Your Answer

45.	What is the difference between a primary key and a unique key?
	Both primary key and unique enforce uniqueness of the column on which they are defined. But by default primary key creates a clustered index on the column, where are unique creates a nonclustered index by default. Another major difference is that, primary key doesn’t allow NULLs, but unique key allows one NULL only.
	Discuss Your Name Your Email-ID Your Answer