Which SQL command is used to retrieve data from a database?
What does the WHERE clause do in SQL?
Which keyword is used to eliminate duplicate rows in SQL results?
What is the correct syntax for inserting data into a table?
Which SQL aggregate function returns the total sum of a numeric column?
Advertisement
What is the purpose of the JOIN clause in SQL?
Which type of JOIN returns only matching rows from both tables?
What will be the output of: SELECT COUNT(*) FROM employees;
Which SQL clause is used to sort the result set in ascending or descending order?
What is the difference between WHERE and HAVING clauses?
Which statement is used to modify existing data in a table?
What will be the result of this query: SELECT * FROM employees WHERE salary > 50000 AND department = 'IT';
Which SQL function is used to count non-NULL values in a column?
What does the PRIMARY KEY constraint ensure?
Which of the following SQL wildcards matches any single character?
Consider a table with columns: id, name, salary. If a row has NULL salary, what will SELECT * FROM table WHERE salary = NULL return?
What will be the output of: SELECT MAX(salary) FROM employees GROUP BY department;
Which SQL statement is used to delete all records from a table without removing the table structure?
What is the difference between UNION and UNION ALL in SQL?
Which of the following is the correct order of SQL clause execution?
