c# (Csharp) and SQL interview question :- What is the difference between unique key and primary key?
For more such videos visit http://www.questpond.com
For more such videos subscribe / questpondvideos
See our other Step by Step video series below :-
Learn Data Science in 1 hour :- https://tinyurl.com/y5o7qbau
Learn Power BI Step by Step:- https://tinyurl.com/y6thhkxw
Learn MSBI Step by Step in 32 hours:- https://goo.gl/TTpFZN
Learn Tableau step by step :- https://tinyurl.com/kh6ojyo
Learn SQL Server Step by Step http://tinyurl.com/ja4zmwu
Learn Angular tutorial step by step https://tinyurl.com/ycd9j895
Learn MVC Core step by step :- http://tinyurl.com/y9jt3wkv
Learn C# Step by Step https://goo.gl/FNlqn3
Learn Design Pattern Step by Step https://goo.gl/eJdn0m
Learn SharePoint Step by Step in 8 hours:- https://goo.gl/XQKHeP
Unique key can have nulls
Primary key cannot have nulls.
In a single table we can create multiple unique keys.In a single table we can have only one primary key.
=============================================
Unique key creates a non-clustered index by default.Primary Key created a clustered index by default.
================================================
Both unique keys and primary keys can be referenced by foreign key.
For more such videos visit http://www.questpond.com
We are also distributing a 100 page Ebook "Sql Server Interview Questions ". If you want this ebook please share this video in your facebook/twitter/linkedin account and email us on [email protected] with the shared link and we will email you the PDF.
Buy Questpond videos on discount - http://www.itfunda.com/Interview