F1-Quiz

Which of the following clauses is used to filter rows returned by a SQL query?

• SELECT

• ORDER BY

• WHERE

• GROUP BY

What will the following query return?

SELECT DISTINCT city FROM customers;

• All the cities in the customers table

• Only unique cities from the customers table

• All customers in the customers table

• Unique customer IDs

Which keyword is used to sort the result set in ascending or descending order?

• SORT BY

• ORDER BY

• GROUP BY

• FILTER BY

Which of the following clauses is used to group rows that have the same values?

• GROUP BY

• ORDER BY

• WHERE

• HAVING

Which of the following SQL queries will return rows where the column status is not null?

• • WHERE status IS NULL

• WHERE status != NULL

• WHERE status NOT NULL

• WHERE status IS NOT NULL

What is the result of the following query?

SELECT name FROM students WHERE grade IS NOT NULL;

• It will return all students whose grades are NOT NULL

• It will return all students with a grade of 'NULL'

• It will throw an error

• It will return all students, regardless of their grade

Which of the following statements will delete a record from a table?

• DELETE FROM table_name WHERE condition;

• REMOVE FROM table_name WHERE condition;

• REMOVE table_name WHERE condition;

• • DELETE table_name WHERE condition;

Which SQL operator is used to search for a specified pattern in a column?

• IN

• LIKE

• BETWEEN

• IS

Which of the following is a valid use of a wildcard character in the LIKE clause?

• % to represent any sequence of characters

• _ to represent any single character

• # to represent any number

• no answer

Which of the following SQL queries uses the IN operator correctly?

• SELECT * FROM employees WHERE department = ('HR', 'Finance');

• SELECT * FROM employees WHERE department IN ('HR', 'Finance');

• SELECT * FROM employees WHERE department LIKE 'HR, Finance';

• SELECT * FROM employees WHERE department = 'HR' OR department = 'Finance';