Sql Server Interview Questions -

Understand the physical difference between Clustered Indexes (stores actual data in sorted order) and Non-Clustered Indexes (stores pointers to the data).

Be ready to define its purpose—reducing data redundancy—and explain the different normal forms (1NF, 2NF, 3NF). SQL Server Interview Questions

Know how Primary Keys (no NULLs, unique) and Foreign Keys (links tables) maintain referential integrity. SQL Server Interview Questions