SQL

List of SQL Interview Question

• Difference between Primary key and Foreign key
• Difference between Truncate and Delete
• Indexes
• Definition
• Types
• Difference between Cluster and Non Cluster Index
• Unique Index
• Store Procedure
• Definition
• Type
• Difference between Inline Query and Store Procedure
• Advantage of Store Procedure
• Triggers
• Definition
• Type
• Difference between DML or DLL Trigger
• Advantage of Triggers
• Disadvantage of Triggers
• Purpose of Triggers
• Magic Table