What does `dict.get(‘key’, ‘default’)` return when ‘key’ is not in the dictionary? Python DeveloperEasy Try Now
What is the purpose of `RETURNING` clause in PostgreSQL DML statements? Advanced SQL DeveloperMedium Try Now
What does `WITHIN GROUP (ORDER BY col)` do with ordered-set aggregate functions like `PERCENTILE_CONT()`? Advanced SQL DeveloperMedium Try Now
What is the difference between `UNION` and `UNION ALL` in terms of performance? Advanced SQL DeveloperMedium Try Now
What does `SELECT FOR UPDATE` do in SQL and when would you use it? Advanced SQL DeveloperMedium Try Now
What is a bitmap index scan in PostgreSQL and when does the optimizer prefer it? Advanced SQL DeveloperMedium Try Now
What is the `GROUPING()` function used for in SQL with ROLLUP or CUBE? Advanced SQL DeveloperMedium Try Now
