What is a hash partition strategy and when does it outperform range partitioning? Advanced SQL DeveloperHard Try Now
What is the purpose of EXPLAIN (ANALYZE, BUFFERS) in PostgreSQL compared to plain EXPLAIN? Advanced SQL DeveloperHard Try Now
In SQL Server, what is the purpose of the NOLOCK query hint and what risk does it introduce? Advanced SQL DeveloperHard Try Now
What does the DEFERRABLE INITIALLY DEFERRED constraint option do in PostgreSQL? Advanced SQL DeveloperHard Try Now
What is an INSTEAD OF trigger and on what database object is it typically defined? Advanced SQL DeveloperHard Try Now
In PostgreSQL, what is the difference between a BEFORE trigger and an AFTER trigger on a row-level INSERT? Advanced SQL DeveloperHard Try Now
What does the SQL standard GENERATED ALWAYS AS (expression) STORED column do? Advanced SQL DeveloperHard Try Now
What is a write skew anomaly and which isolation level prevents it? Advanced SQL DeveloperHard Try Now
Which isolation level uses multiversion concurrency control (MVCC) snapshots to present a consistent view of the database as of the transaction start time? Advanced SQL DeveloperHard Try Now
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
