SQL Interview Questions

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