PRIMARY KEY vs UNIQUE KEY vs FOREIGN KEY-Part 2 | UNIQUE KEY CONSTRAINT | UNIQUE KEY vs UNIQUE INDEX

PRIMARY KEY vs UNIQUE KEY vs FOREIGN KEY - Part 2 | UNIQUE KEY CONSTRAINT | UNIQUE KEY vs UNIQUE INDEX

PRIMARY KEY vs UNIQUE KEY, PRIMARY KEY vs FOREIGN KEY, PRIMARY KEY Constraint vs UNIQUE KEY Constraint, PRIMARY KEY Constraint vs FOREIGN KEY Constraint, Index vs Key, Unique Key vs Unique Index, Unique Clustered Index, non-clustered index,
composite key, candidate key, alternate key, HEAP in SQL, Key vs Index, WITH CHECK vs WITH NOCHECK FOREIGN KEY Constraint, Non-clustered PRIMARY KEY, Clustered Unique Key, PRIMARY KEY vs UNIQUE KEY vs FOREIGN KEY, PRIMARY KEY Constraint, UNIQUE KEY Constraint, FOREIGN KEY Constraint


Agenda:
-------------
QA. What is the difference between PRIMARY KEY and UNIQUE KEY?
QB. What is the difference between PRIMARY KEY and FOREIGN KEY?
QC. What is the difference between UNIQUE KEY and UNIQUE INDEX?

Q01. What is the difference between UNIQUE Constraint and UNIQUE INDEX in SQL?
Q02. If the primary key uniquely identified rows, then why bother about UNIQUE KEY?
Q03. Is NUll value allowed in the UNIQUE KEY column?
Q04. Can a UNIQUE KEY contain an empty(blank) value or whitespace?
Q05. Can you make the UNIQUE KEY column an identity column?
Q06. Can you create a UNIQUE KEY constraint on a PRIMARY KEY column?
Q07. Which type of index created by default for the UNIQUE KEY constraint?
Q08. If you DROP the UNIQUE constraint, does it also drop the UNIQUE index?
Q09. Can you add clustered Unique Index in any table?
Q10. Can you use UNIQUE KEY as a replacement for PRIMARY KEY?
Q11. Is it mandatory for a UNIQUE KEY to being a NonClustered index? Can a UNIQUE Key be created on Clustered Index?
Q12. Can you add the UNIQUE KEY constraint on a column that contains data already?
Q13. Can you update or delete the UNIQUE KEY value of a table that is referenced by the foreign key?
Q14. Can you make a varchar(max) column as UNIQUE KEY in SQL?
Q15. If you have to store the data in such a way that each and every record can be identified by a unique value. What will be your approach PRIMARY KEY or Unique Key?
Q16. If a NULL value never equals another NULL value, it means they are unique, then why only one NULL value is allowed in a UNIQUE key column?



Subscribe to our YouTube Channel: https://www.youtube.com/channel/UCgl6eGIDCu69Vg1UnxKj9Xw?sub_confirmation=1
Visit our Website for more Articles: https://www.techpointfunda.com


Recommended Videos Playlists:
============================================================
MVC videos Playlist: https://www.youtube.com/embed/videoseries?list=PL99CiVAQoSURc_KZGrsXX14-fLepJNNji
SQL Videos Playlist: https://www.youtube.com/embed/videoseries?list=PL99CiVAQoSUTgmk8f8FmdkC0DJpdkAXKJ
C# Interview Questions and Answers Videos Playlist: https://www.youtube.com/embed/videoseries?list=PL99CiVAQoSUQ7iYn7p7qumuYqzIAHJY6q
Visual Studio Tips and Tricks Videos Playlist: https://www.youtube.com/embed/videoseries?list=PL99CiVAQoSUSxTFfo50vqhMw6ee9CMaCs
Interview Questions and Answers Videos Playlist: https://www.youtube.com/embed/videoseries?list=PL99CiVAQoSUQGLXhfDFtnII91w_oLVjLB
C# Videos Playlist: https://www.youtube.com/embed/videoseries?list=PL99CiVAQoSUS_AbYw2Woe4IuLqJ1ecvW0
C# 8 Videos Playlist: https://www.youtube.com/embed/videoseries?list=PL99CiVAQoSURZR-oiFulBjQMGtjLFGuc1


Recommended SQL Videos:
============================================================
Primary Key video - https://youtu.be/64N6xu3LDy0
ROW_NUMBER() vs RANK() vs DENSE_RANK() video: https://youtu.be/WgIB2TUD2GQ

Recommended C# Interview Questions Videos:
============================================================
Sealed Class Interview QA Video: https://youtu.be/nJhNk9rvk6c
Static Class Interview QA Video: https://youtu.be/oYHHs7nb-X8
Abstract Class vs Interface Video: https://youtu.be/hVlTLTRSRfo

Recommended C# Videos:
============================================================
Abstract Class and Methods video: https://youtu.be/UWZFQASkgDE
Sealed Class Video: https://youtu.be/8ruDAINskGs
Static Class Video: https://youtu.be/POfQ9IrcEYA


Follow Us on Social Media Platforms:
============================================================
Follow us on Facebook: https://www.facebook.com/TechPointFundamentalsOfficials
Visit our Facebook Page: https://www.facebook.com/TechPointFundamentals
Follow us un WhatsApp group: https://chat.whatsapp.com/LPGCDnknv78DdMrqVqv1gD
Follow us on LinkedIn: https://www.linkedin.com/in/TechPointFundamentals
Follow us on Telegram: https://t.me/TechPointFundamantals
Follow us on VK: https://vk.com/techpointfundamentals
Follow us on Twitter: https://twitter.com/TechPointFunda
Follow us on Pinterest: https://www.pinterest.com/TechPointFundamentals
Follow us on Instagram: https://www.instagram.com/TechPointFundamentals
Follow us on Mix: https://mix.com/techpointfundmentals
Follow us on Tumblr: https://techpointfundamentals.tumblr.com

Тэги:

#Tech_point_fundamentals #www.techpointfunda.com #tech_point_fundamentals_videos #Tech_point_fundamental #Tech_point_funda #Tech_point #Tech_points_videos #Tech_points #Interview_questions #PRIMARY_KEY_vs_UNIQUE_KEY #PRIMARY_KEY_vs_FOREIGN_KEY #Index_vs_Key #Unique_Key_vs_Unique_Index #Unique_Clustered_Index #non-clustered_index #composite_key #candidate_key #alternate_key #Clustered_Unique_Key #PRIMARY_KEY_Constraint #UNIQUE_KEY_Constraint #FOREIGN_KEY_Constraint

Скачать видео