What does the LEAD() window function return when the offset goes beyond the last row of the partition? SQL Data AnalystHard Try Now
Which scenario correctly demonstrates when a HASH JOIN is preferred over a MERGE JOIN? SQL Data AnalystHard Try Now
In window functions, what is the difference between RANGE and ROWS frame modes? SQL Data AnalystHard Try Now
What is the difference between TRUNCATE and DELETE when removing all rows from a table? SQL Data AnalystHard Try Now
What does FIRST_VALUE(revenue) OVER (PARTITION BY region ORDER BY sale_date) return for each row? SQL Data AnalystHard Try Now
Which type of SQL join can be used to detect rows in one table that have no corresponding rows in another? SQL Data AnalystHard Try Now
What SQL technique efficiently calculates subtotals and grand totals in a single query? SQL Data AnalystHard Try Now
You observe that a query performs well with a small dataset but degrades quadratically as data grows. Which join type is the likely culprit? SQL Data AnalystHard Try Now
What is the purpose of statistics in SQL Server or PostgreSQL query optimization? SQL Data AnalystHard Try Now
Which SQL construct allows you to define a temporary named result that can reference itself for hierarchical queries? SQL Data AnalystHard Try Now
What does LATERAL (or CROSS APPLY in SQL Server) allow in a FROM clause? SQL Data AnalystHard Try Now
An analyst wants to calculate the percentage each product’s sales contribute to total sales. Which SQL pattern correctly does this? SQL Data AnalystHard Try Now
