Sql Interview Question and Answers

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.
 
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.
 
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.
 
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
 
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.
 
Your Name Your Email-ID
Your Answer