What does the SQL window frame RANGE BETWEEN CURRENT ROW AND UNBOUNDED FOLLOWING compute? SQL FundamentalsHard Try Now
Which of the following queries correctly finds the second-highest salary without using LIMIT or TOP? SQL FundamentalsHard Try Now
What is the result of the following NULL arithmetic: SELECT 5 + NULL * 2? SQL FundamentalsHard Try Now
What does the DEFERRABLE INITIALLY DEFERRED constraint option do in PostgreSQL? SQL FundamentalsHard Try Now
What is a deadlock in SQL and how does the database engine typically resolve it? SQL FundamentalsHard Try Now
What does the following query pattern accomplish? SELECT e.* FROM employees e LEFT JOIN managers m ON e.id = m.employee_id WHERE m.employee_id IS NULL SQL FundamentalsHard Try Now
What happens when implicit type conversion (coercion) occurs in a WHERE clause predicate? SQL FundamentalsHard Try Now
What does an execution plan’s ‘Table Scan’ or ‘Seq Scan’ operator indicate? SQL FundamentalsHard Try Now
What does the ALL operator do in: salary > ALL (SELECT salary FROM managers)? SQL FundamentalsHard Try Now
What is the difference between a HAVING clause with an aggregate and a WHERE clause for the same logical filter? SQL FundamentalsHard Try Now
What does the following window function return for the third row? LAG(salary, 2, 0) OVER (ORDER BY hire_date) SQL FundamentalsHard Try Now
What does the following query return? SELECT * FROM employees WHERE department_id = ANY (SELECT id FROM departments WHERE budget > 500000) SQL FundamentalsHard Try Now
What isolation level prevents dirty reads, non-repeatable reads, and phantom reads? SQL FundamentalsHard Try Now
