In SQL, which clause is used to filter groups based on aggregate function results?
Which data type in SQL is used to store large text documents or binary data?
What is the purpose of the DISTINCT keyword in SQL?
Which SQL JOIN returns only matching rows from both tables?
What will be the result of: SELECT 10 % 3; in SQL?
Advertisement
Which aggregate function ignores NULL values by default?
Given a table 'employees' with salary column, which query finds employees earning more than average salary?
What is the difference between CROSS JOIN and INNER JOIN?
Which statement correctly uses aliases in SQL?
For a query with transactions table, which index type is most efficient for WHERE clauses checking transaction_date range?
What is the output of: SELECT COALESCE(NULL, NULL, 'SQL', 'Database');?
In a normalized database following 3NF, which anomaly is prevented?
Which of the following queries demonstrates a self-join correctly?
What will be the result of: SELECT COUNT(DISTINCT department) FROM employees WHERE salary > 50000;?
For optimizing a query with multiple JOINs and subqueries, which approach is most effective for 2024 databases?
Which scenario requires using PARTITION BY in window functions instead of GROUP BY?
A table has 1M rows. Query A uses WHERE on non-indexed column, Query B uses indexed column in WHERE. Expected performance difference?
What is the result of: SELECT CASE WHEN 1=1 THEN 'A' WHEN 2=2 THEN 'B' ELSE 'C' END;?
In concurrent transaction scenarios, which isolation level allows dirty reads?
Which SQL command is used to remove all records from a table without removing the table structure?
