SQL Interview Questions

Q61 Explain database sharding. ✓ Answered → Q62 What is database replication? ✓ Answered → Q63 What is database clustering? ✓ Answered → Q64 What is partition pruning? ✓ Answered → Q65 What is CTE (Common Table Expression)? ✓ Answered → Q66 What is recursive CTE? ✓ Answered → Q67 What is difference between CTE and subquery? ✓ Answered → Q68 How does indexing impact write performance? ✓ Answered → Q69 What is composite primary key? ✓ Answered → Q70 What is foreign key cascade delete? ✓ Answered → Q71 What are database constraints? ✓ Answered → Q72 What is query tuning? ✓ Answered → Q73 How to optimize slow queries? ✓ Answered → Q74 What is normalization vs denormalization trade-off? ✓ Answered → Q75 What is materialized view refresh? ✓ Answered → Q76 What is stored procedure optimization? ✓ Answered → Q77 What is database indexing strategy? ✓ Answered → Q78 What is cardinality in SQL? ✓ Answered → Q79 What is covering index? ✓ Answered → Q80 What is index scan vs index seek? ✓ Answered →