What does the following recursive CTE produce? WITH RECURSIVE nums AS ( SELECT 1 AS n UNION ALL SELECT n + 1 FROM nums WHERE n < 5 ) SELECT n FROM nums SQL FundamentalsHard Try Now
What isolation level prevents dirty reads, non-repeatable reads, and phantom reads? SQL FundamentalsHard Try Now
What is the key difference between a clustered and a non-clustered index? SQL FundamentalsHard Try Now
What is the output of the following query? SELECT COALESCE(NULL, NULL, 3, NULL, 5) SQL FundamentalsHard Try Now
Which SQL clause is required when using an aggregate function to also display non-aggregated columns? SQL FundamentalsMedium Try Now
What does the NULLIF(expr1, expr2) function return when expr1 equals expr2? SQL FundamentalsMedium Try Now
What is the output of: SELECT 5 / 2 in most SQL databases using integer division? SQL FundamentalsMedium Try Now
What does the following query do? SELECT dept_id, AVG(salary) FROM employees GROUP BY dept_id HAVING AVG(salary) > 60000 SQL FundamentalsMedium Try Now
