What happens when a partial index is defined as CREATE INDEX idx ON orders(customer_id) WHERE status = ‘OPEN’? Advanced SQL DeveloperHard Try Now
In PostgreSQL, what does a BRIN index store and when is it most effective? Advanced SQL DeveloperHard Try Now
What is the effect of creating a function-based index on UPPER(last_name) in Oracle/PostgreSQL? Advanced SQL DeveloperHard Try Now
What is the difference between TRUNCATE and DELETE when removing all rows from a table? SQL Data AnalystHard Try Now
Which scenario correctly demonstrates when a HASH JOIN is preferred over a MERGE JOIN? SQL Data AnalystHard Try Now
What does the LEAD() window function return when the offset goes beyond the last row of the partition? 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
What does LATERAL (or CROSS APPLY in SQL Server) allow in a FROM clause? 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 is the purpose of statistics in SQL Server or PostgreSQL query optimization? 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 SQL technique efficiently calculates subtotals and grand totals in a single query? 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
