What does the following query return? SELECT department, COUNT(*) FROM employees GROUP BY GROUPING SETS ((department), ()) SQL FundamentalsHard Try Now
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 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 is a deadlock in SQL and how does the database engine typically resolve it? SQL FundamentalsHard Try Now
What happens when implicit type conversion (coercion) occurs in a WHERE clause predicate? SQL FundamentalsHard Try Now
What does the ALL operator do in: salary > ALL (SELECT salary FROM managers)? SQL FundamentalsHard Try Now
What does an execution plan’s ‘Table Scan’ or ‘Seq Scan’ operator indicate? 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
