SQL Interview Questions

Q41 What is window function? Generate → Q42 What is ROW_NUMBER()? Generate → Q43 What is RANK() and DENSE_RANK()? Generate → Q44 What is partitioning in SQL? Generate → Q45 What is a composite index? Generate → Q46 What is execution plan? Generate → Q47 What is EXPLAIN in SQL? Generate → Q48 What is a schema in SQL? Generate → Q49 What is data integrity? Generate → Q50 What is referential integrity? Generate → Q51 Explain how indexing works internally. Generate → Q52 What is B-tree index? Generate → Q53 What is hash index? Generate → Q54 How does query optimizer work? Generate → Q55 What is cost-based optimization? Generate → Q56 What are different types of locks in SQL? Generate → Q57 Explain pessimistic vs optimistic locking. Generate → Q58 What is phantom read? Generate → Q59 What is dirty read? Generate → Q60 What is non-repeatable read? Generate →